Query Metrics
29
Database Queries
15
Different statements
36.71 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.12 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.redirect_on AS redirect_on_3, t4.id AS id_5, t4.type AS type_6, t4.creation_date AS creation_date_7, t4.modified_date AS modified_date_8, t4.title AS title_9, t4.menu_label AS menu_label_10, t4.page_title AS page_title_11, t4.page_description AS page_description_12, t4.bandeau_text_1 AS bandeau_text_1_13, t4.bandeau_text_2 AS bandeau_text_2_14, t4.bandeau_text_3 AS bandeau_text_3_15, t4.content AS content_16, t4.page_order AS page_order_17, t4.robots AS robots_18, t4.parent_id AS parent_id_19, t4.url_id AS url_id_20 FROM Url t0 LEFT JOIN Page t4 ON t4.url_id = t0.id WHERE t0.url = ? LIMIT 1
Parameters:
[
"chauffage-electrique.html"
]
|
| 2 | 0.90 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"
]
|
| 3 | 0.32 ms |
SELECT c0_.id AS id_0 FROM Categorie c0_ WHERE c0_.page_id = ?
Parameters:
[
180
]
|
| 4 | 0.54 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:
[
178
]
|
| 5 | 0.38 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:
[
"category_page_suffix"
]
|
| 6 | 0.54 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
"valid"
]
|
| 7 | 0.44 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
"valid"
]
|
| 8 | 0.80 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"
]
|
| 9 | 0.49 ms |
SELECT DATABASE()
Parameters:
[] |
| 10 | 1.70 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"exacompabdd"
]
|
| 11 | 0.43 ms |
SELECT DATABASE()
Parameters:
[] |
| 12 | 1.59 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"
]
|
| 13 | 0.50 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:
[
47
]
|
| 14 | 0.49 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:
[
75
]
|
| 15 | 0.56 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:
[] |
| 16 | 0.63 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
]
|
| 17 | 0.94 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.redirect_on AS redirect_on_3, t4.id AS id_5, t4.type AS type_6, t4.creation_date AS creation_date_7, t4.modified_date AS modified_date_8, t4.title AS title_9, t4.menu_label AS menu_label_10, t4.page_title AS page_title_11, t4.page_description AS page_description_12, t4.bandeau_text_1 AS bandeau_text_1_13, t4.bandeau_text_2 AS bandeau_text_2_14, t4.bandeau_text_3 AS bandeau_text_3_15, t4.content AS content_16, t4.page_order AS page_order_17, t4.robots AS robots_18, t4.parent_id AS parent_id_19, t4.url_id AS url_id_20 FROM Url t0 LEFT JOIN Page t4 ON t4.url_id = t0.id WHERE t0.id = ?
Parameters:
[
57
]
|
| 18 | 2.88 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" 178 ] |
| 19 | 0.52 ms |
SELECT p0_.id AS id_0 FROM Page p0_ INNER JOIN Categorie c1_ ON (c1_.page_id = p0_.id AND c1_.id = ?)
Parameters:
[
72
]
|
| 20 | 12.16 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:23:30" ] |
| 21 | 0.69 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:
[
"facebook_url"
]
|
| 22 | 0.52 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:
[
"twitter_url"
]
|
| 23 | 0.49 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:
[
"rss_url"
]
|
| 24 | 1.30 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:
[
"quality"
]
|
| 25 | 1.46 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:
[
"prix"
]
|
| 26 | 1.42 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:
[
"cguv"
]
|
| 27 | 1.20 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:
[
"legal"
]
|
| 28 | 1.24 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:
[
"links"
]
|
| 29 | 0.48 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:
[
"google_analytics"
]
|
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\Url | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\PageMeta | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Option | No errors. |
| App\Entity\Prestataire | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Transaction | No errors. |
| App\Entity\RefundRequest | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Demande | No errors. |