Query Metrics
39
Database Queries
35
Different statements
38.33 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
17.05 ms (44.49%) |
1 |
SELECT c.TABLE_NAME, c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = '9h6wj_qcmgepi_v2' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION
Parameters:
[ "9h6wj_qcmgepi_v2" "9h6wj_qcmgepi_v2" ] |
|
3.97 ms (10.36%) |
2 |
UPDATE tl_gepi_exam_instance SET `id`=?, `mci`=?, `ac`=?, `acComments`=?, `txp`=?, `at`=?, `qcm_ediedf`=?, `qcm_beton`=?, `qcm_metal`=?, `qcm_peinture`=?, `qcm_joints`=?, `qcm_stratifie`=?, `qcm_final`=?, `note`=?, `synthese`=? WHERE `id`=?
Parameters:
[ "3078" "12" "12" "" "20" "10" "0" "0" "0" "0" "0" "0" "0" "68.00" "13.60" 3078 ] |
|
2.62 ms (6.83%) |
1 |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
"9h6wj_qcmgepi_v2"
]
|
|
2.17 ms (5.66%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.63 ms (4.25%) |
1 |
UPDATE tl_gepi_exam SET `status`=?, `tstamp`=? WHERE `id`=?
Parameters:
[ "exam_over_gepi" 1793034861 868 ] |
|
1.21 ms (3.15%) |
1 |
SELECT TABLE_NAME, NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
"9h6wj_qcmgepi_v2"
]
|
|
1.09 ms (2.86%) |
2 |
SELECT tl_gepi_exam_instance.*, j1.`id` AS pid__id, j1.`createdAt` AS pid__createdAt, j1.`tstamp` AS pid__tstamp, j1.`status` AS pid__status, j1.`hideForCompany` AS pid__hideForCompany, j1.`locked` AS pid__locked, j1.`lockedAt` AS pid__lockedAt, j1.`company` AS pid__company, j1.`companyName` AS pid__companyName, j1.`companyStreet` AS pid__companyStreet, j1.`companyPostal` AS pid__companyPostal, j1.`companyCity` AS pid__companyCity, j1.`companyCountry` AS pid__companyCountry, j1.`contactName` AS pid__contactName, j1.`contactEmail` AS pid__contactEmail, j1.`centerName` AS pid__centerName, j1.`examDate` AS pid__examDate, j1.`examLocation` AS pid__examLocation, j1.`session` AS pid__session, j1.`requestCertificateLevel` AS pid__requestCertificateLevel, j1.`requestCertificateName` AS pid__requestCertificateName, j1.`isEquivalence` AS pid__isEquivalence, j1.`examAssociated` AS pid__examAssociated, j1.`start` AS pid__start, j1.`stop` AS pid__stop, j1.`qcm` AS pid__qcm, j1.`nbQuestions` AS pid__nbQuestions, j1.`password` AS pid__password, j1.`notifPassword` AS pid__notifPassword, j1.`notifExamAvailableForCompany` AS pid__notifExamAvailableForCompany, j2.`id` AS candidate__id, j2.`tstamp` AS candidate__tstamp, j2.`firstname` AS candidate__firstname, j2.`lastname` AS candidate__lastname, j2.`dateOfBirth` AS candidate__dateOfBirth, j2.`gender` AS candidate__gender, j2.`company` AS candidate__company, j2.`street` AS candidate__street, j2.`postal` AS candidate__postal, j2.`city` AS candidate__city, j2.`state` AS candidate__state, j2.`country` AS candidate__country, j2.`phone` AS candidate__phone, j2.`mobile` AS candidate__mobile, j2.`fax` AS candidate__fax, j2.`email` AS candidate__email, j2.`website` AS candidate__website, j2.`language` AS candidate__language, j2.`groups` AS candidate__groups, j2.`login` AS candidate__login, j2.`username` AS candidate__username, j2.`password` AS candidate__password, j2.`assignDir` AS candidate__assignDir, j2.`homeDir` AS candidate__homeDir, j2.`disable` AS candidate__disable, j2.`start` AS candidate__start, j2.`stop` AS candidate__stop, j2.`dateAdded` AS candidate__dateAdded, j2.`lastLogin` AS candidate__lastLogin, j2.`currentLogin` AS candidate__currentLogin, j2.`session` AS candidate__session, j2.`secret` AS candidate__secret, j2.`useTwoFactor` AS candidate__useTwoFactor, j2.`backupCodes` AS candidate__backupCodes, j2.`trustedTokenVersion` AS candidate__trustedTokenVersion, j2.`newsletter` AS candidate__newsletter, j2.`socialSecurityNumber` AS candidate__socialSecurityNumber, j2.`seniority` AS candidate__seniority, j2.`identityPicture` AS candidate__identityPicture FROM tl_gepi_exam_instance LEFT JOIN tl_gepi_exam j1 ON tl_gepi_exam_instance.`pid`=j1.id LEFT JOIN tl_member j2 ON tl_gepi_exam_instance.`candidate`=j2.id WHERE tl_gepi_exam_instance.`id`=? LIMIT 0,1
Parameters:
[
"3078"
]
|
|
0.80 ms (2.07%) |
1 |
SELECT DISTINCT k.TABLE_NAME, k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = '9h6wj_qcmgepi_v2' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
"9h6wj_qcmgepi_v2"
]
|
|
0.56 ms (1.47%) |
1 |
SHOW FULL COLUMNS FROM tl_gepi_exam_instance
Parameters:
[] |
|
0.55 ms (1.43%) |
1 |
INSERT INTO tl_message_queue (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
"""
O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:51:\"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\":2:{s:60:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0message\";O:28:\"Symfony\\Component\\Mime\\Email\":6:{i:0;s:679:\"[GEPI](https://qcmgepi.dev.webexmachina.fr/)\n
\n
Bonjour,\n
\n
L’examen suivant a été corrigé, nous vous remercions de bien vouloir procéder à sa validation.\n
\n
Centre\tVille\tDate d\'examen\tCertification\tEntreprise\n
SIXENSE\tDERNIER??\t26/10/2026\tQRB1 (Sans option)\tMASCI\n
\n
Il concerne les candidats suivants :\n
\n
Nom\tPrénom\tIdentifiant\n
Premier\tMasci\t2026/2054\n
HEUZE\tDavid\t2016/753\n
\n
L’examen est disponible sur votre espace QRB : https://qcmgepi.dev.webexmachina.fr/valider-examens/868\n
\n
Nous restons à votre disposition pour tout commentaire concernant cet examen.\n
Cordialement,\n
Le GEPI\n
\n
Merci de ne pas répondre à ce message, il a été envoyé à partir d’une boîte automatique.\";i:1;s:5:\"utf-8\";i:2;s:7306:\"\n
<!-- TEMPLATE START: templates/mail_service.html5 -->\n
<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 3.2//EN\">\r\n
<html>\r\n
<head>\r\n
<title>Examen à corriger | GEPI</title>\r\n
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n
<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n
<style type=\"text/css\">\r\n
/* Fonts and Content */\r\n
body, td { font-family: Arial, Helvetica, Geneva, sans-serif; font-size:12px;}\r\n
table {background-color: #ffffff;}\r\n
tr,td{ max-width: 100%;}\r\n
body { background-color: #f0f0f0; margin: 0; padding: 0; -webkit-text-size-adjust:none; -ms-text-size-adjust:none; color:#555656;}\r\n
h1{ color:#2591cd; font-size:18px; font-weight: bold;}\r\n
h2{ color:#2591cd; font-size:14px; font-weight: bold;}\r\n
a,\r\n
img{outline: none !important; border-style: none ;}\r\n
.container{width: 100%; max-width: 996px; margin: auto; padding: 0 15px; }\r\n
.btn{background-color:#2591cd;color:#ffffff;padding:10px 16px;text-decoration:none;display:inline-block;border-radius:5px;margin-bottom:15px;}\r\n
\r\n
@media only screen and (max-width: 1200px) { /* MEDIA LG */\r\n
.container{width: 1170px;}\r\n
}\r\n
\r\n
@media only screen and (max-width: 992px) { /* MEDIA MD */\r\n
.container{width: 970px;}\r\n
}\r\n
\r\n
@media only screen and (max-width: 768px) { /* MEDIA SM */\r\n
tbody,\r\n
table {width: 100% !important;}\r\n
.container{width: 750px;}\r\n
td.account,\r\n
td.socials{display: block; width: 100%; text-align: center; padding: 10px 0;}\r\n
td.socials>*{text-align: center;}\r\n
td.socials table{width: auto !important; margin: auto;}\r\n
}\r\n
\r\n
@media only screen and (max-width: 620px) {\r\n
.container{width: 100%;}\r\n
tbody,\r\n
table {width: 100% !important;}\r\n
}\r\n
\r\n
@media only screen and (max-width: 520px) {\r\n
.container{width: 100%;}\r\n
tbody,\r\n
table {width: 100% !important;}\r\n
}\r\n
\r\n
@media only screen and (max-width: 420px) {\r\n
.container{width: 100%;}\r\n
tbody,\r\n
table {width: 100% !important;}\r\n
}\r\n
\r\n
</style>\r\n
</head>\r\n
<body style=\"margin: 0px; padding: 0px;\">\r\n
<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"background-color:#e5e5e5\">\r\n
<tbody>\r\n
<tr>\r\n
<td align=\"center\" bgcolor=\"#e5e5e5\">\r\n
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n
<tbody>\r\n
<tr>\r\n
<td>\r\n
<table width=\"640\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n
<tbody>\r\n
<tr class=\"pagetoplogo\">\r\n
<td width=\"640\">\r\n
<table width=\"640\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" bgcolor=\"#ffffff\">\r\n
<tbody>\r\n
<tr class=\"separator-y\"> <td width=\"640\" height=\"15\" bgcolor=\"#ffffff\"></td> </tr>\r\n
<tr>\r\n
<td width=\"100%\" height=\"100\" valign=\"middle\" align=\"center\">\r\n
<div class=\"pagetoplogo-content\">\r\n
<a href=\"https://qcmgepi.dev.webexmachina.fr/\" title=\"GEPI\" style=\"text-align: center;\">\r\n
<img style=\"text-decoration:none;text-align:center;color:#555656;font-size:24px;\" src=\"https://qcmgepi.dev.webexmachina.fr/files/gepi/images/logo-qrb.png\" alt=\"Logo GEPI - QRB\" height=\"100\">\r\n
</a>\r\n
</div>\r\n
</td>\r\n
</tr>\r\n
<tr class=\"separator-y\"> <td width=\"640\" height=\"15\" bgcolor=\"#ffffff\"></td> </tr>\r\n
<tr>\r\n
<td class=\"separator-x\" bgcolor=\"#d3d3d3\" height=\"1\"></td>\r\n
</tr>\r\n
</tbody>\r\n
</table>\r\n
</td>\r\n
</tr>\r\n
<tr class=\"separator-y\"> <td width=\"640\" height=\"15\" bgcolor=\"#ffffff\"></td> </tr>\r\n
<!-- contenu -->\r\n
<tr class=\"content\">\r\n
<td width=\"640\" bgcolor=\"#ffffff\">\r\n
<table width=\"640\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n
<tbody>\r\n
<tr>\r\n
<td class=\"separator-x\" bgcolor=\"#ffffff\" width=\"30\"></td>\r\n
<td>\r\n
<p>Bonjour,</p>\n
<p>L’examen suivant a été corrigé, nous vous remercions de bien vouloir procéder à sa validation.</p>\n
<p>\n
<style>table.table{ border-collapse: collapse; text-align: left; }table.table td, table.table th {border: 1px solid #c5c5c5; padding: 0.45em 0.75em; } </style>\n
<table class=\"table\">\n
<tr><th>Centre</th><th>Ville</th><th>Date d\'examen</th><th>Certification</th><th>Entreprise</th></tr>\n
<tr><td>SIXENSE</td><td>DERNIER??</td><td>26/10/2026</td><td>QRB1 (Sans option)</td><td>MASCI</td></tr>\n
</table></p>\n
<p>Il concerne les candidats suivants :</p>\n
<p>\n
<style>table.table{ border-collapse: collapse; text-align: left; }table.table td, table.table th {border: 1px solid #c5c5c5; padding: 0.45em 0.75em; } </style>\n
<table class=\"table\">\n
<tr><th>Nom</th><th>Prénom</th><th>Identifiant</th></tr>\n
<tr><td>Premier</td><td>Masci </td><td>2026/2054</td></tr><tr><td>HEUZE</td><td>David</td><td>2016/753</td></tr>\n
</table></p>\n
<p>L’examen est disponible sur votre espace QRB : <a href=\"https://qcmgepi.dev.webexmachina.fr/valider-examens/868\">https://qcmgepi.dev.webexmachina.fr/valider-examens/868</a></p>\n
<p>Nous restons à votre disposition pour tout commentaire concernant cet examen.<br>Cordialement, <br>Le GEPI</p> </td>\r\n
<td class=\"separator-x\" bgcolor=\"#ffffff\" width=\"30\"></td>\r\n
</tr>\r\n
</tbody>\r\n
</table>\r\n
</td>\r\n
</tr>\r\n
<tr class=\"separator-y\">\r\n
<td width=\"640\" height=\"30\" bgcolor=\"#ffffff\"></td>\r\n
</tr>\r\n
<tr class=\"separator-y\"> <td width=\"640\" height=\"15\" bgcolor=\"#2591cd\"></td> </tr>\r\n
<tr>\r\n
<td width=\"640\" valign=\"middle\" align=\"center\" bgcolor=\"#2591cd\" >\r\n
<p style=\"font-size:10px;max-width:450px; padding: 0 15px; color: #fff;\">Merci de ne pas répondre à ce message, il a été envoyé à partir d’une boîte automatique.</p>\r\n
</td>\r\n
</tr>\r\n
<tr class=\"separator-y\"> <td width=\"640\" height=\"15\" bgcolor=\"#2591cd\"></td> </tr>\r\n
</tbody>\r\n
</table>\r\n
</td>\r\n
</tr>\r\n
</tbody>\r\n
</table>\r\n
</td>\r\n
</tr>\r\n
</tbody>\r\n
</table>\r\n
</body>\r\n
</html>\n
<!-- TEMPLATE END: templates/mail_service.html5 -->\n
\";i:3;s:5:\"utf-8\";i:4;a:0:{}i:5;a:2:{i:0;O:37:\"Symfony\\Component\\Mime\\Header\\Headers\":2:{s:46:\"\0Symfony\\Component\\Mime\\Header\\Headers\0headers\";a:7:{s:4:\"from\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:4:\"From\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:15:\"contact@gepi.fr\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:21:\"Plateforme QCM | GEPI\";}}}}s:2:\"to\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:2:\"To\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:15:\"contact@gepi.fr\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:7:\"subject\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:7:\"Subject\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:25:\"Examen à corriger | GEPI\";}}s:10:\"x-priority\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:10:\"X-Priority\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:10:\"3 (Normal)\";}}s:11:\"x-transport\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:11:\"X-Transport\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:11:\"mailjetsmtp\";}}s:29:\"notification-center-parcel-id\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:29:\"Notification-Center-Parcel-ID\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:64:\"84e939222ffc741f7bce93eb07f0f88eb4b2d70253e37ca64561a7c22818dc64\";}}s:50:\"notification-center-bulky-item-storage-attachments\";a:1:{i:0;O:84:\"Terminal42\\NotificationCenterBundle\\Gateway\\Mailer\\BulkyItemStorageAttachmentsHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:50:\"Notification-Center-Bulky-Item-Storage-Attachments\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:101:\"\0Terminal42\\NotificationCenterBundle\\Gateway\\Mailer\\BulkyItemStorageAttachmentsHeader\0attachmentItems\";a:0:{}}}}s:49:\"\0Symfony\\Component\\Mime\\Header\\Headers\0lineLength\";i:76;}i:1;N;}}s:61:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0envelope\";N;}}
"""
"[]"
"prio_high"
"2026-10-26 17:14:21"
"2026-10-26 17:14:21"
]
|
|
0.52 ms (1.36%) |
1 |
SELECT * FROM tl_member WHERE `username`=? LIMIT 0,1
Parameters:
[
"CAMBRIL"
]
|
|
0.51 ms (1.34%) |
1 |
SHOW FULL COLUMNS FROM tl_gepi_exam
Parameters:
[] |
|
0.51 ms (1.34%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published=1 AND (tl_page.start='' OR tl_page.start<=1793034840) AND (tl_page.stop='' OR tl_page.stop>1793034840) LIMIT 0,1
Parameters:
[
31
]
|
|
0.50 ms (1.30%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.47 ms (1.22%) |
1 |
SELECT tl_gepi_exam_instance.*, j1.`id` AS pid__id, j1.`createdAt` AS pid__createdAt, j1.`tstamp` AS pid__tstamp, j1.`status` AS pid__status, j1.`hideForCompany` AS pid__hideForCompany, j1.`locked` AS pid__locked, j1.`lockedAt` AS pid__lockedAt, j1.`company` AS pid__company, j1.`companyName` AS pid__companyName, j1.`companyStreet` AS pid__companyStreet, j1.`companyPostal` AS pid__companyPostal, j1.`companyCity` AS pid__companyCity, j1.`companyCountry` AS pid__companyCountry, j1.`contactName` AS pid__contactName, j1.`contactEmail` AS pid__contactEmail, j1.`centerName` AS pid__centerName, j1.`examDate` AS pid__examDate, j1.`examLocation` AS pid__examLocation, j1.`session` AS pid__session, j1.`requestCertificateLevel` AS pid__requestCertificateLevel, j1.`requestCertificateName` AS pid__requestCertificateName, j1.`isEquivalence` AS pid__isEquivalence, j1.`examAssociated` AS pid__examAssociated, j1.`start` AS pid__start, j1.`stop` AS pid__stop, j1.`qcm` AS pid__qcm, j1.`nbQuestions` AS pid__nbQuestions, j1.`password` AS pid__password, j1.`notifPassword` AS pid__notifPassword, j1.`notifExamAvailableForCompany` AS pid__notifExamAvailableForCompany, j2.`id` AS candidate__id, j2.`tstamp` AS candidate__tstamp, j2.`firstname` AS candidate__firstname, j2.`lastname` AS candidate__lastname, j2.`dateOfBirth` AS candidate__dateOfBirth, j2.`gender` AS candidate__gender, j2.`company` AS candidate__company, j2.`street` AS candidate__street, j2.`postal` AS candidate__postal, j2.`city` AS candidate__city, j2.`state` AS candidate__state, j2.`country` AS candidate__country, j2.`phone` AS candidate__phone, j2.`mobile` AS candidate__mobile, j2.`fax` AS candidate__fax, j2.`email` AS candidate__email, j2.`website` AS candidate__website, j2.`language` AS candidate__language, j2.`groups` AS candidate__groups, j2.`login` AS candidate__login, j2.`username` AS candidate__username, j2.`password` AS candidate__password, j2.`assignDir` AS candidate__assignDir, j2.`homeDir` AS candidate__homeDir, j2.`disable` AS candidate__disable, j2.`start` AS candidate__start, j2.`stop` AS candidate__stop, j2.`dateAdded` AS candidate__dateAdded, j2.`lastLogin` AS candidate__lastLogin, j2.`currentLogin` AS candidate__currentLogin, j2.`session` AS candidate__session, j2.`secret` AS candidate__secret, j2.`useTwoFactor` AS candidate__useTwoFactor, j2.`backupCodes` AS candidate__backupCodes, j2.`trustedTokenVersion` AS candidate__trustedTokenVersion, j2.`newsletter` AS candidate__newsletter, j2.`socialSecurityNumber` AS candidate__socialSecurityNumber, j2.`seniority` AS candidate__seniority, j2.`identityPicture` AS candidate__identityPicture FROM tl_gepi_exam_instance LEFT JOIN tl_gepi_exam j1 ON tl_gepi_exam_instance.`pid`=j1.id LEFT JOIN tl_member j2 ON tl_gepi_exam_instance.`candidate`=j2.id WHERE tl_gepi_exam_instance.pid = 868 ORDER BY tl_gepi_exam_instance.tstamp ASC
Parameters:
[] |
|
0.43 ms (1.13%) |
1 |
SELECT tl_member_group.* FROM tl_member_group WHERE tl_member_group.disable=0 AND (tl_member_group.start='' OR tl_member_group.start<=1793034840) AND (tl_member_group.stop='' OR tl_member_group.stop>1793034840)
Parameters:
[] |
|
0.39 ms (1.03%) |
1 |
UPDATE tl_member SET session = ? WHERE id = ?
Parameters:
[ "a:1:{s:7:"referer";a:2:{s:4:"last";s:25:"examens-archives/741.html";s:7:"current";s:25:"examens-archives/741.html";}}" 1388 ] |
|
0.36 ms (0.95%) |
1 |
SELECT * FROM tl_nc_message WHERE pid = ? ORDER BY sorting ASC
Parameters:
[
8
]
|
|
0.31 ms (0.81%) |
1 |
SELECT * FROM tl_nc_language WHERE (pid = ?) AND (language = ? OR language = ? OR fallback = ?) ORDER BY LENGTH(language) DESC, fallback ASC
Parameters:
[ 10 "fr" "fr" true ] |
|
0.28 ms (0.74%) |
1 |
SELECT tl_gepi_exam.*, j1.`id` AS company__id, j1.`tstamp` AS company__tstamp, j1.`firstname` AS company__firstname, j1.`lastname` AS company__lastname, j1.`dateOfBirth` AS company__dateOfBirth, j1.`gender` AS company__gender, j1.`company` AS company__company, j1.`street` AS company__street, j1.`postal` AS company__postal, j1.`city` AS company__city, j1.`state` AS company__state, j1.`country` AS company__country, j1.`phone` AS company__phone, j1.`mobile` AS company__mobile, j1.`fax` AS company__fax, j1.`email` AS company__email, j1.`website` AS company__website, j1.`language` AS company__language, j1.`groups` AS company__groups, j1.`login` AS company__login, j1.`username` AS company__username, j1.`password` AS company__password, j1.`assignDir` AS company__assignDir, j1.`homeDir` AS company__homeDir, j1.`disable` AS company__disable, j1.`start` AS company__start, j1.`stop` AS company__stop, j1.`dateAdded` AS company__dateAdded, j1.`lastLogin` AS company__lastLogin, j1.`currentLogin` AS company__currentLogin, j1.`session` AS company__session, j1.`secret` AS company__secret, j1.`useTwoFactor` AS company__useTwoFactor, j1.`backupCodes` AS company__backupCodes, j1.`trustedTokenVersion` AS company__trustedTokenVersion, j1.`newsletter` AS company__newsletter, j1.`socialSecurityNumber` AS company__socialSecurityNumber, j1.`seniority` AS company__seniority, j1.`identityPicture` AS company__identityPicture, j2.`id` AS session__id, j2.`created_at` AS session__created_at, j2.`tstamp` AS session__tstamp, j2.`trainingCenter` AS session__trainingCenter, j2.`contactEmail` AS session__contactEmail, j2.`date` AS session__date, j2.`city` AS session__city, j2.`requestCertificateLevel` AS session__requestCertificateLevel, j2.`requestCertificateName` AS session__requestCertificateName, j2.`companies` AS session__companies, j2.`placesMax` AS session__placesMax, j2.`notificationDate` AS session__notificationDate, j2.`closed` AS session__closed, j3.`id` AS examAssociated__id, j3.`createdAt` AS examAssociated__createdAt, j3.`tstamp` AS examAssociated__tstamp, j3.`status` AS examAssociated__status, j3.`hideForCompany` AS examAssociated__hideForCompany, j3.`locked` AS examAssociated__locked, j3.`lockedAt` AS examAssociated__lockedAt, j3.`company` AS examAssociated__company, j3.`companyName` AS examAssociated__companyName, j3.`companyStreet` AS examAssociated__companyStreet, j3.`companyPostal` AS examAssociated__companyPostal, j3.`companyCity` AS examAssociated__companyCity, j3.`companyCountry` AS examAssociated__companyCountry, j3.`contactName` AS examAssociated__contactName, j3.`contactEmail` AS examAssociated__contactEmail, j3.`centerName` AS examAssociated__centerName, j3.`examDate` AS examAssociated__examDate, j3.`examLocation` AS examAssociated__examLocation, j3.`session` AS examAssociated__session, j3.`requestCertificateLevel` AS examAssociated__requestCertificateLevel, j3.`requestCertificateName` AS examAssociated__requestCertificateName, j3.`isEquivalence` AS examAssociated__isEquivalence, j3.`examAssociated` AS examAssociated__examAssociated, j3.`start` AS examAssociated__start, j3.`stop` AS examAssociated__stop, j3.`qcm` AS examAssociated__qcm, j3.`nbQuestions` AS examAssociated__nbQuestions, j3.`password` AS examAssociated__password, j3.`notifPassword` AS examAssociated__notifPassword, j3.`notifExamAvailableForCompany` AS examAssociated__notifExamAvailableForCompany, j4.`id` AS qcm__id, j4.`created_at` AS qcm__created_at, j4.`tstamp` AS qcm__tstamp, j4.`title` AS qcm__title, j4.`sections` AS qcm__sections FROM tl_gepi_exam LEFT JOIN tl_member j1 ON tl_gepi_exam.`company`=j1.id LEFT JOIN tl_gepi_session j2 ON tl_gepi_exam.`session`=j2.id LEFT JOIN tl_gepi_exam j3 ON tl_gepi_exam.`examAssociated`=j3.id LEFT JOIN tl_gepi_qcm j4 ON tl_gepi_exam.`qcm`=j4.id WHERE tl_gepi_exam.`id`=? LIMIT 0,1
Parameters:
[
"868"
]
|
|
0.25 ms (0.66%) |
1 |
SELECT tl_member_group.* FROM tl_member_group WHERE tl_member_group.id=? AND tl_member_group.disable=0 AND (tl_member_group.start='' OR tl_member_group.start<=1793034840) AND (tl_member_group.stop='' OR tl_member_group.stop>1793034840) LIMIT 0,1
Parameters:
[
"7"
]
|
|
0.21 ms (0.56%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.21 ms (0.55%) |
1 |
SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns=? OR tl_page.dns=''))
Parameters:
[
"qcmgepi.dev.webexmachina.fr"
]
|
|
0.21 ms (0.54%) |
1 |
SELECT COUNT(*) AS count FROM tl_gepi_exam_instance WHERE tl_gepi_exam_instance.pid = 868
Parameters:
[] |
|
0.20 ms (0.52%) |
1 |
SELECT * FROM tl_nc_notification WHERE id = ?
Parameters:
[
8
]
|
|
0.17 ms (0.45%) |
1 |
SELECT tl_member.* FROM tl_member WHERE tl_member.`id`=? LIMIT 0,1
Parameters:
[
228
]
|
|
0.17 ms (0.44%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
"599966c4c3b211f19c42fa163e4448a0"
]
|
|
0.17 ms (0.44%) |
1 |
SELECT * FROM tl_nc_gateway WHERE id = ?
Parameters:
[
1
]
|
|
0.16 ms (0.43%) |
1 |
SHOW INDEXES FROM `tl_gepi_exam_instance`
Parameters:
[] |
|
0.16 ms (0.42%) |
1 |
SHOW INDEXES FROM `tl_gepi_exam`
Parameters:
[] |
|
0.15 ms (0.40%) |
1 |
SELECT ncn.id as `id` FROM tl_nc_notification ncn WHERE ncn.type = ?
Parameters:
[
"gepi_new_exam_to_check"
]
|
|
0.10 ms (0.26%) |
1 |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
|
0.09 ms (0.24%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias=? OR tl_page.alias=?
Parameters:
[ "index" "/" ] |
|
0.07 ms (0.17%) |
1 |
SELECT COUNT(*) AS count FROM tl_gepi_exam_instance_answer WHERE tl_gepi_exam_instance_answer.pid = 3078 AND tl_gepi_exam_instance_answer.answer != 'NULL'
Parameters:
[] |
|
0.05 ms (0.14%) |
1 |
SELECT COUNT(*) AS count FROM tl_gepi_exam_instance_answer WHERE tl_gepi_exam_instance_answer.pid = 3079 AND tl_gepi_exam_instance_answer.answer != 'NULL'
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.