Query Metrics

160 Database Queries
11 Different statements
10.24 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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
  • The mappings App\Entity\Product#productImageMobile and App\Entity\ProductImageMobile#product are inconsistent with each other.
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.