Query counter : 1 : execution time : 0.0022µs: affected rows :4
SELECT `m`.`label` AS `label`
FROM `conbcdc_clar239`.`cl_module` AS `m`
LEFT JOIN `conbcdc_clar239`.`cl_module_contexts` AS `mc`
ON `mc`.`module_id` = `m`.`id`
WHERE `mc`.`context` = 'group' AND `m`.`type` = 'tool' AND `m`.`activation` = 'activated'
Query counter : 2 : execution time : <0.001µs: affected rows :4
SELECT profile_id, name, label, description
FROM `conbcdc_clar239`.`cl_right_profile`
ORDER BY profile_id
Query counter : 3 : execution time : 0.0027µs: affected rows :1
INSERT INTO `conbcdc_clar239`.`cl_log`
SET `course_code` = NULL,
`tool_id` = NULL,
`user_id` = NULL,
`ip` = '3.238.24.209',
`date` = '2022-07-01 23:33:55',
`type` = 'debug',
`data` = 's:36:\"EventManager::notify platform_access\";'
Query counter : 4 : execution time : <0.001µs: affected rows :1
INSERT INTO `conbcdc_clar239`.`cl_log`
SET `course_code` = NULL,
`tool_id` = NULL,
`user_id` = NULL,
`ip` = '3.238.24.209',
`date` = '2022-07-01 23:33:55',
`type` = 'message',
`data` = 's:178:\"Data added in platform tracking platform_access : Event::__set_state(array(\n \'_type\' => \'platform_access\',\n \'_args\' => \n array (\n \'date\' => \'2022-07-01 23:33:00\',\n ),\n))\";'
Query counter : 5 : execution time : <0.001µs: affected rows :1
INSERT INTO `conbcdc_clar239`.`cl_tracking_event`
SET `course_code` = NULL,
`tool_id` = NULL,
`user_id` = NULL,
`date` = '2022-07-01 23:33:00',
`type` = 'platform_access',
`data` = ''
Query counter : 0 : execution time : 0.0017µs: affected rows :1
SELECT
c.id AS id,
c.name AS name,
c.code AS code,
c.idParent AS idParent,
c.rank AS rank,
c.visible AS visible,
c.canHaveCoursesChild AS canHaveCoursesChild,
rcc.courseId AS rootCourse
FROM `conbcdc_clar239`.`cl_category` AS c
LEFT JOIN `conbcdc_clar239`.`cl_rel_course_category` AS rcc
ON rcc.categoryId = c.id
AND rcc.rootCourse = 1
WHERE c.id = 0
Query counter : 1 : execution time : <0.001µs: affected rows :5
SELECT c.id, c.name,
c.code, c.idParent, c.rank, c.visible, c.canHaveCoursesChild
FROM `conbcdc_clar239`.`cl_category` AS c
WHERE c.idParent = 0
AND c.visible = 1
ORDER BY c.`rank`
Query counter : 6 : execution time : <0.001µs: affected rows :0
SELECT c.cours_id AS id,
c.titulaires AS titular,
c.code AS sysCode,
c.isSourceCourse AS isSourceCourse,
c.sourceCourseId AS sourceCourseId,
c.intitule AS title,
c.administrativeNumber AS officialCode,
c.dbName AS db,
c.intitule AS title,
UNIX_TIMESTAMP(c.expirationDate) AS expirationDate,
UNIX_TIMESTAMP(c.creationDate) AS creationDate,
c.language,
c.directory,
c.visibility,
c.access,
c.registration,
c.email,
c.status,
c.userLimit,
rcc.categoryId AS categoryId,
rcc.rootCourse AS rootCourse
FROM `conbcdc_clar239`.`cl_cours` AS c
LEFT JOIN `conbcdc_clar239`.`cl_rel_course_category` AS rcc
ON c.cours_id = rcc.courseId
WHERE visibility = 'visible'
AND rcc.rootCourse != 1
AND sourceCourseId IS NULL
AND (
(c.status = 'enable'
OR (c.status = 'date'
AND (UNIX_TIMESTAMP(c.creationDate) < '1656729235'
OR c.creationDate IS NULL OR UNIX_TIMESTAMP(c.creationDate) = 0)
AND ('1656729235' < UNIX_TIMESTAMP(c.expirationDate) OR c.expirationDate IS NULL)
)
)
)
AND ( rcc.categoryId = 0) GROUP BY c.code ORDER BY UPPER(c.`administrativeNumber`), c.`intitule`
Query counter : 2 : execution time : <0.001µs: affected rows :0
SELECT
c.code AS courseId,
c.code AS sysCode,
c.cours_id AS id,
c.isSourceCourse AS isSourceCourse,
c.sourceCourseId AS sourceCourseId,
c.intitule AS name,
c.administrativeNumber AS officialCode,
c.administrativeNumber AS administrativeNumber,
c.directory AS path,
c.dbName AS dbName,
c.titulaires AS titular,
c.email AS email,
c.language AS language,
c.extLinkUrl AS extLinkUrl,
c.extLinkName AS extLinkName,
c.visibility AS visibility,
c.access AS access,
c.registration AS registration,
c.registrationKey AS registrationKey,
c.diskQuota AS diskQuota,
UNIX_TIMESTAMP(c.creationDate) AS publicationDate,
UNIX_TIMESTAMP(c.expirationDate) AS expirationDate,
c.status AS status,
c.userLimit AS userLimit
FROM `conbcdc_clar239`.`cl_cours` AS c
JOIN `conbcdc_clar239`.`cl_rel_course_category` AS rcc
ON rcc.courseId = c.cours_id
AND rcc.categoryId = 0
ORDER BY UPPER(`administrativeNumber`), `intitule` ASC
Query counter : 7 : execution time : <0.001µs: affected rows :0
SELECT M.`label` AS `label`,
M.`script_url` AS `entry`,
M.`name` AS `name`,
M.`activation` AS `activation`,
D.`name` AS `dock`
FROM `conbcdc_clar239`.`cl_dock` AS D
LEFT JOIN `conbcdc_clar239`.`cl_module` AS M
ON D.`module_id` = M.`id`
ORDER BY D.`rank`
Query counter : 3 : execution time : <0.001µs: affected rows :1
SELECT COUNT(rcc.courseId) AS nbCourses
FROM `conbcdc_clar239`.`cl_rel_course_category` AS rcc
WHERE rcc.categoryId = 2
AND rootCourse != 1
Query counter : 4 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 2
Query counter : 5 : execution time : <0.001µs: affected rows :1
SELECT COUNT(c.id) AS nbSubCategories
FROM `conbcdc_clar239`.`cl_category` AS c
WHERE c.idParent = 2
Query counter : 6 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 2
Query counter : 7 : execution time : <0.001µs: affected rows :1
SELECT COUNT(rcc.courseId) AS nbCourses
FROM `conbcdc_clar239`.`cl_rel_course_category` AS rcc
WHERE rcc.categoryId = 3
AND rootCourse != 1
Query counter : 8 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 3
Query counter : 9 : execution time : <0.001µs: affected rows :1
SELECT COUNT(c.id) AS nbSubCategories
FROM `conbcdc_clar239`.`cl_category` AS c
WHERE c.idParent = 3
Query counter : 10 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 3
Query counter : 11 : execution time : <0.001µs: affected rows :1
SELECT COUNT(rcc.courseId) AS nbCourses
FROM `conbcdc_clar239`.`cl_rel_course_category` AS rcc
WHERE rcc.categoryId = 4
AND rootCourse != 1
Query counter : 12 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 4
Query counter : 13 : execution time : <0.001µs: affected rows :1
SELECT COUNT(c.id) AS nbSubCategories
FROM `conbcdc_clar239`.`cl_category` AS c
WHERE c.idParent = 4
Query counter : 14 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 4
Query counter : 15 : execution time : <0.001µs: affected rows :1
SELECT COUNT(rcc.courseId) AS nbCourses
FROM `conbcdc_clar239`.`cl_rel_course_category` AS rcc
WHERE rcc.categoryId = 5
AND rootCourse != 1
Query counter : 16 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 5
Query counter : 17 : execution time : <0.001µs: affected rows :1
SELECT COUNT(c.id) AS nbSubCategories
FROM `conbcdc_clar239`.`cl_category` AS c
WHERE c.idParent = 5
Query counter : 18 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 5
Query counter : 19 : execution time : <0.001µs: affected rows :1
SELECT COUNT(rcc.courseId) AS nbCourses
FROM `conbcdc_clar239`.`cl_rel_course_category` AS rcc
WHERE rcc.categoryId = 6
AND rootCourse != 1
Query counter : 20 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 6
Query counter : 21 : execution time : <0.001µs: affected rows :1
SELECT COUNT(c.id) AS nbSubCategories
FROM `conbcdc_clar239`.`cl_category` AS c
WHERE c.idParent = 6
Query counter : 22 : execution time : <0.001µs: affected rows :0
SELECT id
FROM `conbcdc_clar239`.`cl_category`
WHERE idParent = 6
Query counter : 8 : execution time : <0.001µs: affected rows :0
SELECT profile_id AS profileId,
isCourseManager,
isPending,
tutor,
role
FROM `conbcdc_clar239`.`cl_rel_course_user` `cours_user`
WHERE `user_id` = '0'
AND `code_cours` = ''