Query Metrics
163
Database Queries
12
Different statements
10.66 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.70 ms (0.00%) |
4 |
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.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.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:
[] |
0.13 ms (0.00%) |
1 |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.email_imp AS email_imp_2, i0_.email_imp_facture AS email_imp_facture_3, i0_.stripe_account_id AS stripe_account_id_4, i0_.stripe_owner_id AS stripe_owner_id_5, i0_.stripe_bank_account_id AS stripe_bank_account_id_6, i0_.zonechalandise AS zonechalandise_7, i0_.retribution_pourcentage AS retribution_pourcentage_8, i0_.address AS address_9, i0_.code_postal AS code_postal_10, i0_.account_bank_number AS account_bank_number_11, i0_.fiscal_number AS fiscal_number_12, i0_.profession AS profession_13, i0_.percent_owner_ship AS percent_owner_ship_14, i0_.date_of_birth AS date_of_birth_15, i0_.identity_number AS identity_number_16, i0_.city AS city_17, i0_.lat AS lat_18, i0_.longi AS longi_19, i0_.is_default_livraison_national AS is_default_livraison_national_20, i0_.id_sender_livraison_national AS id_sender_livraison_national_21, i0_.code_postal_livraison AS code_postal_livraison_22, i0_.is_traite_copees_plus AS is_traite_copees_plus_23, i0_.is_traite_copees_pro AS is_traite_copees_pro_24, i0_.is_virement4j AS is_virement4j_25, i0_.is_virement30j AS is_virement30j_26, i0_.mobile AS mobile_27, i0_.is_exaprint AS is_exaprint_28, i0_.nbr_km_pointretrait AS nbr_km_pointretrait_29, i0_.user_id AS user_id_30, i0_.country_id AS country_id_31 FROM imprimeur i0_ LEFT JOIN imprimeur_carrier i2_ ON i0_.id = i2_.imprimeur_id LEFT JOIN carrier c1_ ON c1_.id = i2_.carrier_id WHERE i0_.id IN (?) AND c1_.num IN (?)
Parameters:
[ [ 1 2 ] 2 ] |
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. |
App\Entity\MessagesSav | No errors. |
App\Entity\AccessoireProduct | No errors. |
App\Entity\ProductImage | No errors. |
App\Entity\TextHoverProduct | No errors. |
App\Entity\LiseuseProduitAtribut | No errors. |
App\Entity\TipsProduct | No errors. |
App\Entity\RecommendationProduct | No errors. |
App\Entity\ProductImageMobile | No errors. |
App\Entity\Attribut | No errors. |
App\Entity\SAV | No errors. |
App\Entity\Accessoire | No errors. |
App\Entity\BesoinProductPage | No errors. |
App\Entity\AttributImage | No errors. |
App\Entity\AvisAttribute | No errors. |
App\Entity\Imprimeur | No errors. |
App\Entity\Carrier | No errors. |
App\Entity\FranceRegion | No errors. |