GET https://myeval.devextractor.com/

Response
200 OK
IP
102.18.163.33
Profiled on
Token
c7cd91

Query Metrics

56 Database Queries
10 Different statements
36.81 ms Query time
0 Invalid entities
51 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.97 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.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
3 1.72 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.70 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.is_exclusive AS is_exclusive_14, t0.type_abonnement_id AS type_abonnement_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
5 0.72 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
6 0.71 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
7 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  50
]
View formatted query    View runnable query    Explain query
8 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  53
]
View formatted query    View runnable query    Explain query
9 0.50 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: 
[
  55
]
View formatted query    View runnable query    Explain query
10 0.49 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: 
[
  56
]
View formatted query    View runnable query    Explain query
11 0.55 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: 
[
  57
]
View formatted query    View runnable query    Explain query
12 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  58
]
View formatted query    View runnable query    Explain query
13 0.66 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.is_exclusive AS is_exclusive_14, t0.type_abonnement_id AS type_abonnement_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  38
]
View formatted query    View runnable query    Explain query
14 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: 
[
  51
]
View formatted query    View runnable query    Explain query
15 0.57 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: 
[
  52
]
View formatted query    View runnable query    Explain query
16 0.58 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.is_exclusive AS is_exclusive_14, t0.type_abonnement_id AS type_abonnement_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  35
]
View formatted query    View runnable query    Explain query
17 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  59
]
View formatted query    View runnable query    Explain query
18 0.54 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: 
[
  60
]
View formatted query    View runnable query    Explain query
19 0.54 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: 
[
  61
]
View formatted query    View runnable query    Explain query
20 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  62
]
View formatted query    View runnable query    Explain query
21 0.64 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: 
[
  91
]
View formatted query    View runnable query    Explain query
22 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.is_exclusive AS is_exclusive_14, t0.type_abonnement_id AS type_abonnement_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  40
]
View formatted query    View runnable query    Explain query
23 0.57 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: 
[
  63
]
View formatted query    View runnable query    Explain query
24 0.69 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: 
[
  64
]
View formatted query    View runnable query    Explain query
25 0.59 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: 
[
  65
]
View formatted query    View runnable query    Explain query
26 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  66
]
View formatted query    View runnable query    Explain query
27 0.70 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.is_exclusive AS is_exclusive_14, t0.type_abonnement_id AS type_abonnement_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query
28 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: 
[
  68
]
View formatted query    View runnable query    Explain query
29 0.56 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: 
[
  81
]
View formatted query    View runnable query    Explain query
30 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  82
]
View formatted query    View runnable query    Explain query
31 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  84
]
View formatted query    View runnable query    Explain query
32 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: 
[
  85
]
View formatted query    View runnable query    Explain query
33 0.54 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: 
[
  86
]
View formatted query    View runnable query    Explain query
34 0.54 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: 
[
  87
]
View formatted query    View runnable query    Explain query
35 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: 
[
  88
]
View formatted query    View runnable query    Explain query
36 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query
37 0.56 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: 
[
  90
]
View formatted query    View runnable query    Explain query
38 0.57 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.is_exclusive AS is_exclusive_14, t0.type_abonnement_id AS type_abonnement_id_15 FROM diagnostic t0 INNER JOIN diagnostic_categorie ON t0.id = diagnostic_categorie.diagnostic_id WHERE diagnostic_categorie.categorie_id = ?
Parameters: 
[
  36
]
View formatted query    View runnable query    Explain query
39 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  70
]
View formatted query    View runnable query    Explain query
40 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  71
]
View formatted query    View runnable query    Explain query
41 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: 
[
  72
]
View formatted query    View runnable query    Explain query
42 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  73
]
View formatted query    View runnable query    Explain query
43 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 INNER JOIN diagnostic_site ON t0.id = diagnostic_site.site_id WHERE diagnostic_site.diagnostic_id = ?
Parameters: 
[
  74
]
View formatted query    View runnable query    Explain query
44 0.69 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: 
[
  75
]
View formatted query    View runnable query    Explain query
45 0.66 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
  "qui-sommes-nous"
]
View formatted query    View runnable query    Explain query
46 0.55 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
47 0.40 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
48 0.77 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
49 1.21 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
50 0.87 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
51 0.72 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
52 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
53 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_.footer = 1 GROUP BY p0_.id ORDER BY p0_.position ASC
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
54 0.58 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: 
[
  4
]
View formatted query    View runnable query    Explain query
55 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"
]
View formatted query    View runnable query    Explain query
56 0.42 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 35
App\Entity\Categorie 6
App\Entity\Site 4
App\Entity\Cabinet 3
App\Entity\Page 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.