Notice (8): Constant REDIS_PORT already defined [APP/Config/app_config.php, line 36]array(1) { [1]=> array(2) { ["pref"]=> string(9) "大阪府" ["pref_key"]=> int(27) } }
パチンコ・パチスロを楽しむための情報サイト パチ7!
新台情報から攻略情報、全国のチラシ情報まで、完全無料で配信中!
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'rkn2em3dl33g78h1e1eap2a2bva54btl' LIMIT 1 | 0 | 0 | 1 | |
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 | 1 | 1 | 1 | |
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 | 1 | 1 | 1 | |
4 | 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 | |
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` = 3 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` = 2 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` = 4 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
8 | 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 | |
9 | 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 | |
10 | SELECT * FROM site_content_imps WHERE site_id in (1043,1014,1035,1025,1042) AND created = CURRENT_DATE() | 5 | 5 | 1 | |
11 | UPDATE site_content_imps SET imp = imp + 1 WHERE site_id in (1043,1014,1035,1025,1042) AND created = CURRENT_DATE() | 5 | 5 | 6 | |
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` = 6 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` = 7 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` = 8 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` = 9 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` = 10 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` = 11 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` = 12 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` = 13 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` = 14 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` = 15 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 9 | |
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` = 16 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` = 17 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` = 18 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` = 19 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` = 20 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` = 21 AND `Site`.`start_date` <= NOW() AND `Site`.`del_flg` = 0 ORDER BY `Site`.`start_date` desc LIMIT 1 | 1 | 1 | 1 | |
28 | 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 | |
29 | 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 | |
30 | SELECT Banner.id, type, area_no, rate, title, image, link_url, disp_mark FROM `banners` as Banner WHERE 1 and type = 1 AND area_no < 121 AND Banner.pref_id = 0 AND del_flg = 0 AND status = 0 AND (NOW() BETWEEN start_date AND end_date) order by area_no, Banner.id | 14 | 14 | 1 | |
31 | SELECT * FROM `banner_imps` WHERE 1 and banner_id in (1,2,3,4,5,6,7,8,11,12,13,14,9,10) and created = CURRENT_DATE() | 0 | 0 | 1 | |
32 | 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` IN (27, 0) ORDER BY `Banner`.`pref_id` DESC | 1 | 1 | 1 | |
33 | 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` IN (27, 0) ORDER BY `Banner`.`pref_id` DESC | 1 | 1 | 1 | |
34 | 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 | |
35 | 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 | |
36 | SELECT `Handbill`.*, `Hall`.`name`, (CASE WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = 0 THEN 1 WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = -1 THEN 2 WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = 1 THEN 3 ELSE 4 END) AS `Handbill__sort_public`, (EXISTS (SELECT * FROM handbill_imps WHERE `handbill_imps`.`created` = CURRENT_DATE() AND `handbill_imps`.`handbill_id` = `Handbill`.`id`)) AS `Handbill__is_imps`, (CONCAT(`Hall`.`pref`, `Hall`.`city`, `Hall`.`address`)) AS `Handbill__full_address`, (RAND(6148)) AS `Handbill__sort_number` FROM `pachiseven`.`handbills` AS `Handbill` INNER JOIN `pachiseven`.`halls` AS `Hall` ON (`Handbill`.`hall_id` = `Hall`.`id` AND `Hall`.`del_flg` = 0 AND `Hall`.`status` = 0 AND IFNULL(`Hall`.`start_date`, NOW()) <= NOW()) WHERE `Handbill`.`del_flg` = 0 AND `Handbill`.`approval_status` = 0 AND `Handbill`.`status` = 0 AND `Handbill`.`start_date` <= NOW() AND `Handbill`.`end_date` >= NOW() ORDER BY (CASE WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = 0 THEN 1 WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = -1 THEN 2 WHEN (to_days(now()) - to_days(`Handbill`.`public_date`)) = 1 THEN 3 ELSE 4 END) ASC, `Handbill`.`type` DESC, `Handbill`.`start_date` DESC, (RAND(6148)) ASC, `Handbill`.`id` ASC LIMIT 10 | 4 | 4 | 92 | |
37 | 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 | |
38 | 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 | |
39 | 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 |