Query Metrics
6
Database Queries
6
Different statements
4.17 ms
Query time
6
Invalid entities
Queries
#▲ | 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 |
|
App\Entity\Client |
|
App\Entity\Pdf | No errors. |
App\Entity\PhotoMailling | No errors. |
App\Entity\LogoMailling | No errors. |
App\Entity\PieceJointeMailling | No errors. |
App\Entity\SuivitOuvertureMailling |
|
App\Entity\PartieCp |
|
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 |
|
App\Entity\Pressroom\ImagePressroom | No errors. |
App\Entity\Pressroom\PressroomAccueil |
|
App\Entity\Pressroom\ImagePressroomContent | No errors. |