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

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

TEST|パチンコ・パチスロ ブログコミュニティ

初めての投稿 | コラム

TEST

プロフィール画像
すあまさん
投稿日:2023/06/16 19:49

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

0

ログイン・会員登録してコメントする

すあまさんの
前のコラム コラム一覧 次のコラム

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

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

パチ7自由帳ランキング

ランキングはありません。



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

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

パチスロ新台情報

パチンコ新台情報

(staging) 18 queries took 456 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = 'v0qa8hji3tf8th56evbdaiogh49omq23' LIMIT 10011
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` ASC151513
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 ((((SELECT COUNT(*) FROM column_votes WHERE `Column`.`id` = `column_votes`.`column_id` AND `column_votes`.`del_flg` = 0)) >= 20) OR (`Column`.`pv_cnt` >= 1000)) ORDER BY RAND() ASC LIMIT 555320
4SELECT `ColumnImage`.`id`, `ColumnImage`.`column_id`, `ColumnImage`.`img`, `ColumnImage`.`img_tag`, `ColumnImage`.`img_no`, `ColumnImage`.`user_id`, `ColumnImage`.`created`, `ColumnImage`.`modified_by`, `ColumnImage`.`modified`, `ColumnImage`.`del_flg` FROM `pachiseven`.`column_images` AS `ColumnImage` WHERE `del_flg` = 0 AND `ColumnImage`.`column_id` IN (7581, 7860, 9981, 2017, 6835) ORDER BY `img_no` ASC 005
5SELECT `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`.`id` = 13467 LIMIT 11111
6SELECT `ColumnImage`.`id`, `ColumnImage`.`column_id`, `ColumnImage`.`img`, `ColumnImage`.`img_tag`, `ColumnImage`.`img_no`, `ColumnImage`.`user_id`, `ColumnImage`.`created`, `ColumnImage`.`modified_by`, `ColumnImage`.`modified`, `ColumnImage`.`del_flg` FROM `pachiseven`.`column_images` AS `ColumnImage` WHERE `del_flg` = 0 AND `ColumnImage`.`column_id` = (13467) ORDER BY `img_no` ASC 111
7SELECT 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`.`user_id` = 0 AND `ColumnVote`.`column_id` = 13467 AND `ColumnVote`.`del_flg` = 0112
8SELECT `Column`.`id` FROM `pachiseven`.`columns` AS `Column` WHERE `Column`.`status` = 0 AND `Column`.`del_flg` = 0 AND DATE_FORMAT(`Column`.`start_date`, "%Y") < 9999 AND `Column`.`user_id` = 141 ORDER BY `Column`.`start_date` DESC2212
9UPDATE columns SET pv_cnt = (pv_cnt + 1) WHERE id = 13467114
10SELECT `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") 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 100045
11SELECT `ColumnComment`.`id`, `ColumnComment`.`column_id`, `ColumnComment`.`comment`, `ColumnComment`.`image`, `ColumnComment`.`status`, `ColumnComment`.`user_id`, `ColumnComment`.`res_user_id`, `ColumnComment`.`created`, `ColumnComment`.`modified_by`, `ColumnComment`.`modified`, `ColumnComment`.`del_flg`, `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` 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`.`column_id` = 13467 AND `ColumnComment`.`status` = 0 AND `ColumnComment`.`del_flg` = 0 ORDER BY `ColumnComment`.`created` DESC LIMIT 10004
12SELECT `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` DESC1113
13SELECT `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` DESC112
14 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
15 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
16SELECT `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
17SELECT `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
18SELECT `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` ASC339
(productReplica) 6 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment` FROM `pachiseven`.`users` AS `User` WHERE `User`.`id` = 15901 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` = 14608 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` = 15765 AND `User`.`del_flg` = 0 AND `User`.`status` = 0 111
4SELECT `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment` FROM `pachiseven`.`users` AS `User` WHERE `User`.`id` = 5984 AND `User`.`del_flg` = 0 AND `User`.`status` = 0 111
5SELECT `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment` FROM `pachiseven`.`users` AS `User` WHERE `User`.`id` = 14771 AND `User`.`del_flg` = 0 AND `User`.`status` = 0 119
6SELECT `User`.`id`, `User`.`nickname`, `User`.`profile_img`, `User`.`profile_comment` FROM `pachiseven`.`users` AS `User` WHERE `User`.`id` = 141 AND `User`.`del_flg` = 0 AND `User`.`status` = 0 111