パチンコ・パチスロを楽しむための情報サイト パチ7!
新台情報から解析情報、全国のチラシ情報まで、完全無料で配信中!



会員登録済みの方はこちらから

パスワードを忘れた方はこちら

パチスロ新台情報

パチンコ新台情報

(staging) 11 queries took 423 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'ji950evfp308ijgb55ofu6bbbbu8t33h' LIMIT 1001
2SELECT `Hall`.`id`, `Hall`.`name`, `Hall`.`hall_pic`, `Hall`.`memo`, `Hall`.`bussiness_hours`, `Hall`.`news_1`, `Hall`.`news_start_date_1`, `Hall`.`news_url_1`, `Hall`.`news_date_display_1`, `Hall`.`news_2`, `Hall`.`news_start_date_2`, `Hall`.`news_url_2`, `Hall`.`news_date_display_2`, `Hall`.`user_flg`, `Hall`.`line_qr`, `Hall`.`line_button`, ((SELECT id FROM handbills WHERE `handbills`.`del_flg` = 0 AND `handbills`.`status` = 0 AND `handbills`.`approval_status` = 0 AND (NOW() BETWEEN `handbills`.`start_date` AND `handbills`.`end_date`) AND `handbills`.`hall_id` = `Hall`.`id` ORDER BY `handbills`.`start_date` DESC LIMIT 1)) AS `Hall__handbill_flg`, (CONCAT(`Hall`.`pref`, `Hall`.`city`, `Hall`.`address`)) AS `Hall__full_address`, (CASE WHEN `Hall`.`news_start_date_1` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_1` AND IFNULL(`Hall`.`news_end_date_1`, NOW())) THEN CASE WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN NULL ELSE `Hall`.`news_start_date_2` END WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN `Hall`.`news_start_date_1` ELSE IF(`Hall`.`news_start_date_1` >= `Hall`.`news_start_date_2`, `Hall`.`news_start_date_1`, `Hall`.`news_start_date_2`) END) AS `Hall__news_date`, (CASE WHEN `Hall`.`news_start_date_1` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_1` AND IFNULL(`Hall`.`news_end_date_1`, NOW())) THEN CASE WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN NULL ELSE `Hall`.`news_2` END WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN `Hall`.`news_1` ELSE IF(`Hall`.`news_start_date_1` >= `Hall`.`news_start_date_2`, `Hall`.`news_1`, `Hall`.`news_2`) END) AS `Hall__news_contents`, (NOW() BETWEEN IFNULL(`Hall`.`news_start_date_1`, '9999/12/31') AND IFNULL(`Hall`.`news_end_date_1`, NOW())) AS `Hall__news_flg_1`, (NOW() BETWEEN IFNULL(`Hall`.`news_start_date_2`, '9999/12/31') AND IFNULL(`Hall`.`news_end_date_2`, NOW())) AS `Hall__news_flg_2` FROM `pachiseven`.`halls` AS `Hall` WHERE `Hall`.`del_flg` = 0 AND `Hall`.`status` = 0 AND IFNULL(`Hall`.`start_date`, NOW()) <= NOW() ORDER BY ((SELECT CASE WHEN id IS NULL THEN 0 ELSE 1 END FROM handbills WHERE `handbills`.`del_flg` = 0 AND `handbills`.`status` = 0 AND `handbills`.`approval_status` = 0 AND (NOW() BETWEEN `handbills`.`start_date` AND `handbills`.`end_date`) AND `handbills`.`hall_id` = `Hall`.`id` ORDER BY `handbills`.`start_date` DESC LIMIT 1)) DESC, CASE `Hall`.`pref` WHEN '北海道' THEN 0 ELSE 1 END ASC, ((SELECT id FROM handbills WHERE `handbills`.`del_flg` = 0 AND `handbills`.`status` = 0 AND `handbills`.`approval_status` = 0 AND (NOW() BETWEEN `handbills`.`start_date` AND `handbills`.`end_date`) AND `handbills`.`hall_id` = `Hall`.`id` ORDER BY `handbills`.`start_date` DESC LIMIT 1)) DESC, (CASE WHEN `Hall`.`news_start_date_1` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_1` AND IFNULL(`Hall`.`news_end_date_1`, NOW())) THEN CASE WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN NULL ELSE `Hall`.`news_start_date_2` END WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN `Hall`.`news_start_date_1` ELSE IF(`Hall`.`news_start_date_1` >= `Hall`.`news_start_date_2`, `Hall`.`news_start_date_1`, `Hall`.`news_start_date_2`) END) DESC, `Hall`.`user_flg` DESC, `Hall`.`id` DESC LIMIT 555326
3SELECT `Hall`.`id`, `Hall`.`name`, `Hall`.`hall_pic`, `Hall`.`memo`, `Hall`.`bussiness_hours`, `Hall`.`news_1`, `Hall`.`news_start_date_1`, `Hall`.`news_url_1`, `Hall`.`news_date_display_1`, `Hall`.`news_2`, `Hall`.`news_start_date_2`, `Hall`.`news_url_2`, `Hall`.`news_date_display_2`, `Hall`.`user_flg`, `Hall`.`line_qr`, `Hall`.`line_button`, ((SELECT id FROM handbills WHERE `handbills`.`del_flg` = 0 AND `handbills`.`status` = 0 AND `handbills`.`approval_status` = 0 AND (NOW() BETWEEN `handbills`.`start_date` AND `handbills`.`end_date`) AND `handbills`.`hall_id` = `Hall`.`id` ORDER BY `handbills`.`start_date` DESC LIMIT 1)) AS `Hall__handbill_flg`, (CONCAT(`Hall`.`pref`, `Hall`.`city`, `Hall`.`address`)) AS `Hall__full_address`, (CASE WHEN `Hall`.`news_start_date_1` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_1` AND IFNULL(`Hall`.`news_end_date_1`, NOW())) THEN CASE WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN NULL ELSE `Hall`.`news_start_date_2` END WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN `Hall`.`news_start_date_1` ELSE IF(`Hall`.`news_start_date_1` >= `Hall`.`news_start_date_2`, `Hall`.`news_start_date_1`, `Hall`.`news_start_date_2`) END) AS `Hall__news_date`, (CASE WHEN `Hall`.`news_start_date_1` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_1` AND IFNULL(`Hall`.`news_end_date_1`, NOW())) THEN CASE WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN NULL ELSE `Hall`.`news_2` END WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN `Hall`.`news_1` ELSE IF(`Hall`.`news_start_date_1` >= `Hall`.`news_start_date_2`, `Hall`.`news_1`, `Hall`.`news_2`) END) AS `Hall__news_contents`, (NOW() BETWEEN IFNULL(`Hall`.`news_start_date_1`, '9999/12/31') AND IFNULL(`Hall`.`news_end_date_1`, NOW())) AS `Hall__news_flg_1`, (NOW() BETWEEN IFNULL(`Hall`.`news_start_date_2`, '9999/12/31') AND IFNULL(`Hall`.`news_end_date_2`, NOW())) AS `Hall__news_flg_2` FROM `pachiseven`.`halls` AS `Hall` WHERE `Hall`.`del_flg` = 0 AND `Hall`.`status` = 0 AND IFNULL(`Hall`.`start_date`, NOW()) <= NOW() AND `Hall`.`pref` = '北海道' ORDER BY ((SELECT id FROM handbills WHERE `handbills`.`del_flg` = 0 AND `handbills`.`status` = 0 AND `handbills`.`approval_status` = 0 AND (NOW() BETWEEN `handbills`.`start_date` AND `handbills`.`end_date`) AND `handbills`.`hall_id` = `Hall`.`id` ORDER BY `handbills`.`start_date` DESC LIMIT 1)) DESC, (CASE WHEN `Hall`.`news_start_date_1` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_1` AND IFNULL(`Hall`.`news_end_date_1`, NOW())) THEN CASE WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN NULL ELSE `Hall`.`news_start_date_2` END WHEN `Hall`.`news_start_date_2` IS NULL OR (NOW() NOT BETWEEN `Hall`.`news_start_date_2` AND IFNULL(`Hall`.`news_end_date_2`, NOW())) THEN `Hall`.`news_start_date_1` ELSE IF(`Hall`.`news_start_date_1` >= `Hall`.`news_start_date_2`, `Hall`.`news_start_date_1`, `Hall`.`news_start_date_2`) END) DESC, `Hall`.`user_flg` DESC, `Hall`.`id` DESC, (IF(CONCAT(`Hall`.`pref`, `Hall`.`city`) LIKE '北海道%', 1, 2 )) ASC, `Hall`.`id` DESC LIMIT 55558
4SELECT COUNT(*) AS `count` FROM `pachiseven`.`halls` AS `Hall` WHERE `Hall`.`del_flg` = 0 AND `Hall`.`status` = 0 AND IFNULL(`Hall`.`start_date`, NOW()) <= NOW() AND `Hall`.`pref` = '北海道' LIMIT 51127
5 SELECT Banner.id, type, area_no, rate, title, image, link_url, disp_mark FROM `banners` as Banner WHERE 1 and (type = 3 OR (type = 1 and Banner.id < 1000)) 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 14143
6 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() 14142
7SELECT `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` = 3) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (1, 0) ORDER BY `Banner`.`pref_id` DESC111
8SELECT `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` = 3) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (1, 0) ORDER BY `Banner`.`pref_id` DESC111
9SELECT `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 1001
10SELECT `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 1111
11SELECT `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` ASC332
(productReplica) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)