Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

28.12 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	28.12 ms	SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.valider_envoi AS valider_envoi_4, t0.envoyer AS envoyer_5, t0.resumer AS resumer_6, t0.type_mail AS type_mail_7, t0.en_cour AS en_cour_8, t0.objet AS objet_9, t0.nb_mail_envoye AS nb_mail_envoye_10, t0.nb_mail AS nb_mail_11, t0.modification_old AS modification_old_12, t0.objet_cour AS objet_cour_13, t0.resumer_cour AS resumer_cour_14, t0.color AS color_15, t0.titre AS titre_16, t0.content AS content_17, t0.date_envoi AS date_envoi_18, t0.langue AS langue_19, t0.debut_mail_coupure AS debut_mail_coupure_20, t0.fin_mail_coupure AS fin_mail_coupure_21, t0.hyperlien AS hyperlien_22, t0.signature AS signature_23, t0.signature_contenu AS signature_contenu_24, t0.client_id AS client_id_25, t0.envoye_par AS envoye_par_26, t0.reply_to AS reply_to_27, t0.pdf_id AS pdf_id_28, t0.photo_id AS photo_id_29, t0.logo_id AS logo_id_30 FROM mailling t0 WHERE t0.ancien_id = ? Parameters: [`"27943"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.valider_envoi AS valider_envoi_4, t0.envoyer AS envoyer_5, t0.resumer AS resumer_6, t0.type_mail AS type_mail_7, t0.en_cour AS en_cour_8, t0.objet AS objet_9, t0.nb_mail_envoye AS nb_mail_envoye_10, t0.nb_mail AS nb_mail_11, t0.modification_old AS modification_old_12, t0.objet_cour AS objet_cour_13, t0.resumer_cour AS resumer_cour_14, t0.color AS color_15, t0.titre AS titre_16, t0.content AS content_17, t0.date_envoi AS date_envoi_18, t0.langue AS langue_19, t0.debut_mail_coupure AS debut_mail_coupure_20, t0.fin_mail_coupure AS fin_mail_coupure_21, t0.hyperlien AS hyperlien_22, t0.signature AS signature_23, t0.signature_contenu AS signature_contenu_24, t0.client_id AS client_id_25, t0.envoye_par AS envoye_par_26, t0.reply_to AS reply_to_27, t0.pdf_id AS pdf_id_28, t0.photo_id AS photo_id_29, t0.logo_id AS logo_id_30 FROM mailling t0 WHERE t0.ancien_id = ? SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.valider_envoi AS valider_envoi_4, t0.envoyer AS envoyer_5, t0.resumer AS resumer_6, t0.type_mail AS type_mail_7, t0.en_cour AS en_cour_8, t0.objet AS objet_9, t0.nb_mail_envoye AS nb_mail_envoye_10, t0.nb_mail AS nb_mail_11, t0.modification_old AS modification_old_12, t0.objet_cour AS objet_cour_13, t0.resumer_cour AS resumer_cour_14, t0.color AS color_15, t0.titre AS titre_16, t0.content AS content_17, t0.date_envoi AS date_envoi_18, t0.langue AS langue_19, t0.debut_mail_coupure AS debut_mail_coupure_20, t0.fin_mail_coupure AS fin_mail_coupure_21, t0.hyperlien AS hyperlien_22, t0.signature AS signature_23, t0.signature_contenu AS signature_contenu_24, t0.client_id AS client_id_25, t0.envoye_par AS envoye_par_26, t0.reply_to AS reply_to_27, t0.pdf_id AS pdf_id_28, t0.photo_id AS photo_id_29, t0.logo_id AS logo_id_30 FROM mailling t0 WHERE t0.ancien_id = '27943';

#▲

Time

Info

28.12 ms

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.valider_envoi AS valider_envoi_4, t0.envoyer AS envoyer_5, t0.resumer AS resumer_6, t0.type_mail AS type_mail_7, t0.en_cour AS en_cour_8, t0.objet AS objet_9, t0.nb_mail_envoye AS nb_mail_envoye_10, t0.nb_mail AS nb_mail_11, t0.modification_old AS modification_old_12, t0.objet_cour AS objet_cour_13, t0.resumer_cour AS resumer_cour_14, t0.color AS color_15, t0.titre AS titre_16, t0.content AS content_17, t0.date_envoi AS date_envoi_18, t0.langue AS langue_19, t0.debut_mail_coupure AS debut_mail_coupure_20, t0.fin_mail_coupure AS fin_mail_coupure_21, t0.hyperlien AS hyperlien_22, t0.signature AS signature_23, t0.signature_contenu AS signature_contenu_24, t0.client_id AS client_id_25, t0.envoye_par AS envoye_par_26, t0.reply_to AS reply_to_27, t0.pdf_id AS pdf_id_28, t0.photo_id AS photo_id_29, t0.logo_id AS logo_id_30 FROM mailling t0 WHERE t0.ancien_id = ?

Parameters:

[
  "27943"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.ancien_id AS ancien_id_2,
  t0.nom AS nom_3,
  t0.valider_envoi AS valider_envoi_4,
  t0.envoyer AS envoyer_5,
  t0.resumer AS resumer_6,
  t0.type_mail AS type_mail_7,
  t0.en_cour AS en_cour_8,
  t0.objet AS objet_9,
  t0.nb_mail_envoye AS nb_mail_envoye_10,
  t0.nb_mail AS nb_mail_11,
  t0.modification_old AS modification_old_12,
  t0.objet_cour AS objet_cour_13,
  t0.resumer_cour AS resumer_cour_14,
  t0.color AS color_15,
  t0.titre AS titre_16,
  t0.content AS content_17,
  t0.date_envoi AS date_envoi_18,
  t0.langue AS langue_19,
  t0.debut_mail_coupure AS debut_mail_coupure_20,
  t0.fin_mail_coupure AS fin_mail_coupure_21,
  t0.hyperlien AS hyperlien_22,
  t0.signature AS signature_23,
  t0.signature_contenu AS signature_contenu_24,
  t0.client_id AS client_id_25,
  t0.envoye_par AS envoye_par_26,
  t0.reply_to AS reply_to_27,
  t0.pdf_id AS pdf_id_28,
  t0.photo_id AS photo_id_29,
  t0.logo_id AS logo_id_30
FROM
  mailling t0
WHERE
  t0.ancien_id = ?

SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.valider_envoi AS valider_envoi_4, t0.envoyer AS envoyer_5, t0.resumer AS resumer_6, t0.type_mail AS type_mail_7, t0.en_cour AS en_cour_8, t0.objet AS objet_9, t0.nb_mail_envoye AS nb_mail_envoye_10, t0.nb_mail AS nb_mail_11, t0.modification_old AS modification_old_12, t0.objet_cour AS objet_cour_13, t0.resumer_cour AS resumer_cour_14, t0.color AS color_15, t0.titre AS titre_16, t0.content AS content_17, t0.date_envoi AS date_envoi_18, t0.langue AS langue_19, t0.debut_mail_coupure AS debut_mail_coupure_20, t0.fin_mail_coupure AS fin_mail_coupure_21, t0.hyperlien AS hyperlien_22, t0.signature AS signature_23, t0.signature_contenu AS signature_contenu_24, t0.client_id AS client_id_25, t0.envoye_par AS envoye_par_26, t0.reply_to AS reply_to_27, t0.pdf_id AS pdf_id_28, t0.photo_id AS photo_id_29, t0.logo_id AS logo_id_30 FROM mailling t0 WHERE t0.ancien_id = '27943';

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.

Entities Mapping

Class	Mapping errors
App\Entity\Auth\AuthToken	No errors.
App\Entity\Auth\AuthUser	No errors.
App\Entity\Mailling	The mappings App\Entity\Mailling#partiesCp and App\Entity\PartieCp#mailling are inconsistent with each other.
App\Entity\Client	The field App\Entity\Client#evenements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Evenement#client does not contain the required 'inversedBy="evenements"' attribute.
App\Entity\Pdf	No errors.
App\Entity\PhotoMailling	No errors.
App\Entity\LogoMailling	No errors.
App\Entity\PieceJointeMailling	No errors.
App\Entity\SuivitOuvertureMailling	The field App\Entity\SuivitOuvertureMailling#openDates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\OpenDate#suivitsMailling does not contain the required 'inversedBy="openDates"' attribute.
App\Entity\PartieCp	The association App\Entity\PartieCp#mailling refers to the inverse side field App\Entity\Mailling#typeMail which is not defined as association. The association App\Entity\PartieCp#mailling refers to the inverse side field App\Entity\Mailling#typeMail which does not exist.

Symfony Profiler

http://api.escalnet.escalconsulting.com/maillings/information/27943

Configuration Settings

Theme