Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW FULL COLUMNS FROM `posts` | | 20 | 20 | 2 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `users` | | 15 | 15 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `user_files` | | 15 | 15 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `groups` | | 2 | 2 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `post_comments` | | 12 | 12 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `post_types` | | 19 | 19 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `post_categories` | | 8 | 8 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `post_notifications` | | 3 | 3 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `tags` | | 4 | 4 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `models_tags` | | 6 | 6 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `post_attributes` | | 4 | 4 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `post_attribute_types` | | 4 | 4 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `posts_post_attributes` | | 9 | 9 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `posts_user_files` | | 4 | 4 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `posts_revs` | | 21 | 21 | 1 | |
SHOW FULL COLUMNS FROM `posts_users` | | 4 | 4 | 1 | maybe slow |
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` = 2 | | 4 | 4 | 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` = 14 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` = 2 ORDER BY `PostCategory`.`name` asc | | 4 | 4 | 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` = 2 AND `Post`.`publish` = 1 AND `Post`.`display_date` < '2019-12-14 23:41:32' AND `Post`.`post_category_id` = 14 | | 1 | 1 | 3 | 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` = 2 AND `Post`.`publish` = 1 AND `Post`.`display_date` < '2019-12-14 23:41:32' AND `Post`.`post_category_id` = 14 ORDER BY `Post`.`display_date` DESC LIMIT 20 | | 3 | 3 | 3 | |