Query Metrics
24
Database Queries
14
Different statements
17.82 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.83 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" "89000" ] |
| 2 | 0.45 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:
[
219
]
|
| 3 | 0.35 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:
[
"89"
]
|
| 4 | 0.43 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:
[
2
]
|
| 5 | 1.03 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" "21%" ] |
| 6 | 1.08 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" "25%" ] |
| 7 | 0.86 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" "39%" ] |
| 8 | 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" "58%" ] |
| 9 | 0.80 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" "70%" ] |
| 10 | 0.80 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" "71%" ] |
| 11 | 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" "89%" ] |
| 12 | 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" "90%" ] |
| 13 | 0.37 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"
]
|
| 14 | 0.29 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"
]
|
| 15 | 0.50 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
"valid"
]
|
| 16 | 0.50 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
"valid"
]
|
| 17 | 0.84 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"
]
|
| 18 | 0.56 ms |
SELECT DATABASE()
Parameters:
[] |
| 19 | 1.92 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"exacompabdd"
]
|
| 20 | 0.42 ms |
SELECT DATABASE()
Parameters:
[] |
| 21 | 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"
]
|
| 22 | 0.55 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
]
|
| 23 | 0.57 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:
[] |
| 24 | 0.75 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
]
|
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. |