Query Metrics
159
Database Queries
10
Different statements
8.70 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.12 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.75 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_cms_front"
]
|
0.49 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.31 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.page_type AS page_type_2, t0.url AS url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.google_tag_name_page AS google_tag_name_page_6, t0.google_tagcat1 AS google_tagcat1_7, t0.google_tagcat2 AS google_tagcat2_8, t0.google_tagcat3 AS google_tagcat3_9, t0.titre AS titre_10, t0.sous_titre AS sous_titre_11, t0.btn1name AS btn1name_12, t0.btn1link AS btn1link_13, t0.btn1color AS btn1color_14, t0.btn1background AS btn1background_15, t0.btn2name AS btn2name_16, t0.btn2link AS btn2link_17, t0.btn2color AS btn2color_18, t0.btn2background AS btn2background_19, t0.created_at AS created_at_20, t0.is_deleted AS is_deleted_21, t0.is_bandeau AS is_bandeau_22, t0.page_block_1 AS page_block_1_23, t0.page_block_2 AS page_block_2_24, t0.page_block_3 AS page_block_3_25, t0.page_block_4 AS page_block_4_26, t0.page_block_5 AS page_block_5_27, t0.page_block_6 AS page_block_6_28, t0.page_block_7 AS page_block_7_29 FROM page t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"Copees Présentations"
]
|
0.24 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.language_code = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[ "Fr" 1 ] |
0.20 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.16 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 ] |
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.08 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
]
|
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\Page\Page | No errors. |
App\Entity\Page\PageBlock1 | No errors. |
App\Entity\Page\PageBlock2 | No errors. |
App\Entity\Page\PageBlock3 | No errors. |
App\Entity\Page\PageBlock4 | No errors. |
App\Entity\Page\PageBlock5 | No errors. |
App\Entity\Page\PageBlock6 | No errors. |
App\Entity\Page\PageBlock7 | 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\Page\LivraisonBlock | No errors. |
App\Entity\Page\PageSousBlock | No errors. |
App\Entity\SAV | No errors. |
App\Entity\Imprimeur | No errors. |
App\Entity\Carrier | No errors. |
App\Entity\FranceRegion | No errors. |