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 | 1 | |
SELECT `School`.`id`, `School`.`title`, `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `parent_id` = 559 AND 1 = 1 ORDER BY `School`.`lft` asc | 1 | 1 | 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 `title` = 'วิชาสามัญ' AND `parent_id` = 559 LIMIT 1 | 1 | 1 | 1 | |
SELECT `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE 1 = 1 AND `School`.`id` = 560 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE 1 = 1 AND `School`.`rght` < 284 AND `School`.`lft` > 269 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 (537, 538, 539, 540, 541, 542, 543) 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` = 537 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` = 537 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` = 538 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` = 538 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` = 539 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` = 539 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 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 `School`.`id` = 540 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` = 540 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` = 541 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` = 541 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` = 542 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` = 542 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` = 543 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` = 543 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 18 | 18 | 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 | |