Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `PostType`.`id`, `PostType`.`name`, `PostType`.`style`, `PostType`.`use_category`, `PostType`.`category_name`, `PostType`.`use_file`, `PostType`.`use_poster`, `PostType`.`use_tag`, `PostType`.`use_attribute`, `PostType`.`ecommerce`, `PostType`.`order_by`, `PostType`.`order_dir`, `PostType`.`order_category_by`, `PostType`.`order_category_dir`, `PostType`.`num_display`, `PostType`.`multi_upload`, `PostType`.`allow_comment`, `PostType`.`approve_comments`, `PostType`.`created` FROM `post_types` AS `PostType` WHERE 1 = 1 | | 3 | 3 | 0 | |
SELECT `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `post_categories` AS `PostCategory` WHERE 1 = 1 | | 17 | 17 | 0 | |
SELECT `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `post_categories` AS `PostCategory` WHERE `PostCategory`.`post_type_id` = 1 | | 6 | 6 | 0 | |
SELECT `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `post_categories` AS `PostCategory` WHERE `PostCategory`.`id` = 3 LIMIT 1 | | 1 | 1 | 0 | |
SELECT `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `post_categories` AS `PostCategory` WHERE `PostCategory`.`post_type_id` = 1 ORDER BY `PostCategory`.`name` asc | | 6 | 6 | 0 | |
SELECT COUNT(*) AS `count` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `post_types` AS `PostType` ON (`Post`.`post_type_id` = `PostType`.`id`) LEFT JOIN `post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`post_type_id` = 1 AND `Post`.`publish` = 1 AND `Post`.`display_date` < '2019-12-14 23:59:05' AND `Post`.`post_category_id` = 3 | | 1 | 1 | 6 | maybe slow |
SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`post_type_id`, `Post`.`post_category_id`, `Post`.`user_file_id`, `Post`.`poster_user_file_id`, `Post`.`slug`, `Post`.`title`, `Post`.`body`, `Post`.`allow_comment`, `Post`.`publish`, `Post`.`public`, `Post`.`ip`, `Post`.`display_date`, `Post`.`tags`, `Post`.`source_only`, `Post`.`sort_order`, `Post`.`price`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`display_name`, `User`.`description`, `User`.`user_file_id`, `User`.`group_id`, `User`.`profile_id`, `User`.`notify_comment`, `User`.`active`, `User`.`confirmed`, `User`.`confirmation_code`, `User`.`reset_code`, `User`.`created`, `User`.`modified`, `PostType`.`id`, `PostType`.`name`, `PostType`.`style`, `PostType`.`use_category`, `PostType`.`category_name`, `PostType`.`use_file`, `PostType`.`use_poster`, `PostType`.`use_tag`, `PostType`.`use_attribute`, `PostType`.`ecommerce`, `PostType`.`order_by`, `PostType`.`order_dir`, `PostType`.`order_category_by`, `PostType`.`order_category_dir`, `PostType`.`num_display`, `PostType`.`multi_upload`, `PostType`.`allow_comment`, `PostType`.`approve_comments`, `PostType`.`created`, `PostCategory`.`id`, `PostCategory`.`post_type_id`, `PostCategory`.`name`, `PostCategory`.`body`, `PostCategory`.`source_only`, `PostCategory`.`sort_order`, `PostCategory`.`passcode`, `PostCategory`.`created` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `post_types` AS `PostType` ON (`Post`.`post_type_id` = `PostType`.`id`) LEFT JOIN `post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`post_type_id` = 1 AND `Post`.`publish` = 1 AND `Post`.`display_date` < '2019-12-14 23:59:05' AND `Post`.`post_category_id` = 3 ORDER BY `Post`.`sort_order` ASC LIMIT 100 | | 8 | 8 | 7 | maybe slow |