http://api.escalnet.escalconsulting.com/logo/66405/xavier.bertrand@hautsdefrance.fr/15881/logoEscal.png

Query Metrics

6 Database Queries
6 Different statements
4.17 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 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.id = ?
Parameters:
[
  "15881"
]
2 1.59 ms
SELECT t0.id AS id_1, t0.id_contact AS id_contact_2, t0.last_open_date AS last_open_date_3, t0.nb_open AS nb_open_4, t0.nom_contact AS nom_contact_5, t0.mailling_id AS mailling_id_6 FROM suivit_ouverture_mailling t0 WHERE t0.mailling_id = ? AND t0.id_contact = ? LIMIT 1
Parameters:
[
  15881
  "66405"
]
3 0.19 ms
"START TRANSACTION"
Parameters:
[]
4 0.31 ms
INSERT INTO open_date (date, suivit_ouverture_id) VALUES (?, ?)
Parameters:
[
  1 => "2024-11-15 00:34:34"
  2 => 1892655
]
5 0.30 ms
UPDATE suivit_ouverture_mailling SET last_open_date = ?, nb_open = ? WHERE id = ?
Parameters:
[
  "2024-11-15 00:34:34"
  3
  1892655
]
6 1.15 ms
"COMMIT"
Parameters:
[]

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.
App\Entity\OpenDate No errors.
App\Entity\SuivitOuverturePartie No errors.
App\Entity\User No errors.
App\Entity\Civilite No errors.
App\Entity\Adresse No errors.
App\Entity\Logo No errors.
App\Entity\Pressroom No errors.
App\Entity\Etat
  • The association App\Entity\Etat#organisations refers to the owning side field App\Entity\Organisation#etat which does not exist.
App\Entity\Pressroom\ImagePressroom No errors.
App\Entity\Pressroom\PressroomAccueil
  • The field App\Entity\Pressroom\PressroomAccueil#pressroom is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Pressroom#pressroomAccueil does not contain the required 'inversedBy="pressroom"' attribute.
App\Entity\Pressroom\ImagePressroomContent No errors.