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` = 1 AND 1 = 1 ORDER BY `School`.`lft` asc | 9 | 9 | 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` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `School`.`title`, `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `parent_id` = 10 AND 1 = 1 ORDER BY `School`.`lft` asc | 2 | 2 | 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 `title` = 'พณิชยการ' AND `parent_id` = 10 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE 1 = 1 AND `School`.`id` = 11 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE 1 = 1 AND `School`.`rght` < 136 AND `School`.`lft` > 109 ORDER BY `School`.`lft` asc | 13 | 13 | 0 | |
SELECT `Course`.`school_id` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` IN (12, 557, 558, 13, 91, 93, 95, 97, 99, 100, 102, 555, 556) GROUP BY `Course`.`school_id` | 5 | 5 | 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` = 93 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` = 93 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 0 | 0 | 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` = 555 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` = 555 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 14 | 14 | 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` = 556 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` = 556 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 16 | 16 | 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` = 557 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` = 557 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 17 | 17 | 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` = 558 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` = 558 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 17 | 17 | 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 | 1 | 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 | 1 | 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 | |