Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_at AS created_at_3,
  t0.auth_user_id AS auth_user_id_4
FROM
  auth_tokens t0
WHERE
  t0.value = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.auth_user_id AS auth_user_id_4 FROM auth_tokens t0 WHERE t0.value = 'tDRv0ps9MQcjP2H6SvGG5qqaZpVcjGbE39cMsTwhKOJJB5rov+nGO4V4bCAp50yzlI=' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password_mail AS password_mail_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.old_login AS old_login_6,
  t0.old_password AS old_password_7,
  t0.actuel AS actuel_8,
  t0.fonction AS fonction_9,
  t0.date_arrive AS date_arrive_10,
  t0.tel_interne AS tel_interne_11,
  t0.adresse_envoi AS adresse_envoi_12,
  t0.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_13,
  t0.u_systeme AS u_systeme_14,
  t0.user_id AS user_id_15,
  t16.id AS id_17,
  t16.prenom AS prenom_18,
  t16.nom AS nom_19,
  t16.email AS email_20,
  t16.resp_conge AS resp_conge_21,
  t16.tel AS tel_22,
  t16.civilite AS civilite_23,
  t16.id_adress AS id_adress_24
FROM
  auth_user t0
  LEFT JOIN user t16 ON t0.user_id = t16.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password_mail AS password_mail_3, t0.password AS password_4, t0.roles AS roles_5, t0.old_login AS old_login_6, t0.old_password AS old_password_7, t0.actuel AS actuel_8, t0.fonction AS fonction_9, t0.date_arrive AS date_arrive_10, t0.tel_interne AS tel_interne_11, t0.adresse_envoi AS adresse_envoi_12, t0.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_13, t0.u_systeme AS u_systeme_14, t0.user_id AS user_id_15, t16.id AS id_17, t16.prenom AS prenom_18, t16.nom AS nom_19, t16.email AS email_20, t16.resp_conge AS resp_conge_21, t16.tel AS tel_22, t16.civilite AS civilite_23, t16.id_adress AS id_adress_24 FROM auth_user t0 LEFT JOIN user t16 ON t0.user_id = t16.id WHERE t0.id = 158;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.libelle AS libelle_3,
  t0.genre AS genre_4
FROM
  civilite t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.libelle AS libelle_3, t0.genre AS genre_4 FROM civilite t0 WHERE t0.id IN (1);

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.adresse_coupure AS adresse_coupure_3,
  t0.adresse_generique AS adresse_generique_4,
  t0.color AS color_5,
  t0.id_client AS id_client_6,
  t7.id AS id_8,
  t7.nom AS nom_9,
  t7.adresse_generique AS adresse_generique_10,
  t7.adresse_coupure AS adresse_coupure_11,
  t7.actuel AS actuel_12,
  t7.ancien_id AS ancien_id_13,
  t7.dirigeant AS dirigeant_14,
  t7.date_entree AS date_entree_15,
  t7.date_sortie AS date_sortie_16,
  t7.duree AS duree_17,
  t7.score AS score_18,
  t7.logo_id AS logo_id_19,
  t7.pressroom_client AS pressroom_client_20,
  t7.etat_id AS etat_id_21,
  t7.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_22,
  t0.id_user AS id_user_23
FROM
  client_role_user t0
  LEFT JOIN client t7 ON t0.id_client = t7.id
WHERE
  t0.id_user IN (?)

SELECT t0.id AS id_1, t0.role AS role_2, t0.adresse_coupure AS adresse_coupure_3, t0.adresse_generique AS adresse_generique_4, t0.color AS color_5, t0.id_client AS id_client_6, t7.id AS id_8, t7.nom AS nom_9, t7.adresse_generique AS adresse_generique_10, t7.adresse_coupure AS adresse_coupure_11, t7.actuel AS actuel_12, t7.ancien_id AS ancien_id_13, t7.dirigeant AS dirigeant_14, t7.date_entree AS date_entree_15, t7.date_sortie AS date_sortie_16, t7.duree AS duree_17, t7.score AS score_18, t7.logo_id AS logo_id_19, t7.pressroom_client AS pressroom_client_20, t7.etat_id AS etat_id_21, t7.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_22, t0.id_user AS id_user_23 FROM client_role_user t0 LEFT JOIN client t7 ON t0.id_client = t7.id WHERE t0.id_user IN (158);

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 375;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 133;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 397;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 396;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 423;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.date_creation AS date_creation_4,
  t0.siren AS siren_5,
  t0.capital AS capital_6,
  t0.effectif AS effectif_7,
  t0.implantation AS implantation_8,
  t0.commentaires AS commentaires_9,
  t0.creation AS creation_10,
  t0.modification AS modification_11,
  t0.auteur_id AS auteur_id_12,
  t0.appartenir_a_id AS appartenir_a_id_13,
  t0.client_id AS client_id_14,
  t0.forme_juridique_id AS forme_juridique_id_15,
  t0.genre_id AS genre_id_16,
  t0.categorie_generale_id AS categorie_generale_id_17,
  t0.coordonnees_id AS coordonnees_id_18,
  t0.dirigeant_id AS dirigeant_id_19,
  t0.ape_id AS ape_id_20
FROM
  organisation t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.date_creation AS date_creation_4, t0.siren AS siren_5, t0.capital AS capital_6, t0.effectif AS effectif_7, t0.implantation AS implantation_8, t0.commentaires AS commentaires_9, t0.creation AS creation_10, t0.modification AS modification_11, t0.auteur_id AS auteur_id_12, t0.appartenir_a_id AS appartenir_a_id_13, t0.client_id AS client_id_14, t0.forme_juridique_id AS forme_juridique_id_15, t0.genre_id AS genre_id_16, t0.categorie_generale_id AS categorie_generale_id_17, t0.coordonnees_id AS coordonnees_id_18, t0.dirigeant_id AS dirigeant_id_19, t0.ape_id AS ape_id_20 FROM organisation t0 WHERE t0.client_id = 424;

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.ville AS ville_3,
  t0.code_postal AS code_postal_4,
  t0.pays AS pays_5,
  t0.complement AS complement_6
FROM
  adresse t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.ville AS ville_3, t0.code_postal AS code_postal_4, t0.pays AS pays_5, t0.complement AS complement_6 FROM adresse t0 WHERE t0.id IN (127);

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  contact c0_
  LEFT JOIN fonction f1_ ON c0_.fonction_id = f1_.id
  LEFT JOIN genre g2_ ON c0_.genre_id = g2_.id
WHERE
  (
    CONCAT(c0_.nom, ' ', c0_.prenom) LIKE '%lilia fernandez%'
    OR CONCAT(c0_.prenom, ' ', c0_.nom) LIKE '%lilia fernandez%'
  )

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM contact c0_ LEFT JOIN fonction f1_ ON c0_.fonction_id = f1_.id LEFT JOIN genre g2_ ON c0_.genre_id = g2_.id WHERE (CONCAT(c0_.nom, ' ', c0_.prenom) LIKE '%lilia fernandez%' OR CONCAT(c0_.prenom, ' ', c0_.nom) LIKE '%lilia fernandez%');

SELECT
  c0_.id AS id_0,
  c0_.ancien_id AS ancien_id_1,
  c0_.nom AS nom_2,
  c0_.prenom AS prenom_3,
  c0_.mode_envoi_pref AS mode_envoi_pref_4,
  c0_.pieces_jointes AS pieces_jointes_5,
  c0_.contact_perso AS contact_perso_6,
  c0_.commentaires AS commentaires_7,
  c0_.objet AS objet_8,
  c0_.date_conclusion AS date_conclusion_9,
  c0_.creation AS creation_10,
  c0_.modification AS modification_11,
  c0_.dernier_import AS dernier_import_12,
  f1_.id AS id_13,
  f1_.libelle AS libelle_14,
  f1_.ancien_id AS ancien_id_15,
  g2_.id AS id_16,
  g2_.libelle AS libelle_17,
  c0_.auteur_id AS auteur_id_18,
  c0_.civilite_id AS civilite_id_19,
  c0_.fonction_id AS fonction_id_20,
  c0_.coordonnees_id AS coordonnees_id_21,
  c0_.genre_id AS genre_id_22,
  c0_.reseaux_sociaux_id AS reseaux_sociaux_id_23
FROM
  contact c0_
  LEFT JOIN fonction f1_ ON c0_.fonction_id = f1_.id
  LEFT JOIN genre g2_ ON c0_.genre_id = g2_.id
WHERE
  (
    CONCAT(c0_.nom, ' ', c0_.prenom) LIKE '%lilia fernandez%'
    OR CONCAT(c0_.prenom, ' ', c0_.nom) LIKE '%lilia fernandez%'
  )
ORDER BY
  c0_.nom ASC
LIMIT
  30

SELECT c0_.id AS id_0, c0_.ancien_id AS ancien_id_1, c0_.nom AS nom_2, c0_.prenom AS prenom_3, c0_.mode_envoi_pref AS mode_envoi_pref_4, c0_.pieces_jointes AS pieces_jointes_5, c0_.contact_perso AS contact_perso_6, c0_.commentaires AS commentaires_7, c0_.objet AS objet_8, c0_.date_conclusion AS date_conclusion_9, c0_.creation AS creation_10, c0_.modification AS modification_11, c0_.dernier_import AS dernier_import_12, f1_.id AS id_13, f1_.libelle AS libelle_14, f1_.ancien_id AS ancien_id_15, g2_.id AS id_16, g2_.libelle AS libelle_17, c0_.auteur_id AS auteur_id_18, c0_.civilite_id AS civilite_id_19, c0_.fonction_id AS fonction_id_20, c0_.coordonnees_id AS coordonnees_id_21, c0_.genre_id AS genre_id_22, c0_.reseaux_sociaux_id AS reseaux_sociaux_id_23 FROM contact c0_ LEFT JOIN fonction f1_ ON c0_.fonction_id = f1_.id LEFT JOIN genre g2_ ON c0_.genre_id = g2_.id WHERE (CONCAT(c0_.nom, ' ', c0_.prenom) LIKE '%lilia fernandez%' OR CONCAT(c0_.prenom, ' ', c0_.nom) LIKE '%lilia fernandez%') ORDER BY c0_.nom ASC LIMIT 30;