Symfony Profiler

SELECT 
  t0.id_voyage_serveur AS id_voyage_serveur_1, 
  t0.id_parametres AS id_parametres_2, 
  t0.id_voyage AS id_voyage_3, 
  t0.id_liste_saison AS id_liste_saison_4, 
  t0.id_liste_type_voyage AS id_liste_type_voyage_5, 
  t0.detail_voyage AS detail_voyage_6, 
  t0.nom_voyage AS nom_voyage_7, 
  t0.photo AS photo_8, 
  t0.date_creation AS date_creation_9, 
  t0.date_maj AS date_maj_10 
FROM 
  voyage t0 
WHERE 
  t0.id_voyage_serveur = ?

SELECT t0.id_voyage_serveur AS id_voyage_serveur_1, t0.id_parametres AS id_parametres_2, t0.id_voyage AS id_voyage_3, t0.id_liste_saison AS id_liste_saison_4, t0.id_liste_type_voyage AS id_liste_type_voyage_5, t0.detail_voyage AS detail_voyage_6, t0.nom_voyage AS nom_voyage_7, t0.photo AS photo_8, t0.date_creation AS date_creation_9, t0.date_maj AS date_maj_10 FROM voyage t0 WHERE t0.id_voyage_serveur = '507';

select 
  * 
from 
  liste_menu as m 
  Left join liste_menu_translation as t ON t.id_liste_menu = m.id_liste_menu 
where 
  m.active = 1 
  and t.lang = "en" 
ORDER BY 
  m.id_liste_menu ASC, 
  m.id_liste_menu_parent ASC, 
  m.ordre ASC

select * from liste_menu as m Left join liste_menu_translation as t ON t.id_liste_menu = m.id_liste_menu where m.active =1  and  t.lang = "en"  ORDER BY m.id_liste_menu ASC,m.id_liste_menu_parent ASC, m.ordre ASC;

SELECT 
  liste_pays.id_liste_pays, 
  liste_pays_translation.pays 
FROM 
  `liste_pays` 
  INNER JOIN `liste_pays_translation` ON `liste_pays_translation`.`id_liste_pays` = `liste_pays`.`id_liste_pays` 
where 
  `lang` = 'fr' 
order by 
  `pays`

SELECT liste_pays.id_liste_pays, liste_pays_translation.pays  FROM `liste_pays` INNER JOIN `liste_pays_translation`  ON `liste_pays_translation`.`id_liste_pays` = `liste_pays`.`id_liste_pays` where `lang`='fr' order by `pays`;

SELECT 
  t0.id_voyage_serveur AS id_voyage_serveur_1, 
  t0.id_parametre AS id_parametre_2, 
  t0.commentaire AS commentaire_3 
FROM 
  jaime t0 
WHERE 
  t0.id_parametre = ?

SELECT t0.id_voyage_serveur AS id_voyage_serveur_1, t0.id_parametre AS id_parametre_2, t0.commentaire AS commentaire_3 FROM jaime t0 WHERE t0.id_parametre = '2';

SELECT 
  e0_.id_etape_serveur AS id_etape_serveur_0, 
  e0_.id_voyage_serveur AS id_voyage_serveur_1, 
  e0_.id_etape AS id_etape_2, 
  e0_.id_voyage AS id_voyage_3, 
  e0_.id_liste_profiles_voyageur AS id_liste_profiles_voyageur_4, 
  e0_.id_liste_pays AS id_liste_pays_5, 
  e0_.id_liste_moyen_deplacement AS id_liste_moyen_deplacement_6, 
  e0_.date_deplacement AS date_deplacement_7, 
  e0_.adresse AS adresse_8, 
  e0_.coordonnee_gps AS coordonnee_gps_9, 
  e0_.hebergement AS hebergement_10, 
  e0_.particularite_etape AS particularite_etape_11, 
  e0_.a_voir AS a_voir_12, 
  e0_.a_faire AS a_faire_13, 
  e0_.remarque AS remarque_14, 
  e0_.num_etape AS num_etape_15, 
  e0_.date_maj AS date_maj_16, 
  e0_.date_cre AS date_cre_17 
FROM 
  etapes e0_ 
WHERE 
  e0_.id_voyage_serveur = '507' 
  AND e0_.id_etape_serveur IN (?) 
ORDER BY 
  e0_.num_etape ASC

SELECT e0_.id_etape_serveur AS id_etape_serveur_0, e0_.id_voyage_serveur AS id_voyage_serveur_1, e0_.id_etape AS id_etape_2, e0_.id_voyage AS id_voyage_3, e0_.id_liste_profiles_voyageur AS id_liste_profiles_voyageur_4, e0_.id_liste_pays AS id_liste_pays_5, e0_.id_liste_moyen_deplacement AS id_liste_moyen_deplacement_6, e0_.date_deplacement AS date_deplacement_7, e0_.adresse AS adresse_8, e0_.coordonnee_gps AS coordonnee_gps_9, e0_.hebergement AS hebergement_10, e0_.particularite_etape AS particularite_etape_11, e0_.a_voir AS a_voir_12, e0_.a_faire AS a_faire_13, e0_.remarque AS remarque_14, e0_.num_etape AS num_etape_15, e0_.date_maj AS date_maj_16, e0_.date_cre AS date_cre_17 FROM etapes e0_ WHERE e0_.id_voyage_serveur = '507' AND e0_.id_etape_serveur IN (1481) ORDER BY e0_.num_etape ASC;

SELECT 
  t0.id_parametres AS id_parametres_1, 
  t0.date_connexion AS date_connexion_2, 
  t0.date_demande AS date_demande_3, 
  t0.renitialiser AS renitialiser_4, 
  t0.envoyer AS envoyer_5, 
  t0.id_credentiel AS id_credentiel_6, 
  t0.pseudo AS pseudo_7, 
  t0.mot_de_passe AS mot_de_passe_8, 
  t0.email AS email_9, 
  t0.nom AS nom_10, 
  t0.prenom AS prenom_11, 
  t0.date_naiss AS date_naiss_12, 
  t0.ville AS ville_13, 
  t0.id_liste_pays AS id_liste_pays_14, 
  t0.langue AS langue_15, 
  t0.visible AS visible_16, 
  t0.photo AS photo_17, 
  t0.voyage_public AS voyage_public_18, 
  t0.device AS device_19, 
  t0.latitude AS latitude_20, 
  t0.longitude AS longitude_21, 
  t0.lieu_localisation AS lieu_localisation_22, 
  t0.pays_localisation AS pays_localisation_23, 
  t0.facebook_id AS facebook_id_24, 
  t0.google_id AS google_id_25 
FROM 
  parametres t0 
WHERE 
  t0.id_parametres = ?

SELECT t0.id_parametres AS id_parametres_1, t0.date_connexion AS date_connexion_2, t0.date_demande AS date_demande_3, t0.renitialiser AS renitialiser_4, t0.envoyer AS envoyer_5, t0.id_credentiel AS id_credentiel_6, t0.pseudo AS pseudo_7, t0.mot_de_passe AS mot_de_passe_8, t0.email AS email_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.date_naiss AS date_naiss_12, t0.ville AS ville_13, t0.id_liste_pays AS id_liste_pays_14, t0.langue AS langue_15, t0.visible AS visible_16, t0.photo AS photo_17, t0.voyage_public AS voyage_public_18, t0.device AS device_19, t0.latitude AS latitude_20, t0.longitude AS longitude_21, t0.lieu_localisation AS lieu_localisation_22, t0.pays_localisation AS pays_localisation_23, t0.facebook_id AS facebook_id_24, t0.google_id AS google_id_25 FROM parametres t0 WHERE t0.id_parametres = 2;

SELECT 
  t0.id_photo_user AS id_photo_user_1, 
  t0.id_etape_serveur AS id_etape_serveur_2, 
  t0.extension AS extension_3, 
  t0.coment AS coment_4, 
  t0.actif AS actif_5, 
  t0.id_photo_mobile AS id_photo_mobile_6, 
  t0.id_etape_mobile AS id_etape_mobile_7 
FROM 
  photos_users t0 
WHERE 
  t0.id_etape_serveur = ?

SELECT t0.id_photo_user AS id_photo_user_1, t0.id_etape_serveur AS id_etape_serveur_2, t0.extension AS extension_3, t0.coment AS coment_4, t0.actif AS actif_5, t0.id_photo_mobile AS id_photo_mobile_6, t0.id_etape_mobile AS id_etape_mobile_7 FROM photos_users t0 WHERE t0.id_etape_serveur = 1481;

SELECT 
  count(DISTINCT e0_.id_etape_serveur) AS sclr_0 
FROM 
  etapes e0_ 
WHERE 
  e0_.id_voyage_serveur = '507'

SELECT count(DISTINCT e0_.id_etape_serveur) AS sclr_0 FROM etapes e0_ WHERE e0_.id_voyage_serveur = '507';

SELECT 
  t0.id_voyage_serveur AS id_voyage_serveur_1, 
  t0.id_parametre AS id_parametre_2, 
  t0.commentaire AS commentaire_3 
FROM 
  jaime t0 
WHERE 
  t0.id_voyage_serveur = ?

SELECT t0.id_voyage_serveur AS id_voyage_serveur_1, t0.id_parametre AS id_parametre_2, t0.commentaire AS commentaire_3 FROM jaime t0 WHERE t0.id_voyage_serveur = '507';

SELECT 
  DISTINCT e0_.id_etape_serveur AS id_etape_serveur_0, 
  e0_.num_etape AS num_etape_1 
FROM 
  etapes e0_ 
WHERE 
  e0_.id_voyage_serveur = '507' 
ORDER BY 
  e0_.num_etape ASC 
LIMIT 
  1

SELECT DISTINCT e0_.id_etape_serveur AS id_etape_serveur_0, e0_.num_etape AS num_etape_1 FROM etapes e0_ WHERE e0_.id_voyage_serveur = '507' ORDER BY e0_.num_etape ASC LIMIT 1;