Query Metrics
50
Database Queries
9
Different statements
521.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
496.31 ms (95.21%) |
1 |
SELECT m0_.id AS id_0, m0_.ancien_id AS ancien_id_1, m0_.nom AS nom_2, m0_.valider_envoi AS valider_envoi_3, m0_.envoyer AS envoyer_4, m0_.resumer AS resumer_5, m0_.type_mail AS type_mail_6, m0_.en_cour AS en_cour_7, m0_.objet AS objet_8, m0_.nb_mail_envoye AS nb_mail_envoye_9, m0_.nb_mail AS nb_mail_10, m0_.modification_old AS modification_old_11, m0_.objet_cour AS objet_cour_12, m0_.resumer_cour AS resumer_cour_13, m0_.color AS color_14, m0_.titre AS titre_15, m0_.content AS content_16, m0_.date_envoi AS date_envoi_17, m0_.langue AS langue_18, m0_.debut_mail_coupure AS debut_mail_coupure_19, m0_.fin_mail_coupure AS fin_mail_coupure_20, m0_.hyperlien AS hyperlien_21, m0_.signature AS signature_22, m0_.signature_contenu AS signature_contenu_23, m0_.priorite AS priorite_24, m0_.creation AS creation_25, m0_.modification AS modification_26, c1_.id AS id_27, c1_.nom AS nom_28, c1_.adresse_generique AS adresse_generique_29, c1_.adresse_coupure AS adresse_coupure_30, c1_.actuel AS actuel_31, c1_.ancien_id AS ancien_id_32, c1_.dirigeant AS dirigeant_33, c1_.date_entree AS date_entree_34, c1_.date_sortie AS date_sortie_35, c1_.duree AS duree_36, c1_.score AS score_37, l2_.id AS id_38, l2_.url AS url_39, c3_.id AS id_40, c3_.ancien_id AS ancien_id_41, c3_.nom AS nom_42, c3_.prenom AS prenom_43, c3_.email AS email_44, e4_.id AS id_45, e4_.nom AS nom_46, e4_.date_debut AS date_debut_47, e4_.date_fin AS date_fin_48, e4_.type AS type_49, e4_.full_day AS full_day_50, e4_.event_nom AS event_nom_51, a5_.id AS id_52, a5_.username AS username_53, a5_.password_mail AS password_mail_54, a5_.password AS password_55, a5_.roles AS roles_56, a5_.old_login AS old_login_57, a5_.old_password AS old_password_58, a5_.actuel AS actuel_59, a5_.fonction AS fonction_60, a5_.date_arrive AS date_arrive_61, a5_.tel_interne AS tel_interne_62, a5_.adresse_envoi AS adresse_envoi_63, a5_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_64, a5_.u_systeme AS u_systeme_65, u6_.id AS id_66, u6_.prenom AS prenom_67, u6_.nom AS nom_68, u6_.email AS email_69, u6_.resp_conge AS resp_conge_70, u6_.tel AS tel_71, a7_.id AS id_72, a7_.username AS username_73, a7_.password_mail AS password_mail_74, a7_.password AS password_75, a7_.roles AS roles_76, a7_.old_login AS old_login_77, a7_.old_password AS old_password_78, a7_.actuel AS actuel_79, a7_.fonction AS fonction_80, a7_.date_arrive AS date_arrive_81, a7_.tel_interne AS tel_interne_82, a7_.adresse_envoi AS adresse_envoi_83, a7_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_84, a7_.u_systeme AS u_systeme_85, u8_.id AS id_86, u8_.prenom AS prenom_87, u8_.nom AS nom_88, u8_.email AS email_89, u8_.resp_conge AS resp_conge_90, u8_.tel AS tel_91, p9_.id AS id_92, p9_.url AS url_93, p10_.id AS id_94, p10_.partie AS partie_95, p10_.contenu AS contenu_96, p11_.id AS id_97, p11_.url AS url_98, p12_.id AS id_99, p12_.url AS url_100, l13_.id AS id_101, l13_.url AS url_102, a14_.id AS id_103, a14_.username AS username_104, a14_.password_mail AS password_mail_105, a14_.password AS password_106, a14_.roles AS roles_107, a14_.old_login AS old_login_108, a14_.old_password AS old_password_109, a14_.actuel AS actuel_110, a14_.fonction AS fonction_111, a14_.date_arrive AS date_arrive_112, a14_.tel_interne AS tel_interne_113, a14_.adresse_envoi AS adresse_envoi_114, a14_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_115, a14_.u_systeme AS u_systeme_116, u15_.id AS id_117, u15_.prenom AS prenom_118, u15_.nom AS nom_119, u15_.email AS email_120, u15_.resp_conge AS resp_conge_121, u15_.tel AS tel_122, o16_.id AS id_123, o16_.libelle AS libelle_124, n17_.id AS id_125, n17_.libelle AS libelle_126, s18_.id AS id_127, s18_.libelle AS libelle_128, l19_.id AS id_129, l19_.nom AS nom_130, l19_.commentaires AS commentaires_131, l19_.creation AS creation_132, l19_.modification AS modification_133, l19_.ancien_id AS ancien_id_134, l20_.id AS id_135, l20_.nom AS nom_136, l20_.commentaires AS commentaires_137, l20_.creation AS creation_138, l20_.modification AS modification_139, l20_.ancien_id AS ancien_id_140, m0_.client_id AS client_id_141, m0_.envoye_par AS envoye_par_142, m0_.reply_to AS reply_to_143, m0_.pdf_id AS pdf_id_144, m0_.photo_id AS photo_id_145, m0_.logo_id AS logo_id_146, m0_.auteur_id AS auteur_id_147, m0_.outil_id AS outil_id_148, m0_.niveau_id AS niveau_id_149, m0_.sous_niveau_id AS sous_niveau_id_150, c1_.logo_id AS logo_id_151, c1_.pressroom_client AS pressroom_client_152, c1_.etat_id AS etat_id_153, c1_.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_154, c3_.client AS client_155, e4_.auteur AS auteur_156, e4_.salle AS salle_157, e4_.client AS client_158, a5_.user_id AS user_id_159, u6_.civilite AS civilite_160, u6_.id_adress AS id_adress_161, a7_.user_id AS user_id_162, u8_.civilite AS civilite_163, u8_.id_adress AS id_adress_164, p9_.mailling_id AS mailling_id_165, p9_.coupure_id AS coupure_id_166, p10_.mailling_id AS mailling_id_167, a14_.user_id AS user_id_168, u15_.civilite AS civilite_169, u15_.id_adress AS id_adress_170, l19_.auteur_id AS auteur_id_171, l19_.type_id AS type_id_172, l20_.auteur_id AS auteur_id_173, l20_.type_id AS type_id_174 FROM mailling m0_ INNER JOIN client c1_ ON m0_.client_id = c1_.id LEFT JOIN logo l2_ ON c1_.logo_id = l2_.id LEFT JOIN client_personne c3_ ON c1_.id = c3_.client LEFT JOIN evenement e4_ ON c1_.id = e4_.client LEFT JOIN auth_user a5_ ON m0_.envoye_par = a5_.id LEFT JOIN user u6_ ON a5_.user_id = u6_.id LEFT JOIN auth_user a7_ ON m0_.reply_to = a7_.id LEFT JOIN user u8_ ON a7_.user_id = u8_.id LEFT JOIN piece_jointe_mailling p9_ ON m0_.id = p9_.mailling_id LEFT JOIN partie_cp p10_ ON m0_.id = p10_.mailling_id LEFT JOIN pdf p11_ ON m0_.pdf_id = p11_.id LEFT JOIN photo_mailling p12_ ON m0_.photo_id = p12_.id LEFT JOIN logo_mailling l13_ ON m0_.logo_id = l13_.id LEFT JOIN auth_user a14_ ON m0_.auteur_id = a14_.id LEFT JOIN user u15_ ON a14_.user_id = u15_.id LEFT JOIN outil o16_ ON m0_.outil_id = o16_.id LEFT JOIN niveau n17_ ON m0_.niveau_id = n17_.id LEFT JOIN sous_niveau s18_ ON m0_.sous_niveau_id = s18_.id LEFT JOIN mailling_liste_associee m21_ ON m0_.id = m21_.mailling_id LEFT JOIN liste_contact l19_ ON l19_.id = m21_.liste_contact_id LEFT JOIN mailling_liste_desassociee m22_ ON m0_.id = m22_.mailling_id LEFT JOIN liste_contact l20_ ON l20_.id = m22_.liste_contact_id WHERE m0_.id IN (SELECT m23_.id FROM mailling m23_ INNER JOIN client c24_ ON m23_.client_id = c24_.id WHERE m23_.envoyer = ? AND m23_.type_mail = ? AND c24_.id = ?) ORDER BY m0_.id DESC
Parameters:
[ "1" "CP" "397" ] |
|
19.77 ms (3.79%) |
41 |
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 = ?
Parameters:
[
403
]
|
|
1.26 ms (0.24%) |
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 (?, ?, ?, ?, ?)
Parameters:
[ 158 175 129 173 168 ] |
|
1.26 ms (0.24%) |
2 |
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 (?)
Parameters:
[
3
]
|
|
0.64 ms (0.12%) |
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 (?)
Parameters:
[
174
]
|
|
0.55 ms (0.11%) |
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 = ?
Parameters:
[
174
]
|
|
0.54 ms (0.10%) |
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 = ? LIMIT 1
Parameters:
[
"PV+J7oCwYo3NcU+5Hns5dpkp7IPU1eoH4cCNMqOgfoTcflSgIaLtmhJSWphgPwLS6G4="
]
|
|
0.49 ms (0.09%) |
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 (?)
Parameters:
[
143
]
|
|
0.46 ms (0.09%) |
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 (?, ?, ?, ?, ?)
Parameters:
[ 127 144 99 142 137 ] |
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.