Query Metrics
34
Database Queries
18
Different statements
33.37 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.06 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.creation_date AS creation_date_2, p0_.modified_date AS modified_date_3, p0_.title AS title_4, p0_.menu_label AS menu_label_5, p0_.page_title AS page_title_6, p0_.page_description AS page_description_7, p0_.bandeau_text_1 AS bandeau_text_1_8, p0_.bandeau_text_2 AS bandeau_text_2_9, p0_.bandeau_text_3 AS bandeau_text_3_10, p0_.content AS content_11, p0_.page_order AS page_order_12, p0_.robots AS robots_13, p0_.parent_id AS parent_id_14, p0_.url_id AS url_id_15 FROM Page p0_ INNER JOIN PageMeta p1_ ON p0_.id = p1_.page_id AND (p1_.meta_key = ?) WHERE p1_.meta_value = ? LIMIT 1
Parameters:
[ "cp" "66000" ] |
| 2 | 0.40 ms |
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.page_id AS page_id_4 FROM PageMeta t0 WHERE t0.page_id = ?
Parameters:
[
254
]
|
| 3 | 0.34 ms |
SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.region_id AS region_id_4 FROM Departement d0_ WHERE d0_.code = ?
Parameters:
[
"66"
]
|
| 4 | 0.46 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.slug AS slug_4, t0.region_id AS region_id_5 FROM Departement t0 WHERE t0.region_id = ?
Parameters:
[
11
]
|
| 5 | 1.04 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "09%" ] |
| 6 | 0.93 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "11%" ] |
| 7 | 0.83 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "12%" ] |
| 8 | 0.84 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "30%" ] |
| 9 | 0.87 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "31%" ] |
| 10 | 1.13 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "32%" ] |
| 11 | 0.95 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "34%" ] |
| 12 | 0.84 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "46%" ] |
| 13 | 0.79 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "48%" ] |
| 14 | 0.81 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "65%" ] |
| 15 | 0.89 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "66%" ] |
| 16 | 0.83 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "81%" ] |
| 17 | 0.77 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p2_.categorie_id AND (c1_.id = ?) WHERE p0_.status = ? AND p0_.code_postal LIKE ?
Parameters:
[ 72 "valid" "82%" ] |
| 18 | 0.46 ms |
SELECT t0.id AS id_1, t0.option_key AS option_key_2, t0.option_value AS option_value_3 FROM `Option` t0 WHERE t0.option_key = ? LIMIT 1
Parameters:
[
"local_page_suffix"
]
|
| 19 | 0.32 ms |
SELECT t0.id AS id_1, t0.option_key AS option_key_2, t0.option_value AS option_value_3 FROM `Option` t0 WHERE t0.option_key = ? LIMIT 1
Parameters:
[
"local_page_suffix"
]
|
| 20 | 1.68 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
"valid"
]
|
| 21 | 0.48 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
"valid"
]
|
| 22 | 1.60 ms |
SELECT p0_.id AS id_0, p0_.parent_id AS sclr_1, p0_.menu_label AS menu_label_2, c1_.description AS description_3, u2_.url AS url_4, c1_.id AS id_5 FROM Page p0_ INNER JOIN Url u2_ ON p0_.url_id = u2_.id LEFT JOIN Categorie c1_ ON (c1_.page_id = p0_.id) WHERE p0_.type = ? ORDER BY p0_.parent_id ASC, p0_.page_order ASC
Parameters:
[
"categorie"
]
|
| 23 | 0.37 ms |
SELECT DATABASE()
Parameters:
[] |
| 24 | 0.89 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"exacompabdd"
]
|
| 25 | 0.27 ms |
SELECT DATABASE()
Parameters:
[] |
| 26 | 0.77 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.creation_date AS creation_date_2, p0_.modified_date AS modified_date_3, p0_.title AS title_4, p0_.menu_label AS menu_label_5, p0_.page_title AS page_title_6, p0_.page_description AS page_description_7, p0_.bandeau_text_1 AS bandeau_text_1_8, p0_.bandeau_text_2 AS bandeau_text_2_9, p0_.bandeau_text_3 AS bandeau_text_3_10, p0_.content AS content_11, p0_.page_order AS page_order_12, p0_.robots AS robots_13, u1_.id AS id_14, u1_.url AS url_15, p0_.parent_id AS parent_id_16, p0_.url_id AS url_id_17, u1_.redirect_on AS redirect_on_18 FROM Page p0_ LEFT JOIN Url u1_ ON p0_.url_id = u1_.id WHERE p0_.type = ?
Parameters:
[
"aide"
]
|
| 27 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.credits AS credits_5, t0.ordre AS ordre_6, t0.parent_id AS parent_id_7, t0.group_id AS group_id_8, t0.page_id AS page_id_9 FROM Categorie t0 WHERE t0.id = ?
Parameters:
[
72
]
|
| 28 | 0.37 ms |
SELECT c0_.id AS id_0, c0_.parent_id AS sclr_1, c0_.name AS name_2 FROM Categorie c0_ ORDER BY c0_.parent_id ASC, c0_.ordre ASC
Parameters:
[] |
| 29 | 0.44 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.creation_date AS creation_date_3, t0.modified_date AS modified_date_4, t0.title AS title_5, t0.menu_label AS menu_label_6, t0.page_title AS page_title_7, t0.page_description AS page_description_8, t0.bandeau_text_1 AS bandeau_text_1_9, t0.bandeau_text_2 AS bandeau_text_2_10, t0.bandeau_text_3 AS bandeau_text_3_11, t0.content AS content_12, t0.page_order AS page_order_13, t0.robots AS robots_14, t0.parent_id AS parent_id_15, t0.url_id AS url_id_16 FROM Page t0 WHERE t0.id = ?
Parameters:
[
205
]
|
| 30 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Region t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 31 | 0.67 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.creation_date AS creation_date_3, t0.modified_date AS modified_date_4, t0.title AS title_5, t0.menu_label AS menu_label_6, t0.page_title AS page_title_7, t0.page_description AS page_description_8, t0.bandeau_text_1 AS bandeau_text_1_9, t0.bandeau_text_2 AS bandeau_text_2_10, t0.bandeau_text_3 AS bandeau_text_3_11, t0.content AS content_12, t0.page_order AS page_order_13, t0.robots AS robots_14, t0.parent_id AS parent_id_15, t0.url_id AS url_id_16 FROM Page t0 WHERE t0.id = ?
Parameters:
[
122
]
|
| 32 | 1.71 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.creation_date AS creation_date_2, p0_.modified_date AS modified_date_3, p0_.title AS title_4, p0_.menu_label AS menu_label_5, p0_.page_title AS page_title_6, p0_.page_description AS page_description_7, p0_.bandeau_text_1 AS bandeau_text_1_8, p0_.bandeau_text_2 AS bandeau_text_2_9, p0_.bandeau_text_3 AS bandeau_text_3_10, p0_.content AS content_11, p0_.page_order AS page_order_12, p0_.robots AS robots_13, u1_.id AS id_14, u1_.url AS url_15, p0_.parent_id AS parent_id_16, p0_.url_id AS url_id_17, u1_.redirect_on AS redirect_on_18 FROM Page p0_ INNER JOIN Url u1_ ON p0_.url_id = u1_.id WHERE p0_.type = ? AND p0_.parent_id = ? ORDER BY p0_.page_order ASC
Parameters:
[ "categorie" 122 ] |
| 33 | 1.01 ms |
SELECT p0_.title AS title_0, d1_.code AS code_1, p2_.meta_value AS meta_value_2, d1_.name AS name_3, p0_.menu_label AS menu_label_4 FROM Departement d1_ INNER JOIN PageMeta p3_ ON (p3_.meta_key = 'departement' AND p3_.meta_value = d1_.code) INNER JOIN Page p0_ ON p3_.page_id = p0_.id AND (p0_.type = ?) INNER JOIN PageMeta p2_ ON p0_.id = p2_.page_id AND (p2_.meta_key = 'cp' AND p2_.meta_value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY p0_.title ASC
Parameters:
[ "local" "33000" "59000" "69000" "13000" "34000" "44000" "06000" "75000" "67000" "31000" ] |
| 34 | 7.83 ms |
SELECT d0_.id AS id_0, d0_.prix AS prix_1, d0_.credits AS credits_2, d0_.status AS status_3, d0_.creation_date AS creation_date_4, d0_.modified_date AS modified_date_5, d0_.client_statut AS client_statut_6, d0_.client_nom AS client_nom_7, d0_.client_email AS client_email_8, d0_.client_telephone AS client_telephone_9, d0_.bien_type AS bien_type_10, d0_.bien_localisation AS bien_localisation_11, d0_.bien_code_postal AS bien_code_postal_12, d0_.bien_ville AS bien_ville_13, d0_.bien_nombre_pieces AS bien_nombre_pieces_14, d0_.bien_surface AS bien_surface_15, d0_.bien_annee_construction AS bien_annee_construction_16, d0_.bien_copropriete AS bien_copropriete_17, d0_.bien_gaz AS bien_gaz_18, d0_.bien_electricite AS bien_electricite_19, d0_.bien_photo AS bien_photo_20, d0_.description_file AS description_file_21, d0_.expiration AS expiration_22, d0_.comment AS comment_23, d0_.prestation AS prestation_24, d0_.provenance AS provenance_25, d0_.similar AS similar_26, d0_.estimation AS estimation_27, c1_.id AS id_28, c1_.name AS name_29, c1_.description AS description_30, c1_.price AS price_31, c1_.credits AS credits_32, c1_.ordre AS ordre_33, c2_.id AS id_34, c2_.name AS name_35, c2_.description AS description_36, c2_.price AS price_37, c2_.credits AS credits_38, c2_.ordre AS ordre_39, d0_.categorie_id AS categorie_id_40, c1_.parent_id AS parent_id_41, c1_.group_id AS group_id_42, c1_.page_id AS page_id_43, c2_.parent_id AS parent_id_44, c2_.group_id AS group_id_45, c2_.page_id AS page_id_46 FROM Demande d0_ INNER JOIN Categorie c1_ ON d0_.categorie_id = c1_.id INNER JOIN Categorie c2_ ON c1_.parent_id = c2_.id WHERE d0_.status IN (?, ?) AND d0_.expiration > ? ORDER BY d0_.creation_date DESC LIMIT 4
Parameters:
[ 1 2 "2026-02-01 16:25:23" ] |
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\Page | No errors. |
| App\Entity\PageMeta | No errors. |
| App\Entity\Url | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Prestataire | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Transaction | No errors. |
| App\Entity\RefundRequest | No errors. |
| App\Entity\Option | No errors. |
| App\Entity\Demande | No errors. |