Query Metrics
170
Database Queries
14
Different statements
9.60 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.10 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.97 ms (0.00%) |
7 |
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 disponibilite d1_ ON (d1_.imprimeur_id = i0_.id) LEFT JOIN language_country l2_ ON i0_.country_id = l2_.id LEFT JOIN imprimeur_carrier i4_ ON i0_.id = i4_.imprimeur_id LEFT JOIN carrier c3_ ON c3_.id = i4_.carrier_id WHERE d1_.date_start LIKE ? AND d1_.type_evenement = ? AND l2_.country_name = ? AND i0_.id IN (?) AND c3_.num IN (?) AND i0_.code_postal_livraison LIKE ?
Parameters:
[ "%2025-07-14%" 1 null [ 1 2 5 7 8 9 11 12 13 ] 3 "%%" ] |
0.45 ms (0.00%) |
4 |
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 language_country l1_ ON i0_.country_id = l1_.id LEFT JOIN imprimeur_carrier i3_ ON i0_.id = i3_.imprimeur_id LEFT JOIN carrier c2_ ON c2_.id = i3_.carrier_id WHERE l1_.country_name = ? AND i0_.id IN (?) AND c2_.num IN (?)
Parameters:
[ null [ 1 2 5 7 8 9 11 12 13 ] 1 ] |
0.41 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.29 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.21 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:
[
"imprimerie_impressionA1"
]
|
0.20 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%) |
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.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.16 ms (0.00%) |
1 |
SELECT i0_.id AS id_0 FROM imprimeur i0_
Parameters:
[] |
0.14 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 disponibilite d1_ ON (d1_.imprimeur_id = i0_.id) LEFT JOIN language_country l2_ ON i0_.country_id = l2_.id LEFT JOIN imprimeur_carrier i4_ ON i0_.id = i4_.imprimeur_id LEFT JOIN carrier c3_ ON c3_.id = i4_.carrier_id WHERE d1_.date_start LIKE ? AND d1_.date_end > ? AND d1_.type_evenement = ? AND l2_.country_name = ? AND i0_.id IN (?) AND c3_.num IN (?) AND i0_.code_postal_livraison LIKE ?
Parameters:
[ "%2025-07-13%" "2025-07-13 22:30:00" 1 null [ 1 2 5 7 8 9 11 12 13 ] 3 "%%" ] |
0.11 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.10 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.08 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 language_country l1_ ON i0_.country_id = l1_.id LEFT JOIN imprimeur_carrier i3_ ON i0_.id = i3_.imprimeur_id LEFT JOIN carrier c2_ ON c2_.id = i3_.carrier_id WHERE l1_.country_name = ? AND i0_.id IN (?) AND c2_.num IN (?) AND i0_.code_postal_livraison LIKE ?
Parameters:
[ null [ 1 2 5 7 8 9 11 12 13 ] 3 "%%" ] |
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\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\Imprimeur | No errors. |
App\Entity\Disponibilite | No errors. |
App\Entity\Carrier | No errors. |
App\Entity\FranceRegion | No errors. |