Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Article`.`id`, `Article`.`type`, `Article`.`url`, `Article`.`title`, `Article`.`image_id`, `Article`.`body`, `Article`.`relations`, `Article`.`bbs_category_id`, `Article`.`sort`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `karadanote_test`.`baby_articles` AS `Article` WHERE `Article`.`id` = 39 AND `Article`.`status` = 10 LIMIT 1 | 1 | 1 | 1 | |
SELECT `HowtoPage`.`page_id`, `HowtoPage`.`page_namespace`, `HowtoPage`.`page_title`, `HowtoPage`.`page_restrictions`, `HowtoPage`.`page_counter`, `HowtoPage`.`page_is_good`, `HowtoPage`.`page_is_normally`, `HowtoPage`.`page_is_nogood`, `HowtoPage`.`page_ns_difficulty`, `HowtoPage`.`page_ns_usetime`, `HowtoPage`.`page_is_new`, `HowtoPage`.`page_random`, `HowtoPage`.`page_touched`, `HowtoPage`.`page_latest`, `HowtoPage`.`page_approval`, `HowtoRevision`.`rev_id`, `HowtoRevision`.`rev_page`, `HowtoRevision`.`rev_text_id`, `HowtoRevision`.`rev_comment`, `HowtoRevision`.`rev_hosoku_comment`, `HowtoRevision`.`rev_user_id`, `HowtoRevision`.`rev_user_text`, `HowtoRevision`.`rev_timestamp`, `HowtoRevision`.`rev_parent_id`, `HowtoRevision`.`rev_from_admin_msg`, `HowtoRevision`.`rev_approval`, `HowtoText`.`old_id`, `HowtoText`.`old_text` FROM `karadanote_test`.`howto_page` AS `HowtoPage` LEFT JOIN `karadanote_test`.`howto_revision` AS `HowtoRevision` ON (`HowtoRevision`.`rev_id` = `HowtoPage`.`page_latest`) LEFT JOIN `karadanote_test`.`howto_text` AS `HowtoText` ON (`HowtoText`.`old_id` = `HowtoRevision`.`rev_text_id`) WHERE `HowtoPage`.`page_id` IN (13647, 1864, 20913, 20914, 13697) AND `HowtoPage`.`page_approval` = 1 | 2 | 2 | 32 | maybe slow |
SELECT `BbsQuestion`.`id`, `BbsQuestion`.`user_id`, `BbsQuestion`.`uuid`, `BbsQuestion`.`ua_type`, `BbsQuestion`.`ua`, `BbsQuestion`.`name`, `BbsQuestion`.`age`, `BbsQuestion`.`icon`, `BbsQuestion`.`genre_id`, `BbsQuestion`.`title`, `BbsQuestion`.`body`, `BbsQuestion`.`email`, `BbsQuestion`.`week`, `BbsQuestion`.`trouble`, `BbsQuestion`.`answers`, `BbsQuestion`.`views`, `BbsQuestion`.`points`, `BbsQuestion`.`alerts`, `BbsQuestion`.`status`, `BbsQuestion`.`patrol_status`, `BbsQuestion`.`admin_flg`, `BbsQuestion`.`adult_flg`, `BbsQuestion`.`entry_date`, `BbsQuestion`.`update_date`, `BbsQuestion`.`is_deleted`, `BbsQuestion`.`created`, `BbsQuestion`.`modified`, `BbsCategory`.`id`, `BbsCategory`.`name`, `BbsCategory`.`path`, `BbsCategory`.`sort`, `BbsCategory`.`is_login` FROM `karadanote_test`.`bbs_questions` AS `BbsQuestion` LEFT JOIN `karadanote_test`.`bbs_categories` AS `BbsCategory` ON (`BbsQuestion`.`genre_id` = `BbsCategory`.`id`) WHERE `status` >= 10 AND exists(select * from bbs_categories as BbsCategory where (path like '%2001%' or id='2001') and BbsCategory.id=BbsQuestion.genre_id) ORDER BY `entry_date` desc LIMIT 5 | 5 | 5 | 100 | maybe slow |
SELECT `EntryImage`.*, `Image`.`code`, `Image`.`ext` FROM `karadanote_test`.`baby_entry_images` AS `EntryImage` LEFT JOIN `karadanote_test`.`baby_images` AS `Image` ON (`EntryImage`.`image_id` = `Image`.`id`) WHERE `EntryImage`.`type` = 1 AND `EntryImage`.`week` IN (4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) AND `EntryImage`.`approval` = 1 ORDER BY `created` desc, `EntryImage`.`created` desc LIMIT 8 | 7 | 7 | 1 | maybe slow |
SELECT `EntryImage`.*, `Image`.`code`, `Image`.`ext` FROM `karadanote_test`.`baby_entry_images` AS `EntryImage` LEFT JOIN `karadanote_test`.`baby_images` AS `Image` ON (`EntryImage`.`image_id` = `Image`.`id`) WHERE `EntryImage`.`type` = 2 AND `EntryImage`.`week` IN (4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) AND `EntryImage`.`approval` = 1 ORDER BY `created` desc, `EntryImage`.`created` desc LIMIT 8 | 0 | 0 | 1 | maybe slow |
select id, `type`, title, url, sort, created, modified, body, kind from(
(select id, `type`, title, concat('/article/', id) as url, sort, body, created, modified, 'article' as kind from baby_articles where status=10 and type=? and id <> ?)
union
(select id, `type`, title, concat('/checklist/', id) as url, sort, body, created, modified, 'checklist' as kind from baby_checklists where status=10 and type=? and id <> ?)
) as ArticleChecklist order by rand() limit 3 offset 0 [ 1, 39, 1, 39 ] | 3 | 3 | 2 | maybe slow |