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

Response
200 OK
IP
102.18.163.33
Profiled on
Token
33836b

Query Metrics

13 Database Queries
6 Different statements
11.04 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.07 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"
]
View formatted query    View runnable query    Explain query
2 0.58 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.94 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
]
View formatted query    View runnable query    Explain query
4 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: 
[
  "myeval.devextractor.com"
]
View formatted query    View runnable query    Explain query
5 0.47 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
6 0.90 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
]
View formatted query    View runnable query    Explain query
7 1.36 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
]
View formatted query    View runnable query    Explain query
8 0.89 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
]
View formatted query    View runnable query    Explain query
9 0.66 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
]
View formatted query    View runnable query    Explain query
10 0.63 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
]
View formatted query    View runnable query    Explain query
11 0.76 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
]
View formatted query    View runnable query    Explain query
12 0.73 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"
]
View formatted query    View runnable query    Explain query
13 0.45 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\Categorie 6
App\Entity\Site 4
App\Entity\Cabinet 3
App\Entity\Diagnostic 3

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\FileImport 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\Campaign No errors.
App\Entity\CritereResponse No errors.
App\Entity\DocumentDiag No errors.
App\Entity\DataBrute No errors.
App\Entity\EtapeNeutre No errors.
Vich\UploaderBundle\Entity\File No errors.