1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'gb1eldh1827p8mcnsbc6janfilv4vc56' LIMIT 1 | | 0 | 0 | 4 |
2 | SELECT `BannerAreaRatio`.`id`, `BannerAreaRatio`.`start_date`, `BannerAreaRatio`.`end_date`, `BannerAreaRatio`.`rate`, `BannerAreaRatio`.`created_by`, `BannerAreaRatio`.`created`, `BannerAreaRatio`.`modified_by`, `BannerAreaRatio`.`modified`, `BannerAreaRatio`.`del_flg` FROM `pachiseven`.`banner_area_ratios` AS `BannerAreaRatio` WHERE `del_flg` = 0 AND start_date <= NOW() AND end_date >= NOW() ORDER BY `id` desc LIMIT 1 | | 0 | 0 | 2 |
3 | SELECT `BannerAreaRatio`.`id`, `BannerAreaRatio`.`start_date`, `BannerAreaRatio`.`end_date`, `BannerAreaRatio`.`rate`, `BannerAreaRatio`.`created_by`, `BannerAreaRatio`.`created`, `BannerAreaRatio`.`modified_by`, `BannerAreaRatio`.`modified`, `BannerAreaRatio`.`del_flg` FROM `pachiseven`.`banner_area_ratios` AS `BannerAreaRatio` WHERE `del_flg` = 0 AND start_date <= NOW() AND end_date >= NOW() ORDER BY `id` desc LIMIT 1 | | 0 | 0 | 4 |
4 | SELECT `ColumnCategory`.`id`, `ColumnCategory`.`order`, `ColumnCategory`.`name`, `ColumnCategory`.`memo`, `ColumnCategory`.`created_by`, `ColumnCategory`.`created`, `ColumnCategory`.`modified_by`, `ColumnCategory`.`modified`, `ColumnCategory`.`del_flg`, (0) AS `ColumnCategory__category_count` FROM `pachiseven`.`column_categories` AS `ColumnCategory` WHERE `ColumnCategory`.`del_flg` = 0 ORDER BY `ColumnCategory`.`order` ASC | | 15 | 15 | 3 |
5 | SELECT `Column`.`id`, `Column`.`column_category_id`, `Column`.`column_event_id`, `Column`.`title`, `Column`.`title_img`, `Column`.`contents`, `Column`.`tag`, `Column`.`vote_button_title`, `Column`.`start_date`, `Column`.`limit_date`, `Column`.`status`, `Column`.`unread_cnt`, `Column`.`pv_cnt`, `Column`.`user_id`, `Column`.`created`, `Column`.`modified_by`, `Column`.`modified`, `Column`.`del_flg`, ((SELECT COUNT(*) FROM column_comments WHERE `Column`.`id` = `column_comments`.`column_id` AND `column_comments`.`status` = 0 AND `column_comments`.`del_flg` = 0)) AS `Column__comment_count`, ((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) AS `Column__vote_count`, `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment`, `ColumnEvent`.`event_title`, `ColumnEventV2`.`event_title` FROM `pachiseven`.`columns` AS `Column` LEFT JOIN `pachiseven`.`users` AS `User` ON (`Column`.`user_id` = `User`.`id` AND `User`.`del_flg` = 0 AND `User`.`status` = 0) LEFT JOIN `pachiseven`.`column_events` AS `ColumnEvent` ON (`Column`.`column_event_id` = `ColumnEvent`.`id` AND `ColumnEvent`.`del_flg` = 0 AND `ColumnEvent`.`status` = 0) LEFT JOIN `pachiseven`.`column_events_v2` AS `ColumnEventV2` ON (`Column`.`column_event_id` = `ColumnEventV2`.`id` AND `ColumnEventV2`.`del_flg` = 0 AND `ColumnEventV2`.`status` = 0) WHERE `Column`.`status` = 0 AND `Column`.`del_flg` = 0 AND DATE_FORMAT(`Column`.`start_date`, "%Y") < 9999 AND ((((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) >= 20) OR (`Column`.`pv_cnt` >= 1000)) ORDER BY RAND() ASC LIMIT 5 | | 5 | 5 | 486 |
6 | SELECT `ColumnImage`.`id`, `ColumnImage`.`column_id`, `ColumnImage`.`img`, `ColumnImage`.`img_tag`, `ColumnImage`.`img_no`, `ColumnImage`.`user_id`, `ColumnImage`.`created`, `ColumnImage`.`modified_by`, `ColumnImage`.`modified`, `ColumnImage`.`del_flg` FROM `pachiseven`.`column_images` AS `ColumnImage` WHERE `del_flg` = 0 AND `ColumnImage`.`column_id` IN (4532, 2927, 1813, 8913, 11654) ORDER BY `img_no` ASC | | 0 | 0 | 2 |
7 | SELECT `Column`.`id`, `Column`.`column_category_id`, `Column`.`column_event_id`, `Column`.`title`, `Column`.`title_img`, `Column`.`contents`, `Column`.`tag`, `Column`.`vote_button_title`, `Column`.`start_date`, `Column`.`limit_date`, `Column`.`status`, `Column`.`unread_cnt`, `Column`.`pv_cnt`, `Column`.`user_id`, `Column`.`created`, `Column`.`modified_by`, `Column`.`modified`, `Column`.`del_flg`, ((SELECT COUNT(*) FROM column_comments WHERE `Column`.`id` = `column_comments`.`column_id` AND `column_comments`.`status` = 0 AND `column_comments`.`del_flg` = 0)) AS `Column__comment_count`, ((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) AS `Column__vote_count`, `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment`, `ColumnEvent`.`event_title`, `ColumnEventV2`.`event_title` FROM `pachiseven`.`columns` AS `Column` LEFT JOIN `pachiseven`.`users` AS `User` ON (`Column`.`user_id` = `User`.`id` AND `User`.`del_flg` = 0 AND `User`.`status` = 0) LEFT JOIN `pachiseven`.`column_events` AS `ColumnEvent` ON (`Column`.`column_event_id` = `ColumnEvent`.`id` AND `ColumnEvent`.`del_flg` = 0 AND `ColumnEvent`.`status` = 0) LEFT JOIN `pachiseven`.`column_events_v2` AS `ColumnEventV2` ON (`Column`.`column_event_id` = `ColumnEventV2`.`id` AND `ColumnEventV2`.`del_flg` = 0 AND `ColumnEventV2`.`status` = 0) WHERE `Column`.`status` = 0 AND `Column`.`del_flg` = 0 AND DATE_FORMAT(`Column`.`start_date`, "%Y") < 9999 AND `Column`.`id` = 4631 LIMIT 1 | | 1 | 1 | 3 |
8 | SELECT `ColumnImage`.`id`, `ColumnImage`.`column_id`, `ColumnImage`.`img`, `ColumnImage`.`img_tag`, `ColumnImage`.`img_no`, `ColumnImage`.`user_id`, `ColumnImage`.`created`, `ColumnImage`.`modified_by`, `ColumnImage`.`modified`, `ColumnImage`.`del_flg` FROM `pachiseven`.`column_images` AS `ColumnImage` WHERE `del_flg` = 0 AND `ColumnImage`.`column_id` = (4631) ORDER BY `img_no` ASC | | 0 | 0 | 2 |
9 | SELECT COUNT(*) AS `count` FROM `pachiseven`.`column_votes` AS `ColumnVote` LEFT JOIN `pachiseven`.`users` AS `User` ON (`ColumnVote`.`user_id` = `User`.`id` AND `User`.`del_flg` = 0 AND `User`.`status` = 0) LEFT JOIN `pachiseven`.`columns` AS `Column` ON (`ColumnVote`.`column_id` = `Column`.`id` AND `Column`.`del_flg` = 0 AND `Column`.`status` = 0) WHERE `ColumnVote`.`user_id` = 0 AND `ColumnVote`.`column_id` = 4631 AND `ColumnVote`.`del_flg` = 0 | | 1 | 1 | 2 |
10 | SELECT `Column`.`id` FROM `pachiseven`.`columns` AS `Column` WHERE `Column`.`status` = 0 AND `Column`.`del_flg` = 0 AND DATE_FORMAT(`Column`.`start_date`, "%Y") < 9999 AND `Column`.`user_id` = 6529 ORDER BY `Column`.`start_date` DESC | | 29 | 29 | 9 |
11 | UPDATE columns SET pv_cnt = (pv_cnt + 1) WHERE id = 4631 | | 1 | 1 | 5 |
12 | SELECT `Column`.`id`, `Column`.`column_category_id`, `Column`.`column_event_id`, `Column`.`title`, `Column`.`title_img`, `Column`.`contents`, `Column`.`tag`, `Column`.`vote_button_title`, `Column`.`start_date`, `Column`.`limit_date`, `Column`.`status`, `Column`.`unread_cnt`, `Column`.`pv_cnt`, `Column`.`user_id`, `Column`.`created`, `Column`.`modified_by`, `Column`.`modified`, `Column`.`del_flg`, ((SELECT COUNT(*) FROM column_comments WHERE `Column`.`id` = `column_comments`.`column_id` AND `column_comments`.`status` = 0 AND `column_comments`.`del_flg` = 0)) AS `Column__comment_count`, ((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) AS `Column__vote_count`, `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment`, `ColumnEvent`.`event_title`, `ColumnEventV2`.`event_title` FROM `pachiseven`.`columns` AS `Column` LEFT JOIN `pachiseven`.`users` AS `User` ON (`Column`.`user_id` = `User`.`id` AND `User`.`del_flg` = 0 AND `User`.`status` = 0) LEFT JOIN `pachiseven`.`column_events` AS `ColumnEvent` ON (`Column`.`column_event_id` = `ColumnEvent`.`id` AND `ColumnEvent`.`del_flg` = 0 AND `ColumnEvent`.`status` = 0) LEFT JOIN `pachiseven`.`column_events_v2` AS `ColumnEventV2` ON (`Column`.`column_event_id` = `ColumnEventV2`.`id` AND `ColumnEventV2`.`del_flg` = 0 AND `ColumnEventV2`.`status` = 0) WHERE `Column`.`status` = 0 AND `Column`.`del_flg` = 0 AND DATE_FORMAT(`Column`.`start_date`, "%Y") < 9999 AND `Column`.`start_date` >= DATE_FORMAT(date_add(NOW(), interval -7 day), "%Y-%m-%d") ORDER BY ((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) DESC, `Column`.`start_date` DESC LIMIT 10 | | 0 | 0 | 22 |
13 | SELECT `ColumnComment`.`id`, `ColumnComment`.`column_id`, `ColumnComment`.`comment`, `ColumnComment`.`image`, `ColumnComment`.`status`, `ColumnComment`.`user_id`, `ColumnComment`.`res_user_id`, `ColumnComment`.`created`, `ColumnComment`.`modified_by`, `ColumnComment`.`modified`, `ColumnComment`.`del_flg`, `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `Column`.`id`, `Column`.`column_category_id`, `Column`.`column_event_id`, `Column`.`title`, `Column`.`title_img`, `Column`.`contents`, `Column`.`tag`, `Column`.`vote_button_title`, `Column`.`start_date`, `Column`.`limit_date`, `Column`.`status`, `Column`.`unread_cnt`, `Column`.`pv_cnt`, `Column`.`user_id`, `Column`.`created`, `Column`.`modified_by`, `Column`.`modified`, `Column`.`del_flg`, ((SELECT COUNT(*) FROM column_comments WHERE `Column`.`id` = `column_comments`.`column_id` AND `column_comments`.`status` = 0 AND `column_comments`.`del_flg` = 0)) AS `Column__comment_count`, ((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) AS `Column__vote_count` FROM `pachiseven`.`column_comments` AS `ColumnComment` LEFT JOIN `pachiseven`.`users` AS `User` ON (`ColumnComment`.`user_id` = `User`.`id` AND `User`.`del_flg` = 0 AND `User`.`status` = 0) LEFT JOIN `pachiseven`.`columns` AS `Column` ON (`ColumnComment`.`column_id` = `Column`.`id` AND `Column`.`del_flg` = 0 AND `Column`.`status` = 0) WHERE `ColumnComment`.`column_id` = 4631 AND `ColumnComment`.`status` = 0 AND `ColumnComment`.`del_flg` = 0 ORDER BY `ColumnComment`.`created` DESC LIMIT 10 | | 0 | 0 | 2 |
14 | SELECT `Banner`.`id`, `Banner`.`type`, `Banner`.`area_no`, `Banner`.`rate`, `Banner`.`title`, `Banner`.`image`, `Banner`.`link_url`, `Banner`.`disp_mark`, `Banner`.`pref_id`, `Banner`.`bg_color`, `Banner`.`bg_image_pc`, `Banner`.`bg_image_sp`, `BannerImp`.* FROM `pachiseven`.`banners` AS `Banner` LEFT JOIN `pachiseven`.`banner_imps` AS `BannerImp` ON (`BannerImp`.`banner_id` = `Banner`.`id` AND `BannerImp`.`created` = CURRENT_DATE()) WHERE `del_flg` = 0 AND `status` = 0 AND NOW() BETWEEN start_date AND end_date AND ((`type` = 12) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (27, 0) ORDER BY `Banner`.`pref_id` DESC | | 1 | 1 | 2 |
15 | UPDATE banner_imps set imp = imp+1 WHERE id in (44026) | | 1 | 1 | 5 |
16 | SELECT `Banner`.`id`, `Banner`.`type`, `Banner`.`area_no`, `Banner`.`rate`, `Banner`.`title`, `Banner`.`image`, `Banner`.`link_url`, `Banner`.`disp_mark`, `Banner`.`pref_id`, `BannerImp`.* FROM `pachiseven`.`banners` AS `Banner` LEFT JOIN `pachiseven`.`banner_imps` AS `BannerImp` ON (`BannerImp`.`banner_id` = `Banner`.`id` AND `BannerImp`.`created` = CURRENT_DATE()) WHERE `del_flg` = 0 AND `status` = 0 AND NOW() BETWEEN start_date AND end_date AND ((`type` = 15) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` < 121 AND `Banner`.`pref_id` = 0 ORDER BY `area_no` ASC, `Banner`.`id` ASC | | 14 | 14 | 2 |
17 | UPDATE banner_imps set imp = imp+1 WHERE id in (44012,44013,44014,44015,44016,44017,44018,44019,44020,44021,44022,44023,44024,44025) | | 14 | 14 | 5 |
18 | SELECT `Site`.`image` FROM `pachiseven`.`sites` AS `Site` WHERE `site_content_id` = 904 AND NOW() BETWEEN start_date AND end_date AND `del_flg` = 0 ORDER BY `start_date` desc, `id` desc LIMIT 1 | | 0 | 0 | 2 |
19 | SELECT `Site`.`title`, `Site`.`image`, `Site`.`link_url` FROM `pachiseven`.`sites` AS `Site` WHERE `site_content_id` = 903 AND NOW() BETWEEN start_date AND end_date AND `del_flg` = 0 ORDER BY `start_date` desc, `id` desc LIMIT 1 | | 1 | 1 | 2 |
20 | SELECT `ScriptBlock`.`id`, `ScriptBlock`.`contents` FROM `pachiseven`.`script_blocks` AS `ScriptBlock` WHERE NOW() BETWEEN start_date AND IFNULL(end_date, NOW()) AND `target_area_id` = 0 AND `target_id` = 0 AND `status` = 0 AND `del_flg` = 0 ORDER BY `start_date` ASC, `id` ASC | | 3 | 3 | 2 |