Query Metrics
53
Database Queries
16
Different statements
10.96 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.22 ms (38.51%) |
20 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.params AS params_3, t0.denomination AS denomination_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.facebook_title AS facebook_title_7, t0.facebook_description AS facebook_description_8, t0.facebook_image AS facebook_image_9, t0.twitter_title AS twitter_title_10, t0.twitter_description AS twitter_description_11, t0.twitter_image AS twitter_image_12, t0.redirection AS redirection_13, t0.url_redirection AS url_redirection_14, t0.noindex AS noindex_15, t0.nofollow AS nofollow_16, t0.noodp AS noodp_17, t0.noimageindex AS noimageindex_18, t0.noarchive AS noarchive_19, t0.nosnippet AS nosnippet_20, t0.tag_manager AS tag_manager_21, t0.tag_manager_no_script AS tag_manager_no_script_22, t0.category AS category_23, t0.category_footer_id AS category_footer_id_24 FROM front_route t0 WHERE t0.id = ?
Parameters:
[
111
]
|
1.21 ms (11.04%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.url_custom AS url_custom_4, t0.ancrage AS ancrage_5, t0.parent_id AS parent_id_6, t0.route_id AS route_id_7 FROM menu_sub_items t0 WHERE t0.parent_id = ?
Parameters:
[
18
]
|
1.04 ms (9.50%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.params AS params_3, t0.denomination AS denomination_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.facebook_title AS facebook_title_7, t0.facebook_description AS facebook_description_8, t0.facebook_image AS facebook_image_9, t0.twitter_title AS twitter_title_10, t0.twitter_description AS twitter_description_11, t0.twitter_image AS twitter_image_12, t0.redirection AS redirection_13, t0.url_redirection AS url_redirection_14, t0.noindex AS noindex_15, t0.nofollow AS nofollow_16, t0.noodp AS noodp_17, t0.noimageindex AS noimageindex_18, t0.noarchive AS noarchive_19, t0.nosnippet AS nosnippet_20, t0.tag_manager AS tag_manager_21, t0.tag_manager_no_script AS tag_manager_no_script_22, t0.category AS category_23, t0.category_footer_id AS category_footer_id_24 FROM front_route t0 WHERE t0.category_footer_id = ?
Parameters:
[
1
]
|
0.81 ms (7.36%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM cms_category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Pratique"
]
|
0.68 ms (6.24%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.content AS content_4, t0.image AS image_5, t0.type AS type_6, t0.position AS position_7, t0.cms_id AS cms_id_8 FROM cms_blocs t0 WHERE t0.cms_id = ?
Parameters:
[
16
]
|
0.49 ms (4.47%) |
2 |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.params AS params_2, f0_.denomination AS denomination_3, f0_.meta_title AS meta_title_4, f0_.meta_description AS meta_description_5, f0_.facebook_title AS facebook_title_6, f0_.facebook_description AS facebook_description_7, f0_.facebook_image AS facebook_image_8, f0_.twitter_title AS twitter_title_9, f0_.twitter_description AS twitter_description_10, f0_.twitter_image AS twitter_image_11, f0_.redirection AS redirection_12, f0_.url_redirection AS url_redirection_13, f0_.noindex AS noindex_14, f0_.nofollow AS nofollow_15, f0_.noodp AS noodp_16, f0_.noimageindex AS noimageindex_17, f0_.noarchive AS noarchive_18, f0_.nosnippet AS nosnippet_19, f0_.tag_manager AS tag_manager_20, f0_.tag_manager_no_script AS tag_manager_no_script_21, f0_.category AS category_22, f0_.category_footer_id AS category_footer_id_23 FROM front_route f0_ WHERE f0_.name = ?
Parameters:
[
"app_front_cms_all"
]
|
0.44 ms (4.01%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.url AS url_4, t0.active AS active_5, t0.position AS position_6 FROM reseau_social t0 WHERE t0.active = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
0.32 ms (2.91%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM partenaire_category t0
Parameters:
[] |
0.32 ms (2.89%) |
2 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.url_partenaire AS url_partenaire_3, t0.name AS name_4, t0.category_footer_id AS category_footer_id_5 FROM partenaire_footer t0 WHERE t0.category_footer_id = ?
Parameters:
[
4
]
|
0.29 ms (2.68%) |
2 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.url_partenaire AS url_partenaire_3, t0.name AS name_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.phone AS phone_8, t0.adresse AS adresse_9, t0.city AS city_10, t0.postal_code AS postal_code_11, t0.category_id AS category_id_12 FROM partenaire t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
0.26 ms (2.36%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.subtitle AS subtitle_2, c0_.description AS description_3, c0_.content AS content_4, c0_.date AS date_5, c0_.slug AS slug_6, c0_.active AS active_7, c0_.image AS image_8, c0_.relation_id AS relation_id_9 FROM cms c0_ WHERE c0_.relation_id = ? ORDER BY c0_.date DESC
Parameters:
[
6
]
|
0.22 ms (1.99%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM contact t0
Parameters:
[] |
0.20 ms (1.85%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.params AS params_3, t0.denomination AS denomination_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.facebook_title AS facebook_title_7, t0.facebook_description AS facebook_description_8, t0.facebook_image AS facebook_image_9, t0.twitter_title AS twitter_title_10, t0.twitter_description AS twitter_description_11, t0.twitter_image AS twitter_image_12, t0.redirection AS redirection_13, t0.url_redirection AS url_redirection_14, t0.noindex AS noindex_15, t0.nofollow AS nofollow_16, t0.noodp AS noodp_17, t0.noimageindex AS noimageindex_18, t0.noarchive AS noarchive_19, t0.nosnippet AS nosnippet_20, t0.tag_manager AS tag_manager_21, t0.tag_manager_no_script AS tag_manager_no_script_22, t0.category AS category_23, t0.category_footer_id AS category_footer_id_24 FROM front_route t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"app_front_cms_all"
]
|
0.20 ms (1.82%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM menu_name t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"header_menu"
]
|
0.13 ms (1.23%) |
1 |
SELECT t0.id AS id_1, t0.categorie_name AS categorie_name_2 FROM category_footer t0
Parameters:
[] |
0.12 ms (1.12%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.parent AS parent_3, t0.position AS position_4, t0.url_custom AS url_custom_5, t0.ancrage AS ancrage_6, t0.menu_id AS menu_id_7, t0.route_id AS route_id_8 FROM menu_items t0 WHERE t0.menu_id = ? 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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Admin\CmsCategory | No errors. |
App\Entity\Admin\Cms | No errors. |
App\Entity\Admin\CmsBlocs | No errors. |
App\Entity\Admin\Route\FrontRoute | No errors. |
App\Entity\CategoryFooter | No errors. |
App\Entity\Admin\Menu\MenuItems | No errors. |
App\Entity\Admin\Menu\MenuSubItems | No errors. |
App\Entity\Admin\Contact | No errors. |
App\Entity\Admin\Configuration\ReseauSocial | No errors. |
App\Entity\Admin\Menu\MenuName | No errors. |
App\Entity\Admin\PartenaireCategory | No errors. |
App\Entity\Admin\Partenaire | No errors. |
App\Entity\Admin\PartenaireFooter | No errors. |