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 = 'Zs07tFK8ie3Ml6Sbz7zjVAEobXh3ZQVU0BH3msQxmLhg4ayznutfNvDF6kjIdP4Qc=' 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,
  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.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.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.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
  s0_.id AS id_0,
  s0_.nom AS nom_1,
  s0_.date_parution AS date_parution_2,
  s0_.date_bouclage AS date_bouclage_3,
  s0_.audience AS audience_4,
  s0_.mediametrie AS mediametrie_5,
  s0_.ojd AS ojd_6,
  s0_.equiv_pub AS equiv_pub_7,
  s0_.precisions AS precisions_8,
  s0_.positionnement AS positionnement_9,
  s0_.cible AS cible_10,
  s0_.commentaires AS commentaires_11,
  s0_.disponibilite AS disponibilite_12,
  s0_.exemp_dispo AS exemp_dispo_13,
  s0_.ancien_id AS ancien_id_14,
  s0_.creation AS creation_15,
  s0_.modification AS modification_16,
  s0_.tel_standard AS tel_standard_17,
  s0_.tel_publicite AS tel_publicite_18,
  c1_.id AS id_19,
  c1_.libelle AS libelle_20,
  t2_.id AS id_21,
  t2_.libelle AS libelle_22,
  e3_.id AS id_23,
  e3_.libelle AS libelle_24,
  o4_.id AS id_25,
  o4_.ancien_id AS ancien_id_26,
  o4_.nom AS nom_27,
  o4_.date_creation AS date_creation_28,
  o4_.siren AS siren_29,
  o4_.capital AS capital_30,
  o4_.effectif AS effectif_31,
  o4_.implantation AS implantation_32,
  o4_.commentaires AS commentaires_33,
  o4_.creation AS creation_34,
  o4_.modification AS modification_35,
  f5_.id AS id_36,
  f5_.libelle AS libelle_37,
  p6_.id AS id_38,
  p6_.libelle AS libelle_39,
  p6_.equiv_heures AS equiv_heures_40,
  t7_.id AS id_41,
  t7_.libelle AS libelle_42,
  z8_.id AS id_43,
  z8_.libelle AS libelle_44,
  c9_.id AS id_45,
  c9_.premier_tel AS premier_tel_46,
  c9_.deuxieme_tel AS deuxieme_tel_47,
  c9_.email AS email_48,
  c9_.rue AS rue_49,
  c9_.complements AS complements_50,
  c9_.boite_postale AS boite_postale_51,
  c9_.code_postal AS code_postal_52,
  c9_.ville AS ville_53,
  c9_.premier_url AS premier_url_54,
  c9_.deuxieme_url AS deuxieme_url_55,
  c9_.creation AS creation_56,
  c9_.modification AS modification_57,
  c9_.ancien_id AS ancien_id_58,
  p10_.id AS id_59,
  p10_.libelle_fr AS libelle_fr_60,
  p10_.libelle_en AS libelle_en_61,
  p10_.iso AS iso_62,
  a11_.id AS id_63,
  a11_.username AS username_64,
  a11_.password_mail AS password_mail_65,
  a11_.password AS password_66,
  a11_.roles AS roles_67,
  a11_.old_login AS old_login_68,
  a11_.old_password AS old_password_69,
  a11_.actuel AS actuel_70,
  a11_.fonction AS fonction_71,
  a11_.date_arrive AS date_arrive_72,
  a11_.tel_interne AS tel_interne_73,
  a11_.adresse_envoi AS adresse_envoi_74,
  a11_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_75,
  a11_.u_systeme AS u_systeme_76,
  u12_.id AS id_77,
  u12_.prenom AS prenom_78,
  u12_.nom AS nom_79,
  u12_.email AS email_80,
  u12_.resp_conge AS resp_conge_81,
  u12_.tel AS tel_82,
  l13_.id AS id_83,
  l13_.libelle AS libelle_84,
  l13_.iso AS iso_85,
  p14_.id AS id_86,
  p14_.libelle_fr AS libelle_fr_87,
  p14_.libelle_en AS libelle_en_88,
  p14_.iso AS iso_89,
  s15_.id AS id_90,
  s15_.libelle AS libelle_91,
  s15_.ancien_id AS ancien_id_92,
  l16_.id AS id_93,
  l16_.url AS url_94,
  s0_.casier_id AS casier_id_95,
  s0_.type_media_id AS type_media_id_96,
  s0_.etat_id AS etat_id_97,
  s0_.organisation_id AS organisation_id_98,
  s0_.famille_id AS famille_id_99,
  s0_.periodicite_id AS periodicite_id_100,
  s0_.type_ojd_id AS type_ojd_id_101,
  s0_.zone_diffusion_id AS zone_diffusion_id_102,
  s0_.coordonnees_id AS coordonnees_id_103,
  s0_.auteur_id AS auteur_id_104,
  s0_.logo_support_id AS logo_support_id_105,
  o4_.auteur_id AS auteur_id_106,
  o4_.appartenir_a_id AS appartenir_a_id_107,
  o4_.client_id AS client_id_108,
  o4_.forme_juridique_id AS forme_juridique_id_109,
  o4_.genre_id AS genre_id_110,
  o4_.categorie_generale_id AS categorie_generale_id_111,
  o4_.coordonnees_id AS coordonnees_id_112,
  o4_.dirigeant_id AS dirigeant_id_113,
  o4_.ape_id AS ape_id_114,
  c9_.pays_id AS pays_id_115,
  c9_.auteur_id AS auteur_id_116,
  a11_.user_id AS user_id_117,
  u12_.civilite AS civilite_118,
  u12_.id_adress AS id_adress_119
FROM
  support s0_
  LEFT JOIN casier c1_ ON s0_.casier_id = c1_.id
  LEFT JOIN type_media t2_ ON s0_.type_media_id = t2_.id
  LEFT JOIN etat e3_ ON s0_.etat_id = e3_.id
  LEFT JOIN organisation o4_ ON s0_.organisation_id = o4_.id
  LEFT JOIN famille f5_ ON s0_.famille_id = f5_.id
  LEFT JOIN periodicite p6_ ON s0_.periodicite_id = p6_.id
  LEFT JOIN type_ojd t7_ ON s0_.type_ojd_id = t7_.id
  LEFT JOIN zone_diffusion z8_ ON s0_.zone_diffusion_id = z8_.id
  LEFT JOIN coordonnees c9_ ON s0_.coordonnees_id = c9_.id
  LEFT JOIN pays p10_ ON c9_.pays_id = p10_.id
  LEFT JOIN auth_user a11_ ON s0_.auteur_id = a11_.id
  LEFT JOIN user u12_ ON a11_.user_id = u12_.id
  LEFT JOIN support_langues s17_ ON s0_.id = s17_.support_id
  LEFT JOIN langues l13_ ON l13_.id = s17_.langues_id
  LEFT JOIN support_pays s18_ ON s0_.id = s18_.support_id
  LEFT JOIN pays p14_ ON p14_.id = s18_.pays_id
  LEFT JOIN support_secteur s19_ ON s0_.id = s19_.support_id
  LEFT JOIN secteur s15_ ON s15_.id = s19_.secteur_id
  LEFT JOIN logo_support l16_ ON s0_.logo_support_id = l16_.id
WHERE
  s0_.id = ?

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.date_parution AS date_parution_2, s0_.date_bouclage AS date_bouclage_3, s0_.audience AS audience_4, s0_.mediametrie AS mediametrie_5, s0_.ojd AS ojd_6, s0_.equiv_pub AS equiv_pub_7, s0_.precisions AS precisions_8, s0_.positionnement AS positionnement_9, s0_.cible AS cible_10, s0_.commentaires AS commentaires_11, s0_.disponibilite AS disponibilite_12, s0_.exemp_dispo AS exemp_dispo_13, s0_.ancien_id AS ancien_id_14, s0_.creation AS creation_15, s0_.modification AS modification_16, s0_.tel_standard AS tel_standard_17, s0_.tel_publicite AS tel_publicite_18, c1_.id AS id_19, c1_.libelle AS libelle_20, t2_.id AS id_21, t2_.libelle AS libelle_22, e3_.id AS id_23, e3_.libelle AS libelle_24, o4_.id AS id_25, o4_.ancien_id AS ancien_id_26, o4_.nom AS nom_27, o4_.date_creation AS date_creation_28, o4_.siren AS siren_29, o4_.capital AS capital_30, o4_.effectif AS effectif_31, o4_.implantation AS implantation_32, o4_.commentaires AS commentaires_33, o4_.creation AS creation_34, o4_.modification AS modification_35, f5_.id AS id_36, f5_.libelle AS libelle_37, p6_.id AS id_38, p6_.libelle AS libelle_39, p6_.equiv_heures AS equiv_heures_40, t7_.id AS id_41, t7_.libelle AS libelle_42, z8_.id AS id_43, z8_.libelle AS libelle_44, c9_.id AS id_45, c9_.premier_tel AS premier_tel_46, c9_.deuxieme_tel AS deuxieme_tel_47, c9_.email AS email_48, c9_.rue AS rue_49, c9_.complements AS complements_50, c9_.boite_postale AS boite_postale_51, c9_.code_postal AS code_postal_52, c9_.ville AS ville_53, c9_.premier_url AS premier_url_54, c9_.deuxieme_url AS deuxieme_url_55, c9_.creation AS creation_56, c9_.modification AS modification_57, c9_.ancien_id AS ancien_id_58, p10_.id AS id_59, p10_.libelle_fr AS libelle_fr_60, p10_.libelle_en AS libelle_en_61, p10_.iso AS iso_62, a11_.id AS id_63, a11_.username AS username_64, a11_.password_mail AS password_mail_65, a11_.password AS password_66, a11_.roles AS roles_67, a11_.old_login AS old_login_68, a11_.old_password AS old_password_69, a11_.actuel AS actuel_70, a11_.fonction AS fonction_71, a11_.date_arrive AS date_arrive_72, a11_.tel_interne AS tel_interne_73, a11_.adresse_envoi AS adresse_envoi_74, a11_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_75, a11_.u_systeme AS u_systeme_76, u12_.id AS id_77, u12_.prenom AS prenom_78, u12_.nom AS nom_79, u12_.email AS email_80, u12_.resp_conge AS resp_conge_81, u12_.tel AS tel_82, l13_.id AS id_83, l13_.libelle AS libelle_84, l13_.iso AS iso_85, p14_.id AS id_86, p14_.libelle_fr AS libelle_fr_87, p14_.libelle_en AS libelle_en_88, p14_.iso AS iso_89, s15_.id AS id_90, s15_.libelle AS libelle_91, s15_.ancien_id AS ancien_id_92, l16_.id AS id_93, l16_.url AS url_94, s0_.casier_id AS casier_id_95, s0_.type_media_id AS type_media_id_96, s0_.etat_id AS etat_id_97, s0_.organisation_id AS organisation_id_98, s0_.famille_id AS famille_id_99, s0_.periodicite_id AS periodicite_id_100, s0_.type_ojd_id AS type_ojd_id_101, s0_.zone_diffusion_id AS zone_diffusion_id_102, s0_.coordonnees_id AS coordonnees_id_103, s0_.auteur_id AS auteur_id_104, s0_.logo_support_id AS logo_support_id_105, o4_.auteur_id AS auteur_id_106, o4_.appartenir_a_id AS appartenir_a_id_107, o4_.client_id AS client_id_108, o4_.forme_juridique_id AS forme_juridique_id_109, o4_.genre_id AS genre_id_110, o4_.categorie_generale_id AS categorie_generale_id_111, o4_.coordonnees_id AS coordonnees_id_112, o4_.dirigeant_id AS dirigeant_id_113, o4_.ape_id AS ape_id_114, c9_.pays_id AS pays_id_115, c9_.auteur_id AS auteur_id_116, a11_.user_id AS user_id_117, u12_.civilite AS civilite_118, u12_.id_adress AS id_adress_119 FROM support s0_ LEFT JOIN casier c1_ ON s0_.casier_id = c1_.id LEFT JOIN type_media t2_ ON s0_.type_media_id = t2_.id LEFT JOIN etat e3_ ON s0_.etat_id = e3_.id LEFT JOIN organisation o4_ ON s0_.organisation_id = o4_.id LEFT JOIN famille f5_ ON s0_.famille_id = f5_.id LEFT JOIN periodicite p6_ ON s0_.periodicite_id = p6_.id LEFT JOIN type_ojd t7_ ON s0_.type_ojd_id = t7_.id LEFT JOIN zone_diffusion z8_ ON s0_.zone_diffusion_id = z8_.id LEFT JOIN coordonnees c9_ ON s0_.coordonnees_id = c9_.id LEFT JOIN pays p10_ ON c9_.pays_id = p10_.id LEFT JOIN auth_user a11_ ON s0_.auteur_id = a11_.id LEFT JOIN user u12_ ON a11_.user_id = u12_.id LEFT JOIN support_langues s17_ ON s0_.id = s17_.support_id LEFT JOIN langues l13_ ON l13_.id = s17_.langues_id LEFT JOIN support_pays s18_ ON s0_.id = s18_.support_id LEFT JOIN pays p14_ ON p14_.id = s18_.pays_id LEFT JOIN support_secteur s19_ ON s0_.id = s19_.support_id LEFT JOIN secteur s15_ ON s15_.id = s19_.secteur_id LEFT JOIN logo_support l16_ ON s0_.logo_support_id = l16_.id WHERE s0_.id = 4067;

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.coordonnees_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.coordonnees_id = 18490;

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.mode_envoi_pref AS mode_envoi_pref_5,
  t0.pieces_jointes AS pieces_jointes_6,
  t0.contact_perso AS contact_perso_7,
  t0.commentaires AS commentaires_8,
  t0.objet AS objet_9,
  t0.date_conclusion AS date_conclusion_10,
  t0.creation AS creation_11,
  t0.modification AS modification_12,
  t0.auteur_id AS auteur_id_13,
  t0.civilite_id AS civilite_id_14,
  t0.fonction_id AS fonction_id_15,
  t0.coordonnees_id AS coordonnees_id_16,
  t0.genre_id AS genre_id_17,
  t0.reseaux_sociaux_id AS reseaux_sociaux_id_18
FROM
  contact t0
WHERE
  t0.coordonnees_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.mode_envoi_pref AS mode_envoi_pref_5, t0.pieces_jointes AS pieces_jointes_6, t0.contact_perso AS contact_perso_7, t0.commentaires AS commentaires_8, t0.objet AS objet_9, t0.date_conclusion AS date_conclusion_10, t0.creation AS creation_11, t0.modification AS modification_12, t0.auteur_id AS auteur_id_13, t0.civilite_id AS civilite_id_14, t0.fonction_id AS fonction_id_15, t0.coordonnees_id AS coordonnees_id_16, t0.genre_id AS genre_id_17, t0.reseaux_sociaux_id AS reseaux_sociaux_id_18 FROM contact t0 WHERE t0.coordonnees_id = 18490;