Query Metrics
44
Database Queries
16
Different statements
63.09 ms
Query time
0
Invalid entities
16
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.41 ms (35.53%) |
2 |
INSERT INTO tl_log (tstamp, text, source, action, username, func, browser, uri, page) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1786838406" "No passwords to send" "FE" "CRON" "N/A" "GepiBundle\Qrb\Cronjob\Runner::log" "Cronjob" "https://qcmgepi.dev.webexmachina.fr/_contao/cron" 0 ] |
|
15.02 ms (23.80%) |
3 |
"COMMIT"
Parameters:
[] |
|
10.44 ms (16.55%) |
1 |
DELETE FROM tl_log WHERE tstamp < ?
Parameters:
[
1785628806
]
|
|
5.69 ms (9.02%) |
1 |
DELETE FROM tl_undo WHERE tstamp < ?
Parameters:
[
1779062406
]
|
|
2.47 ms (3.91%) |
18 |
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"
]
|
|
2.22 ms (3.52%) |
1 |
DELETE FROM tl_version WHERE tstamp < ?
Parameters:
[
1779062406
]
|
|
1.55 ms (2.45%) |
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 <= 1786837506 AND tl_gepi_exam.notifPassword = '' ORDER BY tl_gepi_exam.start ASC
Parameters:
[] |
|
0.99 ms (1.58%) |
7 |
UPDATE tl_cron_job SET lastRun = ? WHERE id = ?
Parameters:
[ "2026-08-16 02:00:06" 1 ] |
|
0.92 ms (1.46%) |
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.60 ms (0.95%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
0.28 ms (0.44%) |
1 |
SELECT @@lock_wait_timeout
Parameters:
[] |
|
0.12 ms (0.19%) |
1 |
UNLOCK TABLES
Parameters:
[] |
|
0.12 ms (0.19%) |
1 |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
|
0.11 ms (0.17%) |
1 |
LOCK TABLES tl_cron_job WRITE, tl_cron_job AS t0 WRITE, tl_cron_job AS t0_ WRITE
Parameters:
[] |
|
0.08 ms (0.13%) |
1 |
SET SESSION lock_wait_timeout = 1
Parameters:
[] |
|
0.07 ms (0.12%) |
1 |
SET SESSION lock_wait_timeout = ?
Parameters:
[
86400
]
|
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 | 16 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Contao\CoreBundle\Entity\CronJob | No errors. |