Query Metrics
48
Database Queries
14
Different statements
5.66 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.01 ms (35.46%) |
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
]
|
0.67 ms (11.88%) |
1 |
SELECT t0.id AS id_1, t0.template AS template_2, t0.pos AS pos_3, t0.image AS image_4 FROM choose_home_components t0 ORDER BY t0.pos ASC
Parameters:
[] |
0.66 ms (11.62%) |
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.55 ms (9.69%) |
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
]
|
0.43 ms (7.52%) |
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_home"
]
|
0.24 ms (4.15%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM partenaire_category t0
Parameters:
[] |
0.20 ms (3.62%) |
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.19 ms (3.43%) |
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.19 ms (3.35%) |
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.14 ms (2.40%) |
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_home"
]
|
0.11 ms (1.91%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM contact t0
Parameters:
[] |
0.10 ms (1.73%) |
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.09 ms (1.64%) |
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
]
|
0.09 ms (1.59%) |
1 |
SELECT t0.id AS id_1, t0.categorie_name AS categorie_name_2 FROM category_footer t0
Parameters:
[] |
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\ChooseHomeComponents | 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. |