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

  1. パチセブントップ
  2. コミュニティ
  3. パチ7自由帳トップ|ブログコミュニティ
  4. コラム(ブログ)一覧

ヒコシキさんのコラム一覧

ヒコシキ
ポイント
63098pt
スロッコエムブレム :
面白い獲得数
0件
コメント総数
19件
コラム総数
3件
年齢
40代
エリア

神奈川県

栃木県

愛知県

お気に入りホール
パチンコパチスロ歴
20 年
初めて打った機種
覚えてない
好きなメーカー
ユニバ
歴代好きな機種(P)
綱取物語・ゴールデンバレリーナ
歴代好きな機種(S)
大花火

パチ7の非公式アカウントです!

コラム一覧

パチ7自由帳トップに戻る

パチ7自由帳月間賞│特集記事



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

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

パチスロ新台情報

パチンコ新台情報

(staging) 15 queries took 46 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'c9i2vh1fhao04a4letard88loniafl5m' LIMIT 1001
2SELECT `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` ASC15151
3SELECT `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`.`user_id` = 30 ORDER BY `Column`.`start_date` DESC LIMIT 153317
4SELECT COUNT(*) AS `count` 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`.`user_id` = 30118
5SELECT `UserPoint`.`id`, `UserPoint`.`user_id`, `UserPoint`.`point`, `UserPoint`.`get_point`, `UserPoint`.`use_point`, `UserPoint`.`created_by`, `UserPoint`.`created`, `UserPoint`.`modified_by`, `UserPoint`.`modified`, `UserPoint`.`modified_reason` FROM `pachiseven`.`user_points` AS `UserPoint` WHERE `user_id` = 30 LIMIT 1112
6SELECT COUNT(*) AS `count` 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`.`user_id` = 30118
7SELECT COUNT(*) AS `count` FROM `pachiseven`.`column_comments` AS `ColumnComment` LEFT JOIN `pachiseven`.`columns` AS `Column` ON (`ColumnComment`.`column_id` = `Column`.`id` AND `Column`.`del_flg` = 0 AND `Column`.`status` = 0) WHERE `ColumnComment`.`del_flg` = 0 AND `Column`.`user_id` = 30111
8SELECT COUNT(*) AS `count` FROM `pachiseven`.`column_votes` AS `ColumnVote` LEFT JOIN `pachiseven`.`columns` AS `Column` ON (`ColumnVote`.`column_id` = `Column`.`id` AND `Column`.`del_flg` = 0 AND `Column`.`status` = 0) WHERE `ColumnVote`.`del_flg` = 0 AND `Column`.`user_id` = 30111
9SELECT `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 (1, 0) ORDER BY `Banner`.`pref_id` DESC111
10SELECT `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 (1, 0) ORDER BY `Banner`.`pref_id` DESC111
11 SELECT Banner.id, type, area_no, rate, title, image, link_url, disp_mark FROM `banners` as Banner WHERE 1 and (type = 15 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 14141
12 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() 14141
13SELECT `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
14SELECT `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 1001
15SELECT `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) 4 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment` FROM `pachiseven`.`users` AS `User` WHERE `User`.`id` = 30 AND `User`.`del_flg` = 0 AND `User`.`status` = 0 111
2SELECT `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment` FROM `pachiseven`.`users` AS `User` WHERE `User`.`id` = 30 AND `User`.`del_flg` = 0 AND `User`.`status` = 0 111
3SELECT `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment` FROM `pachiseven`.`users` AS `User` WHERE `User`.`id` = 30 AND `User`.`del_flg` = 0 AND `User`.`status` = 0 111
4SELECT `User`.`id`, `User`.`mail`, `User`.`password`, `User`.`nickname`, `User`.`birthday`, `User`.`age_group`, `User`.`sex`, `User`.`play_type`, `User`.`my_area_pref_1`, `User`.`my_area_city_1`, `User`.`my_area_pref_2`, `User`.`my_area_city_2`, `User`.`my_area_pref_3`, `User`.`my_area_city_3`, `User`.`history_year`, `User`.`profile_img`, `User`.`profile_comment`, `User`.`income_flg`, `User`.`mail_magazine_flg`, `User`.`push_flg`, `User`.`reset_date`, `User`.`mail_change`, `User`.`mail_change_date`, `User`.`withdrawal_reason`, `User`.`fav_hall_id`, `User`.`fav_maker`, `User`.`fav_machine_pachi_id`, `User`.`fav_machine_slot_id`, `User`.`fav_succ_pachi`, `User`.`fav_succ_slot`, `User`.`fst_time_machine`, `User`.`disp_point`, `User`.`disp_emblem`, `User`.`disp_age_group`, `User`.`disp_sex`, `User`.`disp_my_area`, `User`.`disp_play_type`, `User`.`disp_history_year`, `User`.`disp_fav_hall`, `User`.`disp_fav_maker`, `User`.`disp_fav_machine`, `User`.`disp_fav_succ_pachi`, `User`.`disp_fav_succ_slot`, `User`.`disp_fst_time_machine`, `User`.`created`, `User`.`modified`, `User`.`account_type`, `User`.`status`, `User`.`del_flg`, (CONCAT(`User`.`my_area_pref_1`, `User`.`my_area_city_1`)) AS `User__myArea1`, (CONCAT(`User`.`my_area_pref_2`, `User`.`my_area_city_2`)) AS `User__myArea2`, (CONCAT(`User`.`my_area_pref_3`, `User`.`my_area_city_3`)) AS `User__myArea3` FROM `pachiseven`.`users` AS `User` WHERE `User`.`id` = 30 AND `User`.`del_flg` = 0 LIMIT 1111
(slot2Staging) 1 query took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `P7SResInfo`.`p7_slot_info_id`, `P7SResInfo`.`emblem_path`, `P7SPlayData`.`user_id`, `P7SPlayData`.`achieve_per` FROM `pachiseven_slot2`.`p7_slot_res_infos` AS `P7SResInfo` LEFT JOIN `pachiseven_slot2`.`p7_slot_play_data` AS `P7SPlayData` ON (`P7SPlayData`.`p7_slot_info_id` = `P7SResInfo`.`id` AND `P7SPlayData`.`user_id` = 30 AND `P7SPlayData`.`achieve_per` >= 100 AND `P7SPlayData`.`del_flg` = 0) WHERE `P7SPlayData`.`user_id` = 30 AND `P7SPlayData`.`achieve_per` >= 100 AND `P7SResInfo`.`del_flg` = 0 ORDER BY `P7SResInfo`.`p7_slot_info_id` asc003