Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.adresse_generique AS adresse_generique_2,
  c0_.adresse_coupure AS adresse_coupure_3,
  c0_.actuel AS actuel_4,
  c0_.ancien_id AS ancien_id_5,
  c0_.dirigeant AS dirigeant_6,
  c0_.date_entree AS date_entree_7,
  c0_.date_sortie AS date_sortie_8,
  c0_.duree AS duree_9,
  c0_.score AS score_10,
  l1_.id AS id_11,
  l1_.url AS url_12,
  c2_.id AS id_13,
  c2_.role AS role_14,
  c2_.adresse_coupure AS adresse_coupure_15,
  c2_.adresse_generique AS adresse_generique_16,
  c2_.color AS color_17,
  a3_.id AS id_18,
  a3_.username AS username_19,
  a3_.password_mail AS password_mail_20,
  a3_.password AS password_21,
  a3_.roles AS roles_22,
  a3_.old_login AS old_login_23,
  a3_.old_password AS old_password_24,
  a3_.actuel AS actuel_25,
  a3_.fonction AS fonction_26,
  a3_.date_arrive AS date_arrive_27,
  a3_.tel_interne AS tel_interne_28,
  a3_.adresse_envoi AS adresse_envoi_29,
  a3_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_30,
  a3_.u_systeme AS u_systeme_31,
  u4_.id AS id_32,
  u4_.prenom AS prenom_33,
  u4_.nom AS nom_34,
  u4_.email AS email_35,
  u4_.resp_conge AS resp_conge_36,
  u4_.tel AS tel_37,
  c5_.id AS id_38,
  c5_.ancien_id AS ancien_id_39,
  c5_.nom AS nom_40,
  c5_.prenom AS prenom_41,
  c5_.email AS email_42,
  m6_.id AS id_43,
  m6_.libelle AS libelle_44,
  d7_.id AS id_45,
  d7_.nom AS nom_46,
  d7_.type AS type_47,
  d7_.creation AS creation_48,
  d7_.url AS url_49,
  e8_.id AS id_50,
  e8_.libelle AS libelle_51,
  c0_.logo_id AS logo_id_52,
  c0_.pressroom_client AS pressroom_client_53,
  c0_.etat_id AS etat_id_54,
  c2_.id_client AS id_client_55,
  c2_.id_user AS id_user_56,
  a3_.user_id AS user_id_57,
  u4_.civilite AS civilite_58,
  u4_.id_adress AS id_adress_59,
  c5_.client AS client_60,
  m6_.categorie_id AS categorie_id_61,
  m6_.sous_categorie_id AS sous_categorie_id_62,
  d7_.client AS client_63
FROM
  client c0_
  LEFT JOIN logo l1_ ON c0_.logo_id = l1_.id
  LEFT JOIN client_role_user c2_ ON c0_.id = c2_.id_client
  LEFT JOIN auth_user a3_ ON c2_.id_user = a3_.id
  LEFT JOIN user u4_ ON a3_.user_id = u4_.id
  LEFT JOIN client_personne c5_ ON c0_.id = c5_.client
  LEFT JOIN mots_cles_client m9_ ON c0_.id = m9_.client_id
  LEFT JOIN mots_cles m6_ ON m6_.id = m9_.mots_cles_id
  LEFT JOIN documents d7_ ON c0_.id = d7_.client
  LEFT JOIN etat e8_ ON c0_.etat_id = e8_.id
WHERE
  c0_.id IN (
    SELECT
      c10_.id
    FROM
      client c10_
      LEFT JOIN logo l11_ ON c10_.logo_id = l11_.id
      LEFT JOIN client_role_user c12_ ON c10_.id = c12_.id_client
      LEFT JOIN auth_user a13_ ON c12_.id_user = a13_.id
      LEFT JOIN user u14_ ON a13_.user_id = u14_.id
      LEFT JOIN client_personne c15_ ON c10_.id = c15_.client
      LEFT JOIN mots_cles_client m17_ ON c10_.id = m17_.client_id
      LEFT JOIN mots_cles m16_ ON m16_.id = m17_.mots_cles_id
      LEFT JOIN documents d18_ ON c10_.id = d18_.client
      LEFT JOIN etat e19_ ON c10_.etat_id = e19_.id
    WHERE
      c10_.actuel = ?
  )
ORDER BY
  c0_.nom ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.adresse_generique AS adresse_generique_2, c0_.adresse_coupure AS adresse_coupure_3, c0_.actuel AS actuel_4, c0_.ancien_id AS ancien_id_5, c0_.dirigeant AS dirigeant_6, c0_.date_entree AS date_entree_7, c0_.date_sortie AS date_sortie_8, c0_.duree AS duree_9, c0_.score AS score_10, l1_.id AS id_11, l1_.url AS url_12, c2_.id AS id_13, c2_.role AS role_14, c2_.adresse_coupure AS adresse_coupure_15, c2_.adresse_generique AS adresse_generique_16, c2_.color AS color_17, a3_.id AS id_18, a3_.username AS username_19, a3_.password_mail AS password_mail_20, a3_.password AS password_21, a3_.roles AS roles_22, a3_.old_login AS old_login_23, a3_.old_password AS old_password_24, a3_.actuel AS actuel_25, a3_.fonction AS fonction_26, a3_.date_arrive AS date_arrive_27, a3_.tel_interne AS tel_interne_28, a3_.adresse_envoi AS adresse_envoi_29, a3_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_30, a3_.u_systeme AS u_systeme_31, u4_.id AS id_32, u4_.prenom AS prenom_33, u4_.nom AS nom_34, u4_.email AS email_35, u4_.resp_conge AS resp_conge_36, u4_.tel AS tel_37, c5_.id AS id_38, c5_.ancien_id AS ancien_id_39, c5_.nom AS nom_40, c5_.prenom AS prenom_41, c5_.email AS email_42, m6_.id AS id_43, m6_.libelle AS libelle_44, d7_.id AS id_45, d7_.nom AS nom_46, d7_.type AS type_47, d7_.creation AS creation_48, d7_.url AS url_49, e8_.id AS id_50, e8_.libelle AS libelle_51, c0_.logo_id AS logo_id_52, c0_.pressroom_client AS pressroom_client_53, c0_.etat_id AS etat_id_54, c2_.id_client AS id_client_55, c2_.id_user AS id_user_56, a3_.user_id AS user_id_57, u4_.civilite AS civilite_58, u4_.id_adress AS id_adress_59, c5_.client AS client_60, m6_.categorie_id AS categorie_id_61, m6_.sous_categorie_id AS sous_categorie_id_62, d7_.client AS client_63 FROM client c0_ LEFT JOIN logo l1_ ON c0_.logo_id = l1_.id LEFT JOIN client_role_user c2_ ON c0_.id = c2_.id_client LEFT JOIN auth_user a3_ ON c2_.id_user = a3_.id LEFT JOIN user u4_ ON a3_.user_id = u4_.id LEFT JOIN client_personne c5_ ON c0_.id = c5_.client LEFT JOIN mots_cles_client m9_ ON c0_.id = m9_.client_id LEFT JOIN mots_cles m6_ ON m6_.id = m9_.mots_cles_id LEFT JOIN documents d7_ ON c0_.id = d7_.client LEFT JOIN etat e8_ ON c0_.etat_id = e8_.id WHERE c0_.id IN (SELECT c10_.id FROM client c10_ LEFT JOIN logo l11_ ON c10_.logo_id = l11_.id LEFT JOIN client_role_user c12_ ON c10_.id = c12_.id_client LEFT JOIN auth_user a13_ ON c12_.id_user = a13_.id LEFT JOIN user u14_ ON a13_.user_id = u14_.id LEFT JOIN client_personne c15_ ON c10_.id = c15_.client LEFT JOIN mots_cles_client m17_ ON c10_.id = m17_.client_id LEFT JOIN mots_cles m16_ ON m16_.id = m17_.mots_cles_id LEFT JOIN documents d18_ ON c10_.id = d18_.client LEFT JOIN etat e19_ ON c10_.etat_id = e19_.id WHERE c10_.actuel = '1') ORDER BY c0_.nom ASC, c0_.id ASC;

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 = 169;

SELECT
  t0.id AS id_1,
  t0.client_id AS client_id_2,
  t0.premier_membre_id AS premier_membre_id_3,
  t0.deuxieme_membre_id AS deuxieme_membre_id_4,
  t0.troisieme_membre_id AS troisieme_membre_id_5
FROM
  membre t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.premier_membre_id AS premier_membre_id_3, t0.deuxieme_membre_id AS deuxieme_membre_id_4, t0.troisieme_membre_id AS troisieme_membre_id_5 FROM membre t0 WHERE t0.client_id = 169;

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,
  t0.id_user AS id_user_22
FROM
  client_role_user t0
  LEFT JOIN client t7 ON t0.id_client = t7.id
WHERE
  t0.id_user = ?

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, t0.id_user AS id_user_22 FROM client_role_user t0 LEFT JOIN client t7 ON t0.id_client = t7.id WHERE t0.id_user = 5;

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 (138);

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.nom AS nom_2,
  t0.adresse_generique AS adresse_generique_3,
  t0.adresse_coupure AS adresse_coupure_4,
  t0.actuel AS actuel_5,
  t0.ancien_id AS ancien_id_6,
  t0.dirigeant AS dirigeant_7,
  t0.date_entree AS date_entree_8,
  t0.date_sortie AS date_sortie_9,
  t0.duree AS duree_10,
  t0.score AS score_11,
  t0.logo_id AS logo_id_12,
  t0.pressroom_client AS pressroom_client_13,
  t14.id AS id_15,
  t14.ancien_id AS ancien_id_16,
  t14.nom AS nom_17,
  t14.date_creation AS date_creation_18,
  t14.siren AS siren_19,
  t14.capital AS capital_20,
  t14.effectif AS effectif_21,
  t14.implantation AS implantation_22,
  t14.commentaires AS commentaires_23,
  t14.creation AS creation_24,
  t14.modification AS modification_25,
  t14.auteur_id AS auteur_id_26,
  t14.appartenir_a_id AS appartenir_a_id_27,
  t14.client_id AS client_id_28,
  t14.forme_juridique_id AS forme_juridique_id_29,
  t14.genre_id AS genre_id_30,
  t14.categorie_generale_id AS categorie_generale_id_31,
  t14.coordonnees_id AS coordonnees_id_32,
  t14.dirigeant_id AS dirigeant_id_33,
  t14.ape_id AS ape_id_34,
  t0.etat_id AS etat_id_35
FROM
  client t0
  LEFT JOIN organisation t14 ON t14.client_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_generique AS adresse_generique_3, t0.adresse_coupure AS adresse_coupure_4, t0.actuel AS actuel_5, t0.ancien_id AS ancien_id_6, t0.dirigeant AS dirigeant_7, t0.date_entree AS date_entree_8, t0.date_sortie AS date_sortie_9, t0.duree AS duree_10, t0.score AS score_11, t0.logo_id AS logo_id_12, t0.pressroom_client AS pressroom_client_13, t14.id AS id_15, t14.ancien_id AS ancien_id_16, t14.nom AS nom_17, t14.date_creation AS date_creation_18, t14.siren AS siren_19, t14.capital AS capital_20, t14.effectif AS effectif_21, t14.implantation AS implantation_22, t14.commentaires AS commentaires_23, t14.creation AS creation_24, t14.modification AS modification_25, t14.auteur_id AS auteur_id_26, t14.appartenir_a_id AS appartenir_a_id_27, t14.client_id AS client_id_28, t14.forme_juridique_id AS forme_juridique_id_29, t14.genre_id AS genre_id_30, t14.categorie_generale_id AS categorie_generale_id_31, t14.coordonnees_id AS coordonnees_id_32, t14.dirigeant_id AS dirigeant_id_33, t14.ape_id AS ape_id_34, t0.etat_id AS etat_id_35 FROM client t0 LEFT JOIN organisation t14 ON t14.client_id = t0.id WHERE t0.id IN (411, 399, 168, 321, 396, 420);

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,
  t25.id AS id_26,
  t25.role AS role_27,
  t25.adresse_coupure AS adresse_coupure_28,
  t25.adresse_generique AS adresse_generique_29,
  t25.color AS color_30,
  t25.id_client AS id_client_31,
  t25.id_user AS id_user_32
FROM
  auth_user t0
  LEFT JOIN user t16 ON t0.user_id = t16.id
  LEFT JOIN client_role_user t25 ON t25.id_user = t0.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, t25.id AS id_26, t25.role AS role_27, t25.adresse_coupure AS adresse_coupure_28, t25.adresse_generique AS adresse_generique_29, t25.color AS color_30, t25.id_client AS id_client_31, t25.id_user AS id_user_32 FROM auth_user t0 LEFT JOIN user t16 ON t0.user_id = t16.id LEFT JOIN client_role_user t25 ON t25.id_user = t0.id WHERE t0.id = 169;

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 = 'Zs07tFK8ie3Ml6Sbz7zjVAEobXh3ZQVU0BH3msQxmLhg4ayznutfNvDF6kjIdP4Qc=' LIMIT 1;