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 | 0 | 0 | 1 | maybe slow |
SELECT `School`.`id`, `School`.`title`, `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `parent_id` IS NULL AND 1 = 1 ORDER BY `School`.`lft` asc | 3 | 3 | 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` IS NULL LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `School`.`id`, `School`.`title`, `School`.`lft`, `School`.`rght` FROM `ln_learnsquare`.`ln_schools` AS `School` WHERE `parent_id` IS NULL AND 1 = 1 ORDER BY `School`.`lft` asc | 3 | 3 | 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` IS NULL LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Course`.`school_id` FROM `ln_learnsquare`.`ln_courses` AS `Course` WHERE 1 = 1 GROUP BY `Course`.`school_id` ORDER BY rand() ASC LIMIT 7 | 7 | 7 | 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` = 527 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` = 527 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` = 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` = 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 `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` = 569 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` = 569 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 18 | 18 | 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` = 3 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` = 3 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 0 | 0 | 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` = 530 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` = 530 AND `enabled` = 1 ORDER BY rand() ASC LIMIT 24 | 12 | 12 | 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 | |