新着記事
パチンコ＆パチスロ情報満載！ パチ７おすすめコンテンツ
パチンコ＆パチスロ情報満載！
パチ７おすすめコンテンツ
パチンコ・パチスロを楽しむための情報サイト パチ７！
新台情報から攻略情報、全国のチラシ情報まで、完全無料で配信中！
パチンコ・パチスロを楽しむための情報サイト パチ７！
新台情報から攻略情報、全国のチラシ情報まで、完全無料で配信中！
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = '50ab70h47hju0n46875m85bqr3pgvqui' LIMIT 1 | 0 | 0 | 1 | |
| 2 | SELECT `SortTable`.`sort_no`, `SortTable`.`target_id` FROM `pachiseven`.`sort_tables` AS `SortTable` WHERE `table_id` = 1 ORDER BY `sort_no` asc | 5 | 5 | 1 | |
| 3 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 3 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 4 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 2 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 5 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 4 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 6 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 1 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 7 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 5 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 8 | SELECT * FROM site_content_imps WHERE site_id in (1043,1014,1035,1025,1042) AND created = CURRENT_DATE() | 5 | 5 | 1 | |
| 9 | UPDATE site_content_imps SET imp = imp + 1 WHERE site_id in (1043,1014,1035,1025,1042) AND created = CURRENT_DATE() | 5 | 5 | 3 | |
| 10 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 6 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 11 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 7 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 12 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 8 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 13 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 9 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 14 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 10 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 15 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 11 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 16 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 12 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 17 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 13 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 18 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 14 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 19 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 15 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 20 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 16 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 21 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 17 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 22 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 18 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 23 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 19 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 24 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 20 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 25 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 21 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 26 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 22 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 27 | SELECT `Site`.`id`, `Site`.`site_content_id`, `Site`.`title`, `Site`.`image`, `Site`.`link_url`, `Site`.`copyright` FROM `pachiseven`.`sites` AS `Site` LEFT JOIN `pachiseven`.`site_contents` AS `SiteContent` ON (`Site`.`site_content_id` = `SiteContent`.`id` AND `SiteContent`.`del_flg` = 0) WHERE `Site`.`site_content_id` = 23 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
| 28 | 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` = 1 AND `area_no` = 121 AND `Banner`.`pref_id` = 0 ORDER BY `Banner`.`pref_id` DESC | 1 | 1 | 1 | |
| 29 | 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` = 1 AND `area_no` = 121 AND `Banner`.`pref_id` = 0 ORDER BY `Banner`.`pref_id` DESC | 1 | 1 | 1 | |
| 30 | UPDATE banner_imps set imp = imp+1 WHERE id in (35577) | 1 | 1 | 3 | |
| 31 | SELECT `Enquete`.`id`, `Enquete`.`title`, `Enquete`.`summary`, `Enquete`.`category`, `Enquete`.`type`, `Enquete`.`select_num`, `Enquete`.`start_date`, `Enquete`.`end_date`, `Enquete`.`grant_point`, `Enquete`.`result_hide_flg`, `Enquete`.`comment_flg`, `Enquete`.`status`, `Enquete`.`create_by`, `Enquete`.`created`, `Enquete`.`modified_by`, `Enquete`.`modified`, `Enquete`.`del_flg`, (CASE WHEN `Enquete`.`start_date` BETWEEN date_add(current_date, interval -7 day) AND NOW() THEN TRUE ELSE FALSE END) AS `Enquete__new_flg`, (CASE WHEN `Enquete`.`end_date` < NOW() THEN TRUE ELSE FALSE END) AS `Enquete__close_flg` FROM `pachiseven`.`enquetes` AS `Enquete` WHERE `Enquete`.`del_flg` = 0 AND `Enquete`.`status` = 0 AND `Enquete`.`start_date` <= NOW() ORDER BY `Enquete`.`start_date` desc, `Enquete`.`end_date` desc, `Enquete`.`id` desc LIMIT 1 | 1 | 1 | 1 | |
| 32 | SELECT EnqueteChoice.id, EnqueteChoice.title, `EnqueteChoice`.`img`, `EnqueteChoice`.`enquete_id` FROM `pachiseven`.`enquete_choices` AS `EnqueteChoice` WHERE `EnqueteChoice`.`del_flg` = 0 AND `EnqueteChoice`.`enquete_id` = (27) ORDER BY `EnqueteChoice`.`sort_no` ASC | 4 | 4 | 1 | |
| 33 | 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 | 1 | |
| 34 | 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 | 0 | 0 | 1 | |
| 35 | 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 | 1 |