Query Metrics
160
Database Queries
11
Different statements
10.24 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.64 ms (0.00%) |
141 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.sort AS sort_4, t0.description AS description_5, t0.icone AS icone_6, t0.parent_menu_id AS parent_menu_id_7 FROM menu_burger t0 WHERE t0.parent_menu_id = ? ORDER BY t0.sort ASC
Parameters:
[
15
]
|
0.82 ms (0.00%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.is_deleted AS is_deleted_4, t0.design_type_crello AS design_type_crello_5, t0.design_type_custom_crello AS design_type_custom_crello_6, t0.design_type_side_bar_crello AS design_type_side_bar_crello_7, t0.product_id AS product_id_8, t0.product_attribute_id AS product_attribute_id_9, t0.price_product_id AS price_product_id_10 FROM templates_page_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.62 ms (0.00%) |
4 |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.country_name AS country_name_3, t0.language_code AS language_code_4, t0.language_name AS language_name_5, t0.is_enabled AS is_enabled_6, t0.id_client_stuart AS id_client_stuart_7, t0.cle_secrete_stuart AS cle_secrete_stuart_8 FROM language_country t0 WHERE t0.country_code = ?
Parameters:
[
"FR"
]
|
0.59 ms (0.00%) |
1 |
SELECT t0_.id AS id_0, t0_.titre AS titre_1, t0_.name_template AS name_template_2, t0_.file_product AS file_product_3, t0_.sort AS sort_4, t0_.is_deleted AS is_deleted_5, t0_.design_type_side_bar_crello AS design_type_side_bar_crello_6, t0_.design_template_id AS design_template_id_7, t0_.tags AS tags_8, t0_.product_id AS product_id_9, t0_.product_attribute_id AS product_attribute_id_10, t0_.price_product_id AS price_product_id_11, t0_.templates_page_category_id AS templates_page_category_id_12 FROM templates_page t0_ INNER JOIN templates_page_category t1_ ON t0_.templates_page_category_id = t1_.id WHERE t0_.is_deleted = 0 OR t0_.is_deleted IS NULL ORDER BY t0_.sort ASC, t1_.sort ASC
Parameters:
[] |
0.41 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.name_path AS name_path_2, t0.name_route AS name_route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.titre AS titre_6, t0.content AS content_7 FROM seo t0 WHERE t0.name_route = ? LIMIT 1
Parameters:
[
"page_templates_20000"
]
|
0.28 ms (0.00%) |
3 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.num_bandeau AS num_bandeau_3 FROM bandeau_rose t0 WHERE t0.num_bandeau = ? LIMIT 1
Parameters:
[
1
]
|
0.22 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.country_name AS country_name_3, t0.language_code AS language_code_4, t0.language_name AS language_name_5, t0.is_enabled AS is_enabled_6, t0.id_client_stuart AS id_client_stuart_7, t0.cle_secrete_stuart AS cle_secrete_stuart_8 FROM language_country t0 WHERE t0.country_code = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[ "US" 1 ] |
0.19 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.condition_d AS condition_d_3 FROM bandeau_home_page t0 LIMIT 1
Parameters:
[] |
0.18 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.country_name AS country_name_3, t0.language_code AS language_code_4, t0.language_name AS language_name_5, t0.is_enabled AS is_enabled_6, t0.id_client_stuart AS id_client_stuart_7, t0.cle_secrete_stuart AS cle_secrete_stuart_8 FROM language_country t0 WHERE t0.language_code = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[ "Fr" 1 ] |
0.14 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.bandeau_home_page_id AS bandeau_home_page_id_3 FROM bandeau_home_page_item t0 WHERE t0.bandeau_home_page_id = ?
Parameters:
[
1
]
|
0.14 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.sort AS sort_4, t0.description AS description_5, t0.icone AS icone_6, t0.parent_menu_id AS parent_menu_id_7 FROM menu_burger t0 ORDER BY t0.sort ASC
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\User | No errors. |
App\Entity\LanguageCountry | No errors. |
App\Entity\TemplatesPage | No errors. |
App\Entity\TemplatesPageCategory | No errors. |
App\Entity\Product |
|
App\Entity\ProductAttribute | No errors. |
App\Entity\PriceProduct | No errors. |
App\Entity\Seo | No errors. |
App\Entity\BandeauHomePage | No errors. |
App\Entity\BandeauHomePageItem | No errors. |
App\Entity\BandeauRose | No errors. |
App\Entity\MenuBurger | No errors. |