1 | SELECT * FROM front_ads WHERE is_page = 2 AND is_device = 0 AND is_delete = 0 AND (`start_date` is NULL OR NOW() >= `start_date`) AND (`end_date` is NULL OR NOW() >= `end_date`) | | 12 | 12 | 2 |
2 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`thumbnail`, `User`.`url`, `User`.`url2`, `User`.`twitterid`, `User`.`facebookid`, `User`.`instagramid`, `User`.`default_dirname`, `User`.`description`, `User`.`is_rank`, `User`.`is_status`, `User`.`lastlogin`, `User`.`pcount`, `User`.`uniquekey`, `User`.`is_delete`, `User`.`modified`, `User`.`created` FROM `qoly2017`.`users` AS `User` WHERE `User`.`name` = '井上大輔(編集部)' LIMIT 1 | | 1 | 1 | 2 |
3 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`thumbnail`, `User`.`url`, `User`.`url2`, `User`.`twitterid`, `User`.`facebookid`, `User`.`instagramid`, `User`.`default_dirname`, `User`.`description`, `User`.`is_rank`, `User`.`is_status`, `User`.`lastlogin`, `User`.`pcount`, `User`.`uniquekey`, `User`.`is_delete`, `User`.`modified`, `User`.`created` FROM `qoly2017`.`users` AS `User` WHERE `User`.`name` = '奥崎覚(編集部)' LIMIT 1 | | 1 | 1 | 2 |
4 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`thumbnail`, `User`.`url`, `User`.`url2`, `User`.`twitterid`, `User`.`facebookid`, `User`.`instagramid`, `User`.`default_dirname`, `User`.`description`, `User`.`is_rank`, `User`.`is_status`, `User`.`lastlogin`, `User`.`pcount`, `User`.`uniquekey`, `User`.`is_delete`, `User`.`modified`, `User`.`created` FROM `qoly2017`.`users` AS `User` WHERE `User`.`name` = '江島耕太郎(編集部)' LIMIT 1 | | 1 | 1 | 2 |
5 | SELECT `Article`.`id` FROM `qoly2017`.`articles` AS `Article` WHERE `Article`.`directory` = 'kawashima-eiji-interested-in-boca-juniors-kgn-1' AND `Article`.`date` >= '2018-07-27 00:00:00' AND `Article`.`date` <= '2018-07-27 23:59-59' AND `Article`.`is_public` = 1 AND `Article`.`is_delete` = 0 LIMIT 1 | | 1 | 1 | 2 |
6 | SELECT `Article`.`id`, `Article`.`date`, `Article`.`title`, `Article`.`rss_title`, `Article`.`cover`, `Article`.`directory`, `Article`.`user_id`, `Article`.`seo_title`, `Article`.`seo_description`, `Article`.`seo_keywords`, `Article`.`referer_site`, `Article`.`referer_title`, `Article`.`referer_url`, `Article`.`referer_thumb`, `Article`.`is_public`, `Article`.`is_not_rss`, `Article`.`is_not_rss2`, `Article`.`is_fire`, `Article`.`is_ranking`, `Article`.`is_tweet_ranking`, `Article`.`comment_num`, `Article`.`page`, `Article`.`category`, `Article`.`tag`, `Article`.`related`, `Article`.`traffic`, `Article`.`_category`, `Article`.`_tag`, `Article`.`is_delete`, `Article`.`modified`, `Article`.`created`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`thumbnail`, `User`.`url`, `User`.`url2`, `User`.`twitterid`, `User`.`facebookid`, `User`.`instagramid`, `User`.`default_dirname`, `User`.`description`, `User`.`is_rank`, `User`.`is_status`, `User`.`lastlogin`, `User`.`pcount`, `User`.`uniquekey`, `User`.`is_delete`, `User`.`modified`, `User`.`created` FROM `qoly2017`.`articles` AS `Article` LEFT JOIN `qoly2017`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`id` = 82219 LIMIT 1 | | 1 | 1 | 2 |
7 | SELECT `ArticleBody`.`article_id`, `ArticleBody`.`no`, `ArticleBody`.`body` FROM `qoly2017`.`article_bodies` AS `ArticleBody` WHERE `ArticleBody`.`article_id` = (82219) ORDER BY `no` ASC | | 1 | 1 | 2 |
8 | SELECT `ArticleCategory`.`article_id`, `ArticleCategory`.`category_id` FROM `qoly2017`.`article_categories` AS `ArticleCategory` WHERE `ArticleCategory`.`article_id` = (82219) | | 4 | 4 | 2 |
9 | SELECT `Category`.`id`, `Category`.`is_level`, `Category`.`parent_id`, `Category`.`name`, `Category`.`directory`, `Category`.`description`, `Category`.`sort`, `Category`.`pcount`, `Category`.`public_count`, `Category`.`is_delete`, `Category`.`modified`, `Category`.`created` FROM `qoly2017`.`categories` AS `Category` WHERE `Category`.`id` = 17 | | 1 | 1 | 2 |
10 | SELECT `Category`.`id`, `Category`.`is_level`, `Category`.`parent_id`, `Category`.`name`, `Category`.`directory`, `Category`.`description`, `Category`.`sort`, `Category`.`pcount`, `Category`.`public_count`, `Category`.`is_delete`, `Category`.`modified`, `Category`.`created` FROM `qoly2017`.`categories` AS `Category` WHERE `Category`.`id` = 39 | | 1 | 1 | 2 |
11 | SELECT `Category`.`id`, `Category`.`is_level`, `Category`.`parent_id`, `Category`.`name`, `Category`.`directory`, `Category`.`description`, `Category`.`sort`, `Category`.`pcount`, `Category`.`public_count`, `Category`.`is_delete`, `Category`.`modified`, `Category`.`created` FROM `qoly2017`.`categories` AS `Category` WHERE `Category`.`id` = 47 | | 1 | 1 | 2 |
12 | SELECT `Category`.`id`, `Category`.`is_level`, `Category`.`parent_id`, `Category`.`name`, `Category`.`directory`, `Category`.`description`, `Category`.`sort`, `Category`.`pcount`, `Category`.`public_count`, `Category`.`is_delete`, `Category`.`modified`, `Category`.`created` FROM `qoly2017`.`categories` AS `Category` WHERE `Category`.`id` = 65 | | 1 | 1 | 2 |
13 | SELECT `ArticleAssociate`.`article_id`, `ArticleAssociate`.`no`, `ArticleAssociate`.`uniquekey` FROM `qoly2017`.`article_associates` AS `ArticleAssociate` WHERE `ArticleAssociate`.`article_id` = (82219) | | 0 | 0 | 2 |
14 | SELECT `ArticleIsource`.`article_id`, `ArticleIsource`.`is_isource` FROM `qoly2017`.`article_isources` AS `ArticleIsource` WHERE `ArticleIsource`.`article_id` = (82219) | | 1 | 1 | 2 |
15 | SELECT `ArticleLink`.`id`, `ArticleLink`.`article_id`, `ArticleLink`.`title`, `ArticleLink`.`url`, `ArticleLink`.`is_delete`, `ArticleLink`.`modified`, `ArticleLink`.`created` FROM `qoly2017`.`article_links` AS `ArticleLink` WHERE `ArticleLink`.`article_id` = (82219) | | 0 | 0 | 2 |
16 | SELECT `ArticleRelated`.`article_id`, `ArticleRelated`.`related_id` FROM `qoly2017`.`article_relateds` AS `ArticleRelated` WHERE `ArticleRelated`.`article_id` = (82219) ORDER BY `ArticleRelated`.`related_id` DESC | | 4 | 4 | 2 |
17 | SELECT `Related`.`id`, `Related`.`date`, `Related`.`title`, `Related`.`rss_title`, `Related`.`cover`, `Related`.`directory`, `Related`.`user_id`, `Related`.`seo_title`, `Related`.`seo_description`, `Related`.`seo_keywords`, `Related`.`referer_site`, `Related`.`referer_title`, `Related`.`referer_url`, `Related`.`referer_thumb`, `Related`.`is_public`, `Related`.`is_not_rss`, `Related`.`is_not_rss2`, `Related`.`is_fire`, `Related`.`is_ranking`, `Related`.`is_tweet_ranking`, `Related`.`comment_num`, `Related`.`page`, `Related`.`category`, `Related`.`tag`, `Related`.`related`, `Related`.`traffic`, `Related`.`_category`, `Related`.`_tag`, `Related`.`is_delete`, `Related`.`modified`, `Related`.`created` FROM `qoly2017`.`articles` AS `Related` WHERE `Related`.`id` = 81764 | | 1 | 1 | 2 |
18 | SELECT `Related`.`id`, `Related`.`date`, `Related`.`title`, `Related`.`rss_title`, `Related`.`cover`, `Related`.`directory`, `Related`.`user_id`, `Related`.`seo_title`, `Related`.`seo_description`, `Related`.`seo_keywords`, `Related`.`referer_site`, `Related`.`referer_title`, `Related`.`referer_url`, `Related`.`referer_thumb`, `Related`.`is_public`, `Related`.`is_not_rss`, `Related`.`is_not_rss2`, `Related`.`is_fire`, `Related`.`is_ranking`, `Related`.`is_tweet_ranking`, `Related`.`comment_num`, `Related`.`page`, `Related`.`category`, `Related`.`tag`, `Related`.`related`, `Related`.`traffic`, `Related`.`_category`, `Related`.`_tag`, `Related`.`is_delete`, `Related`.`modified`, `Related`.`created` FROM `qoly2017`.`articles` AS `Related` WHERE `Related`.`id` = 80674 | | 1 | 1 | 2 |
19 | SELECT `Related`.`id`, `Related`.`date`, `Related`.`title`, `Related`.`rss_title`, `Related`.`cover`, `Related`.`directory`, `Related`.`user_id`, `Related`.`seo_title`, `Related`.`seo_description`, `Related`.`seo_keywords`, `Related`.`referer_site`, `Related`.`referer_title`, `Related`.`referer_url`, `Related`.`referer_thumb`, `Related`.`is_public`, `Related`.`is_not_rss`, `Related`.`is_not_rss2`, `Related`.`is_fire`, `Related`.`is_ranking`, `Related`.`is_tweet_ranking`, `Related`.`comment_num`, `Related`.`page`, `Related`.`category`, `Related`.`tag`, `Related`.`related`, `Related`.`traffic`, `Related`.`_category`, `Related`.`_tag`, `Related`.`is_delete`, `Related`.`modified`, `Related`.`created` FROM `qoly2017`.`articles` AS `Related` WHERE `Related`.`id` = 80467 | | 1 | 1 | 2 |
20 | SELECT `Related`.`id`, `Related`.`date`, `Related`.`title`, `Related`.`rss_title`, `Related`.`cover`, `Related`.`directory`, `Related`.`user_id`, `Related`.`seo_title`, `Related`.`seo_description`, `Related`.`seo_keywords`, `Related`.`referer_site`, `Related`.`referer_title`, `Related`.`referer_url`, `Related`.`referer_thumb`, `Related`.`is_public`, `Related`.`is_not_rss`, `Related`.`is_not_rss2`, `Related`.`is_fire`, `Related`.`is_ranking`, `Related`.`is_tweet_ranking`, `Related`.`comment_num`, `Related`.`page`, `Related`.`category`, `Related`.`tag`, `Related`.`related`, `Related`.`traffic`, `Related`.`_category`, `Related`.`_tag`, `Related`.`is_delete`, `Related`.`modified`, `Related`.`created` FROM `qoly2017`.`articles` AS `Related` WHERE `Related`.`id` = 80161 | | 1 | 1 | 2 |
21 | SELECT `ArticleTag`.`article_id`, `ArticleTag`.`tag_id` FROM `qoly2017`.`article_tags` AS `ArticleTag` WHERE `ArticleTag`.`article_id` = (82219) | | 4 | 4 | 2 |
22 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`pcount`, `Tag`.`public_count`, `Tag`.`is_delete`, `Tag`.`modified`, `Tag`.`created` FROM `qoly2017`.`tags` AS `Tag` WHERE `Tag`.`id` = 14019 | | 1 | 1 | 2 |
23 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`pcount`, `Tag`.`public_count`, `Tag`.`is_delete`, `Tag`.`modified`, `Tag`.`created` FROM `qoly2017`.`tags` AS `Tag` WHERE `Tag`.`id` = 14307 | | 1 | 1 | 2 |
24 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`pcount`, `Tag`.`public_count`, `Tag`.`is_delete`, `Tag`.`modified`, `Tag`.`created` FROM `qoly2017`.`tags` AS `Tag` WHERE `Tag`.`id` = 14518 | | 1 | 1 | 2 |
25 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`pcount`, `Tag`.`public_count`, `Tag`.`is_delete`, `Tag`.`modified`, `Tag`.`created` FROM `qoly2017`.`tags` AS `Tag` WHERE `Tag`.`id` = 18816 | | 1 | 1 | 2 |
26 | SELECT `ArticleRsstext`.`article_id`, `ArticleRsstext`.`rss_text_link_id` FROM `qoly2017`.`article_rsstexts` AS `ArticleRsstext` WHERE `ArticleRsstext`.`article_id` = (82219) | | 0 | 0 | 2 |
27 | SELECT `ArticleRssRelated`.`article_id`, `ArticleRssRelated`.`related_id` FROM `qoly2017`.`article_rss_relateds` AS `ArticleRssRelated` WHERE `ArticleRssRelated`.`article_id` = (82219) | | 0 | 0 | 2 |
28 | SELECT category_id FROM article_categories WHERE article_id = 81764; | | 2 | 2 | 2 |
29 | SELECT body FROM article_bodies WHERE article_id = 81764 AND no = 1; | | 1 | 1 | 2 |
30 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`thumbnail`, `User`.`url`, `User`.`url2`, `User`.`twitterid`, `User`.`facebookid`, `User`.`instagramid`, `User`.`default_dirname`, `User`.`description`, `User`.`is_rank`, `User`.`is_status`, `User`.`lastlogin`, `User`.`pcount`, `User`.`uniquekey`, `User`.`is_delete`, `User`.`modified`, `User`.`created` FROM `qoly2017`.`users` AS `User` WHERE `User`.`id` = 66 LIMIT 1 | | 1 | 1 | 2 |
31 | SELECT category_id FROM article_categories WHERE article_id = 80674; | | 4 | 4 | 2 |
32 | SELECT body FROM article_bodies WHERE article_id = 80674 AND no = 1; | | 1 | 1 | 2 |
33 | SELECT category_id FROM article_categories WHERE article_id = 80467; | | 4 | 4 | 2 |
34 | SELECT body FROM article_bodies WHERE article_id = 80467 AND no = 1; | | 1 | 1 | 2 |
35 | SELECT category_id FROM article_categories WHERE article_id = 80161; | | 2 | 2 | 2 |
36 | SELECT body FROM article_bodies WHERE article_id = 80161 AND no = 1; | | 1 | 1 | 2 |
37 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`nickname`, `User`.`email`, `User`.`thumbnail`, `User`.`url`, `User`.`url2`, `User`.`twitterid`, `User`.`facebookid`, `User`.`instagramid`, `User`.`default_dirname`, `User`.`description`, `User`.`is_rank`, `User`.`is_status`, `User`.`lastlogin`, `User`.`pcount`, `User`.`uniquekey`, `User`.`is_delete`, `User`.`modified`, `User`.`created` FROM `qoly2017`.`users` AS `User` WHERE `User`.`id` = 58 LIMIT 1 | | 1 | 1 | 2 |