GET https://mysherlock.devextractor.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CFront%255CAccueilController%253A%253Amo…

Response
200 OK
IP
102.18.163.33
Profiled on
Token
81ca5b

Query Metrics

25 Database Queries
9 Different statements
18.16 ms Query time
0 Invalid entities
22 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.70 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: 
[
  "mysherlock.devextractor.com"
]
View formatted query    View runnable query    Explain query
2 0.67 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: 
[]
View formatted query    View runnable query    Explain query
3 1.61 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: 
[
  3
]
View formatted query    View runnable query    Explain query
4 0.71 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.image AS image_4, t0.date_create AS date_create_5, t0.date_publication AS date_publication_6, t0.statut AS statut_7, t0.updated_at AS updated_at_8, t0.introduction AS introduction_9, t0.tarif AS tarif_10, t0.thumbnail AS thumbnail_11, t0.slug AS slug_12, t0.is_home AS is_home_13, t0.type_abonnement_id AS type_abonnement_id_14, t0.author_id AS author_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
5 0.75 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.image AS image_4, t0.date_create AS date_create_5, t0.date_publication AS date_publication_6, t0.statut AS statut_7, t0.updated_at AS updated_at_8, t0.introduction AS introduction_9, t0.tarif AS tarif_10, t0.thumbnail AS thumbnail_11, t0.slug AS slug_12, t0.is_home AS is_home_13, t0.type_abonnement_id AS type_abonnement_id_14, t0.author_id AS author_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
6 0.62 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.url AS url_4, t0.icone AS icone_5, t0.updated_at AS updated_at_6, t0.position AS position_7 FROM categorie t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.categorie_id WHERE diagnostic_categorie.diagnostic_id = ?
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query
7 0.69 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.url AS url_4, t0.icone AS icone_5, t0.updated_at AS updated_at_6, t0.position AS position_7 FROM categorie t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.categorie_id WHERE diagnostic_categorie.diagnostic_id = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query
8 0.71 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.url AS url_4, t0.icone AS icone_5, t0.updated_at AS updated_at_6, t0.position AS position_7 FROM categorie t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.categorie_id WHERE diagnostic_categorie.diagnostic_id = ?
Parameters: 
[
  35
]
View formatted query    View runnable query    Explain query
9 0.63 ms 
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.url AS url_4, t0.icone AS icone_5, t0.updated_at AS updated_at_6, t0.position AS position_7 FROM categorie t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.categorie_id WHERE diagnostic_categorie.diagnostic_id = ?
Parameters: 
[
  36
]
View formatted query    View runnable query    Explain query
10 0.69 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.image AS image_4, t0.date_create AS date_create_5, t0.date_publication AS date_publication_6, t0.statut AS statut_7, t0.updated_at AS updated_at_8, t0.introduction AS introduction_9, t0.tarif AS tarif_10, t0.thumbnail AS thumbnail_11, t0.slug AS slug_12, t0.is_home AS is_home_13, t0.type_abonnement_id AS type_abonnement_id_14, t0.author_id AS author_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
11 0.59 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.image AS image_4, t0.date_create AS date_create_5, t0.date_publication AS date_publication_6, t0.statut AS statut_7, t0.updated_at AS updated_at_8, t0.introduction AS introduction_9, t0.tarif AS tarif_10, t0.thumbnail AS thumbnail_11, t0.slug AS slug_12, t0.is_home AS is_home_13, t0.type_abonnement_id AS type_abonnement_id_14, t0.author_id AS author_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
12 0.74 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.image AS image_4, t0.date_create AS date_create_5, t0.date_publication AS date_publication_6, t0.statut AS statut_7, t0.updated_at AS updated_at_8, t0.introduction AS introduction_9, t0.tarif AS tarif_10, t0.thumbnail AS thumbnail_11, t0.slug AS slug_12, t0.is_home AS is_home_13, t0.type_abonnement_id AS type_abonnement_id_14, t0.author_id AS author_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
13 0.75 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: 
[
  3
  "qui-sommes-nous"
]
View formatted query    View runnable query    Explain query
14 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 WHERE t0.domaine = ? LIMIT 1
Parameters: 
[
  "mysherlock.devextractor.com"
]
View formatted query    View runnable query    Explain query
15 0.51 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: 
[]
View formatted query    View runnable query    Explain query
16 0.97 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: 
[
  3
]
View formatted query    View runnable query    Explain query
17 1.17 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: 
[
  3
]
View formatted query    View runnable query    Explain query
18 0.68 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: 
[
  "mysherlock.devextractor.com"
]
View formatted query    View runnable query    Explain query
19 0.51 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: 
[]
View formatted query    View runnable query    Explain query
20 0.68 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: 
[
  "mysherlock.devextractor.com"
]
View formatted query    View runnable query    Explain query
21 0.53 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: 
[]
View formatted query    View runnable query    Explain query
22 0.97 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_.footer = 1 GROUP BY p0_.id ORDER BY p0_.position ASC
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
23 0.61 ms 
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.lien AS lien_2, r0_.classe AS classe_3, r0_.position AS position_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.site_id AS site_id_7 FROM reseaux_sociaux r0_ WHERE r0_.site_id = ? ORDER BY r0_.position ASC
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
24 0.60 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: 
[
  "mysherlock.devextractor.com"
]
View formatted query    View runnable query    Explain query
25 0.46 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: 
[]
View formatted query    View runnable query    Explain query

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\Diagnostic 8
App\Entity\Categorie 6
App\Entity\Page 3
App\Entity\Site 2
App\Entity\Cabinet 2
App\Entity\User 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.
App\Entity\Document No errors.
App\Entity\SujetContact No errors.
App\Entity\TypeQuestion No errors.
App\Entity\PostReponse No errors.
App\Entity\AnalyseQuestion No errors.
App\Entity\PostReponseColonne No errors.
App\Entity\PostReponseLigne No errors.
App\Entity\ConditionResponse No errors.
App\Entity\CritereResponse No errors.
App\Entity\DocumentDiag No errors.
App\Entity\EtapeNeutre No errors.
Vich\UploaderBundle\Entity\File No errors.