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

  1. パチセブントップ
  2. パチ7ホール取材

パチ7ホール取材

取材検索

都道府県から探す

九州・沖縄

中国

四国

関西

北陸・甲信越

東海

北海道

東北

関東




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

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

パチスロ新台情報

パチンコ新台情報

(staging) 25 queries took 152 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'h3bv13j4coh1k850glk7t84p50ju9bqa' LIMIT 1004
2SELECT `ArticleCategory`.`id`, `ArticleCategory`.`name` FROM `pachiseven`.`article_categories` AS `ArticleCategory` WHERE `ArticleCategory`.`type` = 2 AND `ArticleCategory`.`kind_id` = 11 AND `ArticleCategory`.`del_flg` = 0 AND EXISTS (SELECT * FROM articles WHERE `articles`.`del_flg` = 0 AND `articles`.`status` = 0 AND NOW() BETWEEN `articles`.`start_date` AND IFNULL(`articles`.`end_date`, NOW()) AND `ArticleCategory`.`id` = `articles`.`category_id` and `articles`.`type` = 2) ORDER BY `ArticleCategory`.`order` asc9925
3SELECT `Article`.`id`, `Article`.`type`, `Article`.`parent_article_id`, `Article`.`category_id`, `Article`.`writer_id`, `Article`.`article_footer_id`, `Article`.`title`, `Article`.`title_tag`, `Article`.`canonical_tag`, `Article`.`explanation`, `Article`.`image`, `Article`.`start_date`, `Article`.`end_date`, `Article`.`coverage_store_disp_flg`, `Article`.`login_flg`, `Article`.`comment_flg`, `Article`.`vote_flg`, `Article`.`vote_button_title`, `Article`.`yell_flg`, `Article`.`public_date`, `Article`.`status`, `Article`.`created_by`, `Article`.`created`, `Article`.`modified_by`, `Article`.`modified`, `Article`.`del_flg`, ((SELECT COUNT(*) FROM article_votes WHERE `Article`.`id` = `article_votes`.`article_id` AND `article_votes`.`del_flg` = 0)) AS `Article__vote_count`, ((SELECT COUNT(*) FROM article_yells WHERE `Article`.`id` = `article_yells`.`article_id` AND `article_yells`.`del_flg` = 0)) AS `Article__yell_count`, `ArticleCategory`.`id`, `ArticleCategory`.`type`, `ArticleCategory`.`kind_id`, `ArticleCategory`.`filter_id`, `ArticleCategory`.`name`, `ArticleCategory`.`color`, `ArticleCategory`.`image_1`, `ArticleCategory`.`image_2`, `ArticleCategory`.`explanation`, `ArticleCategory`.`order`, `ArticleCategory`.`main_writer_id`, `ArticleCategory`.`writer_name_1`, `ArticleCategory`.`writer_memo_1`, `ArticleCategory`.`writer_image_1`, `ArticleCategory`.`writer_name_2`, `ArticleCategory`.`writer_memo_2`, `ArticleCategory`.`writer_image_2`, `ArticleCategory`.`writer_name_3`, `ArticleCategory`.`writer_memo_3`, `ArticleCategory`.`writer_image_3`, `ArticleCategory`.`calendar_icon`, `ArticleCategory`.`created_by`, `ArticleCategory`.`created`, `ArticleCategory`.`modified_by`, `ArticleCategory`.`modified`, `ArticleCategory`.`del_flg`, `ArticleWriter`.`id`, `ArticleWriter`.`name`, `ArticleWriter`.`memo`, `ArticleWriter`.`image`, `ArticleWriter`.`main_contents`, `ArticleWriter`.`system_user_id`, `ArticleWriter`.`mail_address`, `ArticleWriter`.`status`, `ArticleWriter`.`link_url_1`, `ArticleWriter`.`link_url_2`, `ArticleWriter`.`link_url_3`, `ArticleWriter`.`link_url_4`, `ArticleWriter`.`created_by`, `ArticleWriter`.`created`, `ArticleWriter`.`modified_by`, `ArticleWriter`.`modified`, `ArticleWriter`.`del_flg` FROM `pachiseven`.`articles` AS `Article` LEFT JOIN `pachiseven`.`article_categories` AS `ArticleCategory` ON (`Article`.`category_id` = `ArticleCategory`.`id` AND `ArticleCategory`.`del_flg` = 0) LEFT JOIN `pachiseven`.`article_writers` AS `ArticleWriter` ON (`Article`.`writer_id` = `ArticleWriter`.`id` AND `ArticleWriter`.`del_flg` = 0) WHERE `Article`.`del_flg` = 0 AND `Article`.`status` = 0 AND NOW() BETWEEN `Article`.`start_date` AND IFNULL(`Article`.`end_date`, NOW()) AND `Article`.`type` = 2 AND `ArticleCategory`.`type` = 2 AND `ArticleCategory`.`kind_id` = (11) AND NOT (`Article`.`parent_article_id` IS NULL) ORDER BY `Article`.`public_date` desc, `Article`.`start_date` desc, `Article`.`id` desc LIMIT 66626
4SELECT ArticleReportHall.article_id, Hall.id, Hall.name FROM article_report_halls ArticleReportHall INNER JOIN halls Hall ON (ArticleReportHall.hall_id = Hall.id AND ArticleReportHall.del_flg = 0 AND Hall.del_flg = 0 )WHERE ArticleReportHall.article_id IN (7542,7530,7528,7523,7536,7509)661
5select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 7542002
6select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 7542002
7select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 7530001
8select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 7530004
9select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 7528001
10select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 7528001
11select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 7523001
12select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 7523001
13select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 7536001
14select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 7536001
15select ArticleCategory.* from article_categories as ArticleCategory, article_writer_category_relashionships as awcr where awcr.category_id is not NULL and ArticleCategory.id = awcr.category_id and awcr.article_id = 7509001
16select ArticleWriter.* from article_writers as ArticleWriter, article_writer_category_relashionships as awcr where awcr.writer_id is not NULL and ArticleWriter.id = awcr.writer_id and awcr.article_id = 7509001
17SELECT `ArticleCategory`.`id`, `ArticleCategory`.`name`, `ArticleCategory`.`image_1`, MAX(`Article`.`start_date`) AS `sort_date`, MAX(`Article`.`id`) AS `sort_id`, `ArticleCategory`.`order` AS `sort_order` FROM `pachiseven`.`articles` AS `Article` LEFT JOIN `pachiseven`.`article_categories` AS `ArticleCategory` ON (`Article`.`category_id` = `ArticleCategory`.`id` AND `ArticleCategory`.`del_flg` = 0) WHERE `Article`.`type` = 2 AND `Article`.`del_flg` = 0 AND `Article`.`status` = 0 AND `ArticleCategory`.`type` = 2 AND `ArticleCategory`.`kind_id` = 11 AND NOW() BETWEEN `Article`.`start_date` AND IFNULL(`Article`.`end_date`, NOW()) GROUP BY `ArticleCategory`.`id`, `ArticleCategory`.`name`, `ArticleCategory`.`image_2` ORDER BY `sort_order` asc LIMIT 88827
18SELECT `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`, `ColumnEvent`.`event_title`, `ColumnEventV2`.`event_title` FROM `pachiseven`.`columns` AS `Column` 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") AND `Column`.`column_category_id` = 9 AND `Column`.`column_event_id` = 0 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 50028
19SELECT `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` = 17) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (1, 0) ORDER BY `Banner`.`pref_id` DESC116
20SELECT `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` = 17) OR (((`type` = 1) AND (`Banner`.`id` < 1000)))) AND `area_no` = 121 AND `Banner`.`pref_id` IN (1, 0) ORDER BY `Banner`.`pref_id` DESC112
21 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 (area_no NOT BETWEEN 9 AND 12) 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 10102
22 SELECT * FROM `banner_imps` WHERE 1 and banner_id in (1,2,3,4,5,6,7,8,9,10) and created = CURRENT_DATE() 10108
23SELECT `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
24SELECT `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 1114
25SELECT `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` ASC331
(productReplica) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)