Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `title` = 'ระยะสั้น' LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `School`.`title`, `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `parent_id` = 3 AND 1 = 1 ORDER BY `School`.`lft` asc | 11 | 11 | 1 | maybe slow |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `title` = 'คหกรรม' AND `parent_id` = 3 LIMIT 1 | 1 | 1 | 1 | |
SELECT `School`.`id`, `School`.`title`, `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `parent_id` = 488 AND 1 = 1 ORDER BY `School`.`lft` asc | 4 | 4 | 1 | maybe slow |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `title` = 'งานผ้า' AND `parent_id` = 488 LIMIT 1 | 1 | 1 | 1 | |
SELECT `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE 1 = 1 AND `School`.`id` = 500 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE 1 = 1 AND `School`.`rght` < 1042 AND `School`.`lft` > 999 ORDER BY `School`.`lft` asc | 7 | 7 | 1 | maybe slow |
SELECT `Course`.`school_id` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` IN (511, 512, 513, 514, 515, 516, 517) GROUP BY `Course`.`school_id` | 7 | 7 | 0 | |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`id` = 511 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`school_id`, `Course`.`code`, `Course`.`title`, `Course`.`description`, `Course`.`image`, `Course`.`objective`, `Course`.`property`, `Course`.`ref`, `Course`.`credit`, `Course`.`use_chatroom`, `Course`.`member_chatroom`, `Course`.`any_time`, `Course`.`enabled`, `Course`.`created`, `Course`.`modified` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` = 511 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 12 | 12 | 1 | maybe slow |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`id` = 512 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`school_id`, `Course`.`code`, `Course`.`title`, `Course`.`description`, `Course`.`image`, `Course`.`objective`, `Course`.`property`, `Course`.`ref`, `Course`.`credit`, `Course`.`use_chatroom`, `Course`.`member_chatroom`, `Course`.`any_time`, `Course`.`enabled`, `Course`.`created`, `Course`.`modified` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` = 512 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 24 | 24 | 1 | |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`id` = 513 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`school_id`, `Course`.`code`, `Course`.`title`, `Course`.`description`, `Course`.`image`, `Course`.`objective`, `Course`.`property`, `Course`.`ref`, `Course`.`credit`, `Course`.`use_chatroom`, `Course`.`member_chatroom`, `Course`.`any_time`, `Course`.`enabled`, `Course`.`created`, `Course`.`modified` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` = 513 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 24 | 24 | 1 | |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`id` = 514 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`school_id`, `Course`.`code`, `Course`.`title`, `Course`.`description`, `Course`.`image`, `Course`.`objective`, `Course`.`property`, `Course`.`ref`, `Course`.`credit`, `Course`.`use_chatroom`, `Course`.`member_chatroom`, `Course`.`any_time`, `Course`.`enabled`, `Course`.`created`, `Course`.`modified` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` = 514 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 23 | 23 | 1 | |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`id` = 515 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`school_id`, `Course`.`code`, `Course`.`title`, `Course`.`description`, `Course`.`image`, `Course`.`objective`, `Course`.`property`, `Course`.`ref`, `Course`.`credit`, `Course`.`use_chatroom`, `Course`.`member_chatroom`, `Course`.`any_time`, `Course`.`enabled`, `Course`.`created`, `Course`.`modified` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` = 515 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 24 | 24 | 1 | |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`id` = 516 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`school_id`, `Course`.`code`, `Course`.`title`, `Course`.`description`, `Course`.`image`, `Course`.`objective`, `Course`.`property`, `Course`.`ref`, `Course`.`credit`, `Course`.`use_chatroom`, `Course`.`member_chatroom`, `Course`.`any_time`, `Course`.`enabled`, `Course`.`created`, `Course`.`modified` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` = 516 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 24 | 24 | 1 | |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`id` = 517 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`school_id`, `Course`.`code`, `Course`.`title`, `Course`.`description`, `Course`.`image`, `Course`.`objective`, `Course`.`property`, `Course`.`ref`, `Course`.`credit`, `Course`.`use_chatroom`, `Course`.`member_chatroom`, `Course`.`any_time`, `Course`.`enabled`, `Course`.`created`, `Course`.`modified` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` = 517 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 19 | 19 | 1 | maybe slow |
SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `ln_learnsquare`.`ln_configurations` AS `Configuration` WHERE 1 = 1 | 7 | 7 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `ln_learnsquare`.`ln_configurations` AS `Configuration` WHERE 1 = 1 | 7 | 7 | 0 | |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`parent_id` IS NULL | 3 | 3 | 2 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`counter`, `Tag`.`created` FROM `ln_learnsquare`.`ln_tags` AS `Tag` WHERE `Tag`.`counter` != 0 ORDER BY `Tag`.`counter` DESC LIMIT 15 | 15 | 15 | 1 | maybe slow |
SELECT `School`.`user_id`, `School`.`id`, `School`.`title`, `School`.`description`, `School`.`image`, `School`.`parent_id`, `School`.`lft`, `School`.`rght`, `School`.`created`, `School`.`modified` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `School`.`parent_id` IS NULL | 3 | 3 | 2 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`counter`, `Tag`.`created` FROM `ln_learnsquare`.`ln_tags` AS `Tag` WHERE `Tag`.`counter` != 0 ORDER BY `Tag`.`counter` DESC LIMIT 15 | 15 | 15 | 1 | maybe slow |
SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `ln_learnsquare`.`ln_configurations` AS `Configuration` WHERE 1 = 1 | 7 | 7 | 0 | |