Query Metrics
67
Database Queries
25
Different statements
529.43 ms
Query time
0
Invalid entities
17
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
208.09 ms (39.30%) |
5 |
INSERT INTO tl_log (tstamp, text, source, action, username, func, browser, uri, page) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1793055614" "Purged the expired double opt-in tokens" "FE" "CRON" "N/A" "Contao\CoreBundle\Cron\PurgeOptInTokensCron::__invoke" "Cronjob" "https://qcmgepi.dev.webexmachina.fr/_contao/cron" 0 ] |
|
207.07 ms (39.11%) |
3 |
"COMMIT"
Parameters:
[] |
|
76.75 ms (14.50%) |
1 |
DELETE FROM tl_log WHERE tstamp < ?
Parameters:
[
1791846014
]
|
|
12.18 ms (2.30%) |
1 |
SELECT COUNT(*) AS count FROM tl_gepi_exam WHERE tl_gepi_exam.status IN('request_canceled','request_locked','exam_upcoming','exam_inprogress','exam_over_training_center','exam_over_gepi','exam_over_edf','exam_completed','exam_archived') AND 0 = ( SELECT COUNT(*) FROM tl_gepi_exam_instance tgei2 WHERE tgei2.pid = tl_gepi_exam.id )
Parameters:
[] |
|
4.53 ms (0.86%) |
19 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Contao\CoreBundle\Cron\Cron::updateMinutelyCliCron"
]
|
|
3.26 ms (0.62%) |
1 |
SELECT * FROM tl_member WHERE disable=1 AND EXISTS (SELECT * FROM tl_opt_in_related r LEFT JOIN tl_opt_in o ON r.pid=o.id WHERE r.relTable='tl_member' AND r.relId=tl_member.id AND o.createdOn<=? AND o.confirmedOn=0 AND o.token LIKE 'reg-%')
Parameters:
[
1792969214
]
|
|
2.35 ms (0.44%) |
16 |
UPDATE tl_cron_job SET lastRun = ? WHERE id = ?
Parameters:
[ "2026-10-27 00:00:13" 1 ] |
|
2.31 ms (0.44%) |
1 |
SELECT * FROM tl_newsletter_recipients WHERE active=0 AND EXISTS (SELECT * FROM tl_opt_in_related r LEFT JOIN tl_opt_in o ON r.pid=o.id WHERE r.relTable='tl_newsletter_recipients' AND r.relId=tl_newsletter_recipients.id AND o.createdOn<=? AND o.confirmedOn=0 AND o.token LIKE 'nl-%')
Parameters:
[
1792969214
]
|
|
2.14 ms (0.40%) |
1 |
SELECT * FROM tl_opt_in WHERE tl_opt_in.removeOn>0 AND tl_opt_in.removeOn<?
Parameters:
[
1793055614
]
|
|
1.83 ms (0.35%) |
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.status IN('exam_upcoming') AND tl_gepi_exam.examDate <= 1793054714 AND tl_gepi_exam.notifPassword = '' ORDER BY tl_gepi_exam.start ASC
Parameters:
[] |
|
1.15 ms (0.22%) |
1 |
SELECT * FROM tl_comments_notify WHERE active=0 AND EXISTS (SELECT * FROM tl_opt_in_related r LEFT JOIN tl_opt_in o ON r.pid=o.id WHERE r.relTable='tl_comments_notify' AND r.relId=tl_comments_notify.id AND o.createdOn<=? AND o.confirmedOn=0 AND o.token LIKE 'com-%')
Parameters:
[
1792969214
]
|
|
1.04 ms (0.20%) |
1 |
SELECT * FROM `tl_nc_bulky_items` WHERE path LIKE ? AND path NOT LIKE ? ORDER BY path
Parameters:
[ "%" "%/%" ] |
|
1.04 ms (0.20%) |
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.status IN('exam_completed','exam_archived') AND tl_gepi_exam.hideForCompany = '' AND tl_gepi_exam.notifExamAvailableForCompany = '' ORDER BY tl_gepi_exam.start ASC
Parameters:
[] |
|
0.94 ms (0.18%) |
2 |
SELECT tl_calendar_feed.* FROM tl_calendar_feed
Parameters:
[] |
|
0.74 ms (0.14%) |
1 |
LOCK TABLES tl_cron_job WRITE, tl_cron_job AS t0 WRITE, tl_cron_job AS t0_ WRITE
Parameters:
[] |
|
0.74 ms (0.14%) |
1 |
DELETE FROM tl_preview_link WHERE expiresAt <= UNIX_TIMESTAMP()
Parameters:
[] |
|
0.73 ms (0.14%) |
1 |
DELETE FROM tl_undo WHERE tstamp < ?
Parameters:
[
1785279613
]
|
|
0.66 ms (0.12%) |
1 |
DELETE FROM tl_cron_job WHERE lastRun < ? AND name NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2025-09-27 00:00:13" "Contao\CoreBundle\Cron\Cron::updateMinutelyCliCron" "contao.cron.supervise_workers" "contao.cron.purge_expired_data::onHourly" "contao.cron.purge_opt_in_tokens" "contao.cron.purge_preview_links" "contao.cron.purge_registrations" "contao.cron.purge_temp_folder" "Terminal42\NotificationCenterBundle\Cron\PruneBulkyItemStorageCron" "contao_calendar.cron.generate_feeds" "contao_newsletter.cron.purge_subscriptions" "GepiBundle\Qrb\Cronjob\Exam\DeleteExamsWithoutCandidates" "GepiBundle\Qrb\Cronjob\Exam\LockExamRequests" "GepiBundle\Qrb\Cronjob\Exam\SendExamPassword" "GepiBundle\Qrb\Cronjob\Exam\SendExamWhenAvailableForCompany" "GepiBundle\Qrb\Cronjob\Member\DeleteOperatorsWithoutExam" "GepiBundle\Qrb\Cronjob\Session\SendNewSessions" "contao_comments.cron.purge_subscriptions" ] |
|
0.58 ms (0.11%) |
1 |
DELETE FROM tl_version WHERE tstamp < ?
Parameters:
[
1785279614
]
|
|
0.37 ms (0.07%) |
1 |
SELECT @@lock_wait_timeout
Parameters:
[] |
|
0.32 ms (0.06%) |
1 |
SET SESSION lock_wait_timeout = ?
Parameters:
[
86400
]
|
|
0.27 ms (0.05%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
0.12 ms (0.02%) |
1 |
SET SESSION lock_wait_timeout = 1
Parameters:
[] |
|
0.12 ms (0.02%) |
1 |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
|
0.09 ms (0.02%) |
1 |
UNLOCK TABLES
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 |
|---|---|
| Contao\CoreBundle\Entity\CronJob | 17 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Contao\CoreBundle\Entity\CronJob | No errors. |