Symfony Profiler

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  @@lock_wait_timeout

SELECT @@lock_wait_timeout;

SET
  SESSION lock_wait_timeout = 1

SET SESSION lock_wait_timeout = 1;

LOCK TABLES tl_cron_job WRITE,
tl_cron_job AS t0 WRITE,
tl_cron_job AS t0_ WRITE

LOCK TABLES tl_cron_job WRITE, tl_cron_job AS t0 WRITE, tl_cron_job AS t0_ WRITE;

SET
  SESSION lock_wait_timeout = ?

SET SESSION lock_wait_timeout = 86400;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'Contao\\CoreBundle\\Cron\\Cron::updateMinutelyCliCron' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao.cron.supervise_workers' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao.cron.purge_expired_data::onHourly' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao.cron.purge_opt_in_tokens' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao.cron.purge_preview_links' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao.cron.purge_registrations' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao.cron.purge_temp_folder' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'Terminal42\\NotificationCenterBundle\\Cron\\PruneBulkyItemStorageCron' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao_calendar.cron.generate_feeds' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao_newsletter.cron.purge_subscriptions' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'GepiBundle\\Qrb\\Cronjob\\Exam\\DeleteExamsWithoutCandidates' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'GepiBundle\\Qrb\\Cronjob\\Exam\\LockExamRequests' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'GepiBundle\\Qrb\\Cronjob\\Exam\\SendExamPassword' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'GepiBundle\\Qrb\\Cronjob\\Exam\\SendExamWhenAvailableForCompany' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'GepiBundle\\Qrb\\Cronjob\\Session\\SendNewSessions' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao_comments.cron.purge_subscriptions' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  tl_cron_job
SET
  lastRun = ?
WHERE
  id = ?

UPDATE tl_cron_job SET lastRun = '2026-08-16 15:50:05' WHERE id = 1;

UPDATE
  tl_cron_job
SET
  lastRun = ?
WHERE
  id = ?

UPDATE tl_cron_job SET lastRun = '2026-08-16 15:50:05' WHERE id = 2;

UPDATE
  tl_cron_job
SET
  lastRun = ?
WHERE
  id = ?

UPDATE tl_cron_job SET lastRun = '2026-08-16 15:50:05' WHERE id = 16;

"COMMIT"

"COMMIT";

UNLOCK TABLES

UNLOCK TABLES;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'Contao\\CoreBundle\\Cron\\Cron::updateMinutelyCliCron' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  tl_cron_job
SET
  lastRun = ?
WHERE
  id = ?

UPDATE tl_cron_job SET lastRun = '2026-07-31 14:48:51' WHERE id = 1;

"COMMIT"

"COMMIT";

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastRun AS lastRun_3 FROM tl_cron_job t0 WHERE t0.name = 'contao.cron.supervise_workers' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  tl_cron_job
SET
  lastRun = ?
WHERE
  id = ?

UPDATE tl_cron_job SET lastRun = '2026-07-31 14:48:51' WHERE id = 2;

"COMMIT"

"COMMIT";

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 <= 1786887305
  AND tl_gepi_exam.notifPassword = ''
ORDER BY
  tl_gepi_exam.start ASC

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 <= 1786887305 AND tl_gepi_exam.notifPassword = '' ORDER BY tl_gepi_exam.start ASC;

INSERT INTO tl_log (
  tstamp, text, source, action, username,
  func, browser, uri, page
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO tl_log (tstamp, text, source, action, username, func, browser, uri, page) VALUES ('1786888205', 'No passwords to send', 'FE', 'CRON', 'N/A', 'GepiBundle\\Qrb\\Cronjob\\Runner::log', 'Cronjob', 'https://qcmgepi.dev.webexmachina.fr/_contao/cron', 0);