Query Metrics
11
Database Queries
7
Different statements
9.86 ms
Query time
0
Invalid entities
17
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.44 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0 WHERE t0.domaine = ? LIMIT 1
Parameters:
[
"myeval.devextractor.com"
]
|
| 2 | 0.61 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0
Parameters:
[] |
| 3 | 0.96 ms |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.url AS url_2, p0_.contenu AS contenu_3, p0_.footer AS footer_4, p0_.position AS position_5, p0_.is_header AS is_header_6, p0_.sous_titre AS sous_titre_7, p0_.image AS image_8, p0_.updated_at AS updated_at_9, p0_.contenu_home AS contenu_home_10 FROM page p0_ INNER JOIN page_site p2_ ON p0_.id = p2_.page_id INNER JOIN site s1_ ON s1_.id = p2_.site_id WHERE s1_.id = ? AND p0_.url = ?
Parameters:
[ 4 "adresse-du-support-athdata-bba-fr" ] |
| 4 | 0.65 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0 WHERE t0.domaine = ? LIMIT 1
Parameters:
[
"myeval.devextractor.com"
]
|
| 5 | 0.48 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0
Parameters:
[] |
| 6 | 0.96 ms |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.url AS url_2, p0_.contenu AS contenu_3, p0_.footer AS footer_4, p0_.position AS position_5, p0_.is_header AS is_header_6, p0_.sous_titre AS sous_titre_7, p0_.image AS image_8, p0_.updated_at AS updated_at_9, p0_.contenu_home AS contenu_home_10 FROM page p0_ INNER JOIN page_site p2_ ON p0_.id = p2_.page_id INNER JOIN site s1_ ON s1_.id = p2_.site_id WHERE s1_.id = ? AND p0_.is_header = 1 GROUP BY p0_.id ORDER BY p0_.position ASC
Parameters:
[
4
]
|
| 7 | 1.35 ms |
SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.description AS description_2, c0_.url AS url_3, c0_.icone AS icone_4, c0_.updated_at AS updated_at_5, c0_.position AS position_6 FROM categorie c0_ INNER JOIN categorie_site c2_ ON c0_.id = c2_.categorie_id INNER JOIN site s1_ ON s1_.id = c2_.site_id INNER JOIN diagnostic_categorie d4_ ON c0_.id = d4_.categorie_id INNER JOIN diagnostic d3_ ON d3_.id = d4_.diagnostic_id WHERE s1_.id = ? AND (d3_.statut = 'publie' AND d3_.is_home = 1) GROUP BY c0_.id ORDER BY c0_.position ASC
Parameters:
[
4
]
|
| 8 | 0.90 ms |
SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.description AS description_2, d0_.image AS image_3, d0_.date_create AS date_create_4, d0_.date_publication AS date_publication_5, d0_.statut AS statut_6, d0_.updated_at AS updated_at_7, d0_.introduction AS introduction_8, d0_.tarif AS tarif_9, d0_.thumbnail AS thumbnail_10, d0_.slug AS slug_11, d0_.is_home AS is_home_12, d0_.is_exclusive AS is_exclusive_13, d0_.type_abonnement_id AS type_abonnement_id_14 FROM diagnostic d0_ INNER JOIN diagnostic_site d2_ ON d0_.id = d2_.diagnostic_id INNER JOIN site s1_ ON s1_.id = d2_.site_id WHERE s1_.id = ? AND d0_.statut = 'publie' GROUP BY d0_.id ORDER BY d0_.id ASC
Parameters:
[
4
]
|
| 9 | 0.74 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters:
[
44
]
|
| 10 | 0.81 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters:
[
49
]
|
| 11 | 0.96 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre1 AS sous_titre1_3, t0.sous_titre2 AS sous_titre2_4, t0.domaine AS domaine_5, t0.logo AS logo_6, t0.image AS image_7, t0.description AS description_8, t0.updated_at AS updated_at_9, t0.url AS url_10, t0.bg_color_menu AS bg_color_menu_11, t0.text_color_menu AS text_color_menu_12, t0.btn_inscription_color AS btn_inscription_color_13, t0.bg_color_body AS bg_color_body_14, t0.copyright AS copyright_15, t0.cabinet_id AS cabinet_id_16 FROM site t0 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters:
[
51
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Categorie | 6 |
| App\Entity\Site | 4 |
| App\Entity\Cabinet | 3 |
| App\Entity\Diagnostic | 3 |
| App\Entity\Page | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Site | No errors. |
| App\Entity\Cabinet | No errors. |
| App\Entity\Diagnostic | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ReseauxSociaux | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\TypeAbonnement | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Question | No errors. |
| App\Entity\RapportQuestion | No errors. |
| App\Entity\Reponse | No errors. |
| App\Entity\EnqueteDiagnostic | No errors. |
| App\Entity\EtapeQuestion | No errors. |
| App\Entity\ConditionQuestion | No errors. |
| App\Entity\Radar | No errors. |
| App\Entity\EtapePreliminaire | No errors. |