パチンコ&パチスロ機種解析・店舗情報【パチ7】

Notice (8): Constant REDIS_PORT already defined [APP/Config/app_config.php, line 36]

    define('REDIS_READER', 'dev-pachi7-ro.6jrtue.ng.0001.apne1.cache.amazonaws.com');
    define('REDIS_PORT', '6379');
    define('REDIS_PORT', '6379');

$args = array(
	(int) 0 => 'app_config'
)
$count = (int) 1
$included = (int) 0
$arg = 'app_config'

define - [internal], line ??
include_once - APP/Config/app_config.php, line 36
config - CORE/Cake/basics.php, line 52
include - APP/Config/bootstrap.php, line 140
Configure::bootstrap() - CORE/Cake/Core/Configure.php, line 94
include - CORE/Cake/bootstrap.php, line 171
[main] - ROOT/webroot/index.php, line 92

パチンコ＆パチスロ情報満載！　パチ７おすすめコンテンツ

パチンコ＆パチスロ情報満載！
パチ７おすすめコンテンツ

pachi_seven に関するツイート

(product) 39 queries took 195 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = '265qj32lamjd483abdq0helbuenjk1hb' 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	9
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	1
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 (10, 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 (10, 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	6
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	53
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(7452)) 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(7452)) ASC, `Handbill`.`id` ASC LIMIT 10	0	0	87
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

(product) 39 queries took 195 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created_at` FROM `pachiseven`.`cake_sessions` AS `Session` WHERE `id` = '265qj32lamjd483abdq0helbuenjk1hb' LIMIT 1

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

SELECT `SortTable`.`sort_no`, `SortTable`.`target_id` FROM `pachiseven`.`sort_tables` AS `SortTable` WHERE `table_id` = 1 ORDER BY `sort_no` asc

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

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

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

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

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

SELECT * FROM site_content_imps WHERE site_id in (1043,1014,1035,1025,1042) AND created = CURRENT_DATE()

UPDATE site_content_imps SET imp = imp + 1 WHERE site_id in (1043,1014,1035,1025,1042) AND created = CURRENT_DATE()

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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()

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 (10, 0) ORDER BY `Banner`.`pref_id` DESC

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

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

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(7452)) 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(7452)) ASC, `Handbill`.`id` ASC LIMIT 10

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

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

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

新着記事

パチンコ＆パチスロ情報満載！ パチ７おすすめコンテンツ

パチンコ＆パチスロ情報満載！パチ７おすすめコンテンツ

パチンコ＆パチスロ情報満載！　パチ７おすすめコンテンツ

パチンコ＆パチスロ情報満載！
パチ７おすすめコンテンツ