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 | 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` = 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` = 4 AND 1 = 1 ORDER BY `School`.`lft` asc | 9 | 9 | 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` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE 1 = 1 AND `School`.`id` = 49 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE 1 = 1 AND `School`.`rght` < 70 AND `School`.`lft` > 39 ORDER BY `School`.`lft` asc | 15 | 15 | 0 | |
SELECT `Course`.`school_id` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE `school_id` IN (51, 52, 54, 56, 58, 567, 545, 546, 547, 548, 549, 550, 551, 552, 553) GROUP BY `Course`.`school_id` | 13 | 13 | 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` = 51 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` = 51 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` = 52 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` = 52 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 1 | 1 | 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` = 54 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` = 54 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 2 | 2 | 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` = 545 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` = 545 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 8 | 8 | 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` = 546 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` = 546 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` = 547 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` = 547 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` = 548 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` = 548 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` = 549 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` = 549 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` = 550 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` = 550 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` = 551 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` = 551 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` = 552 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` = 552 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 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`.`id` = 553 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` = 553 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` = 567 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` = 567 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 11 | 11 | 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 | |