Query counter : 1 : execution time : <0.001µs: affected rows :4
SELECT `m`.`label` AS `label`
FROM `rimam1_stg`.`cl_module` AS `m`
LEFT JOIN `rimam1_stg`.`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 `rimam1_stg`.`cl_right_profile`
ORDER BY profile_id
Query counter : 3 : execution time : <0.001µs: affected rows :1
INSERT INTO `rimam1_stg`.`cl_log`
SET `course_code` = NULL,
`tool_id` = NULL,
`user_id` = NULL,
`ip` = '204.236.226.210',
`date` = '2010-04-28 18:36:50',
`type` = 'debug',
`data` = 's:36:\"EventManager::notify platform_access\";'
Query counter : 4 : execution time : <0.001µs: affected rows :1
INSERT INTO `rimam1_stg`.`cl_log`
SET `course_code` = NULL,
`tool_id` = NULL,
`user_id` = NULL,
`ip` = '204.236.226.210',
`date` = '2010-04-28 18:36:50',
`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\' => \'2010-04-28 18:36:00\',\n ),\n))\";'
Query counter : 5 : execution time : <0.001µs: affected rows :1
INSERT INTO `rimam1_stg`.`cl_tracking_event`
SET `course_code` = NULL,
`tool_id` = NULL,
`user_id` = NULL,
`date` = '2010-04-28 18:36:00',
`type` = 'platform_access',
`data` = ''
Query counter : 6 : 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 `rimam1_stg`.`cl_dock` AS D
LEFT JOIN `rimam1_stg`.`cl_module` AS M
ON D.`module_id` = M.`id`
ORDER BY D.`rank`
Query counter : 7 : execution time : 0.0639µs: affected rows :1
SELECT * FROM `cl_wallpaper` ORDER BY RAND() LIMIT 1
Query counter : 8 : execution time : <0.001µs: affected rows :3
SELECT `faculte`.`code` , `faculte`.`name`,
`faculte`.`code_P`, `faculte`.`nb_childs`,
COUNT( `cours`.`cours_id` ) AS `nbCourse`
FROM `rimam1_stg`.`cl_faculte` AS `faculte`
LEFT JOIN `rimam1_stg`.`cl_faculte` AS `subCat`
ON (`subCat`.`treePos` >= `faculte`.`treePos`
AND `subCat`.`treePos` <= (`faculte`.`treePos`+`faculte`.`nb_childs`) )
LEFT JOIN `rimam1_stg`.`cl_cours` AS `cours`
ON `cours`.`faculte` = `subCat`.`code`
AND `cours`.visibility = 'VISIBLE'
WHERE `faculte`.`code` IS NULL
OR `faculte`.`code_P` IS NULL
AND (`cours`.`status` = 'enable'
OR (`cours`.`status` = 'date'
AND (`cours`.`creationDate` < '2010-04-28 18:36:50' OR `cours`.`creationDate` IS NULL OR UNIX_TIMESTAMP(`cours`.`creationDate`)=0)
AND ('2010-04-28 18:36:50'<`cours`.`expirationDate` OR `cours`.`expirationDate` IS NULL)))
GROUP BY `faculte`.`code`
ORDER BY `faculte`.`treePos`
Query counter : 9 : execution time : 0.0239µs: affected rows :0
SELECT intitule AS title,
titulaires AS titular,
code AS sysCode,
administrativeNumber AS officialCode,
`language`,
directory,
visibility,
access,
registration,
email,
status,
course_fees,
NULL AS enroled FROM `rimam1_stg`.`cl_cours` AS c
WHERE c.`faculte` = ''
AND visibility = 'VISIBLE'
AND (`status` = 'enable'
OR (`status` = 'date'
AND (`creationDate` < '2010-04-28 18:36:51' OR `creationDate` IS NULL OR UNIX_TIMESTAMP(`creationDate`)=0)
AND ('2010-04-28 18:36:51'<`expirationDate` OR `expirationDate` IS NULL))) ORDER BY UPPER(c.administrativeNumber)
Query counter : 10 : execution time : <0.001µs: affected rows :1
SELECT quote,reference FROM `cl_quote` ORDER BY RAND() LIMIT 1
|