Query Metrics

39 Database Queries
10 Different statements
4.76 ms Query time
5 Invalid entities
61 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.52 ms
(31.87%)
14
SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.id = ?
Parameters:
[
  19
]
0.97 ms
(20.37%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.matomo_url AS matomo_url_18, t0.matomo_js AS matomo_js_19, t0.matomo_tracker AS matomo_tracker_20, t0.google_map AS google_map_21, t0.maintenance AS maintenance_22, t0.logo AS logo_23, t0.fav_icon AS fav_icon_24, t0.contact_url AS contact_url_25, t0.contact_background AS contact_background_26, t0.contact_latitude AS contact_latitude_27, t0.contact_longitude AS contact_longitude_28, t0.type_map AS type_map_29, t0.tarte_au_citron_url AS tarte_au_citron_url_30, t0.tarte_au_citron_js AS tarte_au_citron_js_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.default_blog_image AS default_blog_image_34, t0.default_auction_image AS default_auction_image_35 FROM site t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.63 ms
(13.19%)
4
SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.display = ?
Parameters:
[
  1
]
0.37 ms
(7.72%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter t0 WHERE t0.public = ?
Parameters:
[
  1
]
0.32 ms
(6.68%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter_module t0 WHERE t0.public = ?
Parameters:
[
  1
]
0.31 ms
(6.57%)
2
SELECT t0.id AS id_1, t0.type AS type_2, t0.url AS url_3, t0.open_window AS open_window_4, t0.name AS name_5, t0.display AS display_6, t0.position AS position_7, t0.type_blog AS type_blog_8, t0.border AS border_9, t0.parent_position AS parent_position_10, t0.color_specifique AS color_specifique_11, t0.color AS color_12, t0.background_specifique AS background_specifique_13, t0.background AS background_14, t0.display_in_menu_mobile AS display_in_menu_mobile_15, t0.display_picto_mobile AS display_picto_mobile_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.page_id AS page_id_19, t0.group_id AS group_id_20 FROM menu_item t0 INNER JOIN menu_item_menu_item ON t0.id = menu_item_menu_item.menu_item_source WHERE menu_item_menu_item.menu_item_target = ?
Parameters:
[
  239
]
0.29 ms
(6.03%)
2
SELECT t0.id AS id_1, t0.type AS type_2, t0.url AS url_3, t0.open_window AS open_window_4, t0.name AS name_5, t0.display AS display_6, t0.position AS position_7, t0.type_blog AS type_blog_8, t0.border AS border_9, t0.parent_position AS parent_position_10, t0.color_specifique AS color_specifique_11, t0.color AS color_12, t0.background_specifique AS background_specifique_13, t0.background AS background_14, t0.display_in_menu_mobile AS display_in_menu_mobile_15, t0.display_picto_mobile AS display_picto_mobile_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.page_id AS page_id_19, t0.group_id AS group_id_20 FROM menu_item t0 WHERE t0.group_id = ?
Parameters:
[
  1
]
0.13 ms
(2.71%)
1
SELECT t0.id AS id_1, t0.background AS background_2, t0.color AS color_3, t0.color_active AS color_active_4, t0.font_size AS font_size_5, t0.position AS position_6, t0.display AS display_7, t0.text_align AS text_align_8, t0.title AS title_9, t0.background_mobile AS background_mobile_10, t0.color_mobile AS color_mobile_11, t0.color_mobile_active AS color_mobile_active_12, t0.opacity AS opacity_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM menu t0 WHERE t0.display = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.13 ms
(2.63%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.menu_id AS menu_id_7 FROM menu_group t0 WHERE t0.menu_id = ?
Parameters:
[
  1
]
0.11 ms
(2.24%)
1
SELECT t0.id AS id_1, t0.background_color AS background_color_2, t0.text AS text_3, t0.display AS display_4, t0.position AS position_5, t0.days AS days_6, t0.button_background_color AS button_background_color_7, t0.button_font_color AS button_font_color_8, t0.button_font_size AS button_font_size_9, t0.button_text AS button_text_10, t0.button_url AS button_url_11, t0.button_display AS button_display_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM bandeau t0 WHERE t0.display = ? ORDER BY t0.position ASC
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Page 20
Clockbox\Core\Entity\MenuItem 18
Clockbox\Core\Entity\Page 14
App\Entity\Parameter 4
Clockbox\Core\Entity\MenuGroup 2
App\Entity\Site 1
App\Entity\Menu 1
Clockbox\Core\Entity\Menu 1

Entities Mapping

Class Mapping errors
Clockbox\Core\Entity\Site No errors.
App\Entity\Site No errors.
Clockbox\Core\Entity\Page No errors.
App\Entity\Page No errors.
Clockbox\Core\Entity\PageSection No errors.
App\Entity\PageSection
  • The target entity 'Clockbox\Blog\Entity\BlogCategory' specified on App\Entity\PageSection#blogCategories is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Parameter No errors.
App\Entity\Parameter No errors.
Clockbox\Core\Entity\ParameterModule No errors.
App\Entity\ParameterModule No errors.
Clockbox\Core\Entity\Menu
  • The target entity 'Clockbox\Core\Entity\MenuGroup' specified on Clockbox\Core\Entity\Menu#groups is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Menu
  • The target entity 'Clockbox\Core\Entity\MenuGroup' specified on App\Entity\Menu#groups is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\MenuGroup
  • The target entity 'Clockbox\Core\Entity\Menu' specified on Clockbox\Core\Entity\MenuGroup#menu is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Clockbox\Core\Entity\Bandeau No errors.
App\Entity\Bandeau No errors.
Clockbox\Core\Entity\MenuItem
  • The target entity 'Clockbox\Core\Entity\Page' specified on Clockbox\Core\Entity\MenuItem#page is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.