10
Console |
727.102 ms
Load Time |
199 Queries
Database |
4.47 MB
Memory Used |
85 Files
Included |
249 Config
items loaded |
0 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
3Logs |
0 Errors |
0 Memory |
7 Speed |
speed | 8.240 msFuel\Core\Profiler::init Start |
speed | 12.207 msFuel\Core\Fuel::init End |
speed | 13.155 msFuel\Core\Uri::__construct Start |
speed | 13.256 msFuel\Core\Uri::__construct End |
log | Fuel\Core\Request::__construct - Creating a new main Request with URI = "" |
speed | 18.786 msFuel\Core\Request::execute: Start of |
log | Fuel\Core\Request::execute - Called |
log | Fuel\Core\Request::execute - Setting main Request |
speed | 130.883 msFuel\Core\Request::execute: End of |
speed | 648.681 msEnd of Fuel Execution |
727.102 msLoad Time |
90 s Max Execution Time |
8.240 msFuel\Core\Profiler::init Start |
12.207 msFuel\Core\Fuel::init End |
13.155 msFuel\Core\Uri::__construct Start |
13.256 msFuel\Core\Uri::__construct End |
18.786 msFuel\Core\Request::execute: Start of |
130.883 msFuel\Core\Request::execute: End of |
648.681 msEnd of Fuel Execution |
199Total Queries |
69.358 ms Total Time |
0 Duplicates |
SELECT no,
bcategory_id,
(CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 3Connection name: default Speed: 0.775 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1452File: APPPATH/classes/controller/front.php, line 61File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT t1.no
,t1.bcategory_id
,t1.category_id
,t2.category_name
,t1.title
,DATE_FORMAT(t1.starttime, '%Y-%m-%d') AS post_date
,t1.sec0_photo
,NULL AS basicinfo_url
,t1.subtitle
FROM cmsdetail t1
INNER JOIN category t2
ON t1.category_id = t2.category_id
WHERE t2.bcategory_id IN (1)
AND t1.starttime <= NOW()
AND t1.endtime >= NOW()
ORDER BY t1.starttime DESCConnection name: default Speed: 0.900 ms Query analysis: · Query: SIMPLE on t2 · Type: ALL · Rows: 31 (Using where; Using temporary; Using filesort) · Query: SIMPLE on t1 · Type: ALL · Rows: 119 (Using where; Using join buffer (Block Nested Loop)) Call trace for this query:File: APPPATH/classes/model/front.php, line 362File: APPPATH/classes/model/cmsinfo.php, line 935File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '291'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.478 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '288'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.343 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '286'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.334 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '283'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.401 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '282'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.335 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '277'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.333 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '276'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.326 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '275'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.338 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '274'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.326 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '271'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.345 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '268'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '267'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.338 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '264'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '263'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.331 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '261'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.328 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '259'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.368 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '257'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.327 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 73File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT t1.no
,t1.bcategory_id
,t1.category_id
,t2.category_name
,t1.title
,DATE_FORMAT(t1.starttime, '%Y-%m-%d') AS post_date
,t1.sec0_photo
,NULL AS basicinfo_url
,t1.subtitle
FROM cmsdetail t1
INNER JOIN category t2
ON t1.category_id = t2.category_id
WHERE t2.bcategory_id IN (2)
AND t1.starttime <= NOW()
AND t1.endtime >= NOW()
ORDER BY t1.starttime DESCConnection name: default Speed: 0.753 ms Query analysis: · Query: SIMPLE on t2 · Type: ALL · Rows: 31 (Using where; Using temporary; Using filesort) · Query: SIMPLE on t1 · Type: ALL · Rows: 119 (Using where; Using join buffer (Block Nested Loop)) Call trace for this query:File: APPPATH/classes/model/front.php, line 362File: APPPATH/classes/model/cmsinfo.php, line 935File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '316'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.366 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '314'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.326 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '313'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.349 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '311'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '312'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.353 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '294'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '292'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '285'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.322 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '281'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.352 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '272'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.330 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '270'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.345 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '269'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.343 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '265'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.349 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '262'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '260'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.350 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '258'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.357 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '256'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.349 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '252'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.321 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '250'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '247'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '245'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.349 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '242'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '240'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '235'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '233'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.349 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '231'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.328 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '230'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.349 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '228'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.322 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '225'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '224'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.332 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '222'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.347 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '219'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.326 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '216'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.350 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '215'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '211'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.350 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '210'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.330 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '207'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.344 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '204'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '192'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.349 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '191'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.322 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '190'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.344 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '187'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '186'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.364 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '185'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.327 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '184'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.350 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '183'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 74File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT t1.no
,t1.bcategory_id
,t1.category_id
,t2.category_name
,t1.title
,DATE_FORMAT(t1.starttime, '%Y-%m-%d') AS post_date
,t1.sec0_photo
,NULL AS basicinfo_url
,t1.subtitle
FROM cmsdetail t1
INNER JOIN category t2
ON t1.category_id = t2.category_id
WHERE t2.bcategory_id IN (3)
AND t1.starttime <= NOW()
AND t1.endtime >= NOW()
ORDER BY t1.starttime DESCConnection name: default Speed: 0.782 ms Query analysis: · Query: SIMPLE on t2 · Type: ALL · Rows: 31 (Using where; Using temporary; Using filesort) · Query: SIMPLE on t1 · Type: ALL · Rows: 119 (Using where; Using join buffer (Block Nested Loop)) Call trace for this query:File: APPPATH/classes/model/front.php, line 362File: APPPATH/classes/model/cmsinfo.php, line 935File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '287'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.365 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '284'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.330 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '280'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.334 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '279'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '255'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.326 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '253'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '251'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '249'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.328 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '248'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '246'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '243'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.326 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '241'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.321 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '239'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.327 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '238'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.321 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '237'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '236'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.321 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '232'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '229'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '227'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.328 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '223'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '221'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.326 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '220'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.322 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '218'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.334 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '214'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '213'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '212'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '205'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.330 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '202'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '200'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '199'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.326 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '197'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '196'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.322 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '195'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '194'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.322 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '193'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.327 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 75File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT t1.no
,t1.bcategory_id
,t1.category_id
,t2.category_name
,t1.title
,DATE_FORMAT(t1.starttime, '%Y-%m-%d') AS post_date
,t1.sec0_photo
,NULL AS basicinfo_url
,t1.subtitle
FROM cmsdetail t1
INNER JOIN category t2
ON t1.category_id = t2.category_id
WHERE t2.bcategory_id IN (8)
AND t1.starttime <= NOW()
AND t1.endtime >= NOW()
ORDER BY t1.starttime DESCConnection name: default Speed: 0.599 ms Query analysis: · Query: SIMPLE on t2 · Type: ALL · Rows: 31 (Using where; Using temporary; Using filesort) · Query: SIMPLE on t1 · Type: ALL · Rows: 119 (Using where; Using join buffer (Block Nested Loop)) Call trace for this query:File: APPPATH/classes/model/front.php, line 362File: APPPATH/classes/model/cmsinfo.php, line 935File: APPPATH/classes/controller/front.php, line 76File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '266'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 76File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '203'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.354 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 76File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT t1.no
,t1.bcategory_id
,t1.category_id
,t2.category_name
,t1.title
,DATE_FORMAT(t1.starttime, '%Y-%m-%d') AS post_date
,t1.sec0_photo
,NULL AS basicinfo_url
,t1.subtitle
FROM cmsdetail t1
INNER JOIN category t2
ON t1.category_id = t2.category_id
WHERE t2.bcategory_id IN (4)
AND t1.starttime <= NOW()
AND t1.endtime >= NOW()
ORDER BY t1.starttime DESCConnection name: default Speed: 0.583 ms Query analysis: · Query: SIMPLE on t2 · Type: ALL · Rows: 31 (Using where; Using temporary; Using filesort) · Query: SIMPLE on t1 · Type: ALL · Rows: 119 (Using where; Using join buffer (Block Nested Loop)) Call trace for this query:File: APPPATH/classes/model/front.php, line 362File: APPPATH/classes/model/cmsinfo.php, line 935File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '315'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '310'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.355 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '309'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '308'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.358 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '307'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.325 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '306'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.354 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '305'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.345 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '304'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '293'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.327 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '217'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.351 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '198'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '158'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.348 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 77File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT t1.no
,t1.bcategory_id
,t1.category_id
,t2.category_name
,t1.title
,DATE_FORMAT(t1.starttime, '%Y-%m-%d') AS post_date
,t1.basicinfo_url
,t1.photo1
FROM cmsbusinessdetail t1
INNER JOIN category t2
ON t1.category_id = t2.category_id
WHERE t2.bcategory_id IN (5)
AND t1.starttime <= NOW()
AND t1.endtime >= NOW()
ORDER BY t1.starttime DESCConnection name: default Speed: 0.919 ms Query analysis: · Query: SIMPLE on t2 · Type: ALL · Rows: 31 (Using where; Using temporary; Using filesort) · Query: SIMPLE on t1 · Type: ALL · Rows: 80 (Using where; Using join buffer (Block Nested Loop)) Call trace for this query:File: APPPATH/classes/model/front.php, line 362File: APPPATH/classes/model/cmsinfo.php, line 935File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '121'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.406 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '120'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.330 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '119'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '117'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.321 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '118'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '57'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.319 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '116'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.345 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '115'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '114'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.343 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '113'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '112'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.344 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '111'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '110'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.351 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '109'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '108'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.339 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '107'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '106'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.345 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '105'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '104'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.338 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '68'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.316 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '46'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.340 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '70'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '48'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.323 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '72'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '50'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.314 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '74'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.330 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '52'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.316 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '76'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '54'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.313 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '78'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '56'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.314 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '80'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.319 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '58'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '82'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '60'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.314 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '84'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.336 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '62'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.316 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '64'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.319 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '42'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.314 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '66'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '44'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.316 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '87'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '89'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.337 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '91'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.321 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '93'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '95'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.332 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '97'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.321 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '99'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.333 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '101'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '103'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '67'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.320 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '45'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.345 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '69'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '47'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '71'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '49'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.340 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '73'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '51'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '75'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.319 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '53'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.341 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '77'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '55'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.346 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '79'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '81'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.362 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '59'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '83'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '61'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '85'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.353 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '63'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.316 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '65'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.357 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '43'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.320 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '86'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.347 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '88'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.343 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '90'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '92'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.318 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '94'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.339 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '96'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.317 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '98'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.344 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '100'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.337 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT (CASE WHEN NULLIF(sec0_photo,'') IS NOT NULL THEN sec0_photo
ELSE(CASE WHEN NULLIF(sec1_photo,'') IS NOT NULL THEN sec1_photo
ELSE(CASE WHEN NULLIF(sec2_photo,'') IS NOT NULL THEN sec2_photo ELSE sec3_photo END)
END)
END) AS image_name
FROM cmsdetail
WHERE no = '102'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1211File: APPPATH/classes/model/cmsinfo.php, line 947File: APPPATH/classes/controller/front.php, line 78File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
5Finder Paths |
85Total Files |
571.29 kB Total Size |
56.68 kB Largest |
Finder paths: |
/var/www/html/miyazaki/fuel/app/ |
/var/www/html/miyazaki/fuel/packages/pushnotifications/ |
/var/www/html/miyazaki/fuel/packages/orm/ |
/var/www/html/miyazaki/fuel/packages/auth/ |
/var/www/html/miyazaki/fuel/core/ |
Loaded files: |
2.97 kB /var/www/html/miyazaki/public/index.php |
9.32 kB /var/www/html/miyazaki/fuel/core/classes/autoloader.php |
1.12 kB /var/www/html/miyazaki/fuel/app/bootstrap.php |
16.15 kB /var/www/html/miyazaki/fuel/core/bootstrap.php |
13.27 kB /var/www/html/miyazaki/fuel/core/base.php |
183 bytes /var/www/html/miyazaki/fuel/vendor/autoload.php |
1.28 kB /var/www/html/miyazaki/fuel/vendor/composer/autoload_real.php |
12.17 kB /var/www/html/miyazaki/fuel/vendor/composer/ClassLoader.php |
413 bytes /var/www/html/miyazaki/fuel/vendor/composer/autoload_namespaces.php |
219 bytes /var/www/html/miyazaki/fuel/vendor/composer/autoload_psr4.php |
156 bytes /var/www/html/miyazaki/fuel/vendor/composer/autoload_classmap.php |
8.44 kB /var/www/html/miyazaki/fuel/core/classes/fuel.php |
5.80 kB /var/www/html/miyazaki/fuel/core/classes/config.php |
2.55 kB /var/www/html/miyazaki/fuel/core/classes/config/php.php |
4.83 kB /var/www/html/miyazaki/fuel/core/classes/config/file.php |
163 bytes /var/www/html/miyazaki/fuel/core/classes/config/interface.php |
12.37 kB /var/www/html/miyazaki/fuel/core/classes/finder.php |
32.61 kB /var/www/html/miyazaki/fuel/core/classes/arr.php |
1.49 kB /var/www/html/miyazaki/fuel/core/config/file.php |
10.55 kB /var/www/html/miyazaki/fuel/core/config/config.php |
11.13 kB /var/www/html/miyazaki/fuel/app/config/config.php |
10.73 kB /var/www/html/miyazaki/fuel/app/config/development/config.php |
13.80 kB /var/www/html/miyazaki/fuel/core/classes/input.php |
1.76 kB /var/www/html/miyazaki/fuel/core/classes/profiler.php |
2.46 kB /var/www/html/miyazaki/fuel/core/vendor/phpquickprofiler/console.php |
6.56 kB /var/www/html/miyazaki/fuel/core/vendor/phpquickprofiler/phpquickprofiler.php |
10.72 kB /var/www/html/miyazaki/fuel/core/classes/security.php |
1.75 kB /var/www/html/miyazaki/fuel/core/classes/event.php |
4.82 kB /var/www/html/miyazaki/fuel/core/classes/event/instance.php |
3.35 kB /var/www/html/miyazaki/fuel/core/classes/package.php |
2.35 kB /var/www/html/miyazaki/fuel/packages/auth/bootstrap.php |
2.01 kB /var/www/html/miyazaki/fuel/packages/orm/bootstrap.php |
124 bytes /var/www/html/miyazaki/fuel/packages/orm/config/orm.php |
1.00 kB /var/www/html/miyazaki/fuel/packages/pushnotifications/bootstrap.php |
3.92 kB /var/www/html/miyazaki/fuel/core/classes/module.php |
1.90 kB /var/www/html/miyazaki/fuel/packages/pushnotifications/config/pushnotification.php |
1.98 kB /var/www/html/miyazaki/fuel/app/config/pushnotification.php |
321 bytes /var/www/html/miyazaki/fuel/app/config/routes.php |
7.86 kB /var/www/html/miyazaki/fuel/core/classes/router.php |
5.05 kB /var/www/html/miyazaki/fuel/core/classes/route.php |
7.04 kB /var/www/html/miyazaki/fuel/core/classes/redis/db.php |
13.37 kB /var/www/html/miyazaki/fuel/core/classes/request.php |
8.35 kB /var/www/html/miyazaki/fuel/core/classes/uri.php |
5.91 kB /var/www/html/miyazaki/fuel/core/classes/log.php |
15.67 kB /var/www/html/miyazaki/fuel/vendor/monolog/monolog/src/Monolog/Logger.php |
2.90 kB /var/www/html/miyazaki/fuel/vendor/psr/log/Psr/Log/LoggerInterface.php |
2.13 kB /var/www/html/miyazaki/fuel/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php |
1.47 kB /var/www/html/miyazaki/fuel/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php |
3.80 kB /var/www/html/miyazaki/fuel/vendor/monolog/monolog/src/Monolog/Handler/AbstractHandler.php |
2.44 kB /var/www/html/miyazaki/fuel/vendor/monolog/monolog/src/Monolog/Handler/HandlerInterface.php |
2.84 kB /var/www/html/miyazaki/fuel/vendor/monolog/monolog/src/Monolog/Formatter/LineFormatter.php |
2.47 kB /var/www/html/miyazaki/fuel/vendor/monolog/monolog/src/Monolog/Formatter/NormalizerFormatter.php |
787 bytes /var/www/html/miyazaki/fuel/vendor/monolog/monolog/src/Monolog/Formatter/FormatterInterface.php |
12.06 kB /var/www/html/miyazaki/fuel/core/classes/inflector.php |
7.21 kB /var/www/html/miyazaki/fuel/core/classes/lang.php |
3.09 kB /var/www/html/miyazaki/fuel/core/classes/lang/php.php |
4.43 kB /var/www/html/miyazaki/fuel/core/classes/lang/file.php |
174 bytes /var/www/html/miyazaki/fuel/core/classes/lang/interface.php |
10.76 kB /var/www/html/miyazaki/fuel/core/classes/str.php |
19.80 kB /var/www/html/miyazaki/fuel/app/classes/controller/front.php |
1.49 kB /var/www/html/miyazaki/fuel/core/classes/controller.php |
56.68 kB /var/www/html/miyazaki/fuel/app/classes/model/cmsinfo.php |
10.58 kB /var/www/html/miyazaki/fuel/core/classes/db.php |
6.30 kB /var/www/html/miyazaki/fuel/core/classes/database/query.php |
23.04 kB /var/www/html/miyazaki/fuel/core/classes/database/connection.php |
1.59 kB /var/www/html/miyazaki/fuel/core/config/db.php |
160 bytes /var/www/html/miyazaki/fuel/app/config/db.php |
698 bytes /var/www/html/miyazaki/fuel/app/config/development/db.php |
13.35 kB /var/www/html/miyazaki/fuel/core/classes/database/pdo/connection.php |
1.29 kB /var/www/html/miyazaki/fuel/core/classes/database/result/cached.php |
7.38 kB /var/www/html/miyazaki/fuel/core/classes/database/result.php |
618 bytes /var/www/html/miyazaki/fuel/core/classes/sanitization.php |
11.48 kB /var/www/html/miyazaki/fuel/app/classes/model/front.php |
273 bytes /var/www/html/miyazaki/fuel/core/classes/model.php |
13.68 kB /var/www/html/miyazaki/fuel/core/classes/view.php |
8.35 kB /var/www/html/miyazaki/fuel/core/classes/response.php |
9.43 kB /var/www/html/miyazaki/fuel/app/views/front/index.php |
2.02 kB /var/www/html/miyazaki/public/includes/define.php |
1.96 kB /var/www/html/miyazaki/fuel/app/classes/controller/snslink.php |
8.46 kB /var/www/html/miyazaki/fuel/core/classes/error.php |
5.99 kB /var/www/html/miyazaki/fuel/core/classes/asset.php |
2.69 kB /var/www/html/miyazaki/fuel/core/config/asset.php |
13.94 kB /var/www/html/miyazaki/fuel/core/classes/asset/instance.php |
4.17 kB /var/www/html/miyazaki/public/includes/header.php |
9.38 kB /var/www/html/miyazaki/public/includes/footer.php |
249 Configuration items |
file |
› base_config |
null› › basedir |
null› › extensions |
null› › url |
null› › use_locks |
› › file_handlers |
› areas |
null› magic_file |
› chmod |
438› › files |
511› › folders |
http://104.198.84.95/base_url |
url_suffix |
falseindex_file |
trueprofiling |
profiling_paths |
/var/www/html/miyazaki/fuel/app/› APPPATH |
/var/www/html/miyazaki/fuel/core/› COREPATH |
/var/www/html/miyazaki/fuel/packages/› PKGPATH |
/var/www/html/miyazaki/fuel/app/cache/cache_dir |
falsecaching |
3600cache_lifetime |
nullob_callback |
errors |
› continue_on |
10› throttle |
true› notices |
false› render_prior |
jalanguage |
jalanguage_fallback |
ja_JP.utf8locale |
UTF-8encoding |
0server_gmt_offset |
Asia/Tokyodefault_timezone |
99log_threshold |
nulllog_file |
/var/www/html/miyazaki/fuel/app/logs/log_path |
Y-m-d H:i:slog_date_format |
falsecli_backtrace |
security |
false› csrf_autoload |
› csrf_autoload_methods |
post› › 0 |
put› › 1 |
delete› › 2 |
fuel_csrf_token› csrf_token_key |
0› csrf_expiration |
put your salt value here to make the token more secure› token_salt |
false› allow_x_headers |
3› htmlentities_flags |
false› htmlentities_double_encode |
true› auto_filter_output |
› whitelisted_classes |
Fuel\Core\Presenter› › 0 |
Fuel\Core\Response› › 1 |
Fuel\Core\View› › 2 |
Fuel\Core\ViewModel› › 3 |
Closure› › 4 |
Fuel\Core\Presenter› › 5 |
Fuel\Core\Response› › 6 |
Fuel\Core\View› › 7 |
Fuel\Core\ViewModel› › 8 |
Closure› › 9 |
false› form-double-urlencoded |
› clean_paths |
› uri_filter |
htmlentities› › 0 |
› output_filter |
Security::htmlentities› › 0 |
› input_filter |
cookie |
0› expiration |
/› path |
null› domain |
false› secure |
false› http_only |
validation |
true› global_input_fallback |
Controller_controller_prefix |
routing |
true› case_sensitive |
true› strip_extension |
response |
true› redirect_with_wildcards |
config |
config› table_name |
null› database |
› memcached |
config› › identifier |
› › servers |
› › › 0 |
127.0.0.1› › › › host |
11211› › › › port |
100› › › › weight |
lang |
lang› table_name |
module_paths |
package_paths |
/var/www/html/miyazaki/fuel/packages/› 0 |
/var/www/html/miyazaki/fuel/packages/› 1 |
always_load |
› packages |
auth› › 0 |
orm› › 1 |
pushnotifications› › 2 |
auth› › 3 |
orm› › 4 |
pushnotifications› › 5 |
› modules |
› classes |
› config |
pushnotification› › 0 |
pushnotification› › 1 |
› language |
10default_page_per |
5batch_interval |
全ての年度nendo_all_disp |
allnendo_all_id |
全ての人(未登録者含む)zone_all_disp |
allzone_all_id |
http://104.198.84.95/url_domain |
company/detail?id=url_company |
app://url_invitation |
files/photo/photos/url_image_photo |
files/categorybig/photosurl_categorybig_photo |
files/cmsbusinessdetail/photosurl_cmsbusinessdetail_photo |
files/cmsdetail/photosurl_cmsdetail_photo |
https://fcm.googleapis.com/fcm/sendGOOGLE_API_URL |
AAAAEzVy85g:APA91bHkTp8RvzqNkR3MXFrbPXTg2hnxadiprg9WZiTG7_BpvaOg0CekOOSoO01KNs2aJDaW5G1a6sQ1Mig96hQd6zDrqqWmBOcuYelqMASNTeuXJ6XVkMoIqPL28jkrUrXrwPf7bIvaGOOGLE_API_KEY |
con_img01.jpgPEOPLE |
con_img02.jpgTOWN |
con_img03.jpgWORK |
con_img04.jpgNEWS |
con_img05.jpgSEIJIN_SHIKI |
con_img06.jpgMOVIE |
con_img07.jpgCOMPANY |
con_img08.jpgOTHERS |
no_img.jpgdummy |
companyarea |
東部› 1 |
西部› 2 |
南部› 3 |
北部› 4 |
sort_order_sel |
新着順› 1 |
50音順› 3 |
select_intern |
インターンシップ受入(全て)› 1 |
インターンシプあり› 2 |
インターンシップなし› 3 |
intern_ary |
受け入れ無し› 0 |
受け入れ有り› 1 |
truePush_notification |
event |
orm |
2038-01-18 22:14:08› sql_max_timestamp_mysql |
2147483647› sql_max_timestamp_unix |
pushnotification |
› services |
pushnotification_Gcm› › gcm |
pushnotification_Apns› › apns |
› Pushnotification_Gcm |
› › api_key |
https://android.googleapis.com/gcm/send› › send_address |
› Pushnotification_Apns |
true› › use_sandbox |
› › sandbox |
› › › certificate |
› › › certificate_passphrase |
ssl://gateway.sandbox.push.apple.com:2195› › › push_gateway |
ssl://feedback.sandbox.push.apple.com:2196› › › feedback_gateway |
› › production |
› › › certificate |
› › › certificate_passphrase |
ssl://gateway.push.apple.com:2195› › › push_gateway |
ssl://feedback.push.apple.com:2196› › › feedback_gateway |
60› › timeout |
86400› › expiry |
› pushnotification_Gcm |
› › api_key |
https://android.googleapis.com/gcm/send› › send_address |
› pushnotification_Apns |
false› › use_sandbox |
› › sandbox |
/var/www/html/miyazaki/fuel/app//config/file/push_development.pem› › › certificate |
› › › certificate_passphrase |
ssl://gateway.sandbox.push.apple.com:2195› › › push_gateway |
ssl://feedback.sandbox.push.apple.com:2196› › › feedback_gateway |
› › production |
/var/www/html/miyazaki/fuel/app//config/file/push_production.pem› › › certificate |
› › › certificate_passphrase |
ssl://gateway.push.apple.com:2195› › › push_gateway |
ssl://feedback.push.apple.com:2196› › › feedback_gateway |
60› › timeout |
86400› › expiry |
routes |
front/index› _root_ |
error/404› _404_ |
error/500› _500_ |
› hello(/:name)? |
welcome/hello› › 0 |
hello› › name |
front/index› all |
front/index› news |
front/index› top |
db |
default› active |
› default |
pdo› › type |
› › connection |
false› › › persistent |
false› › › compress |
mysql:host=localhost;dbname=dev_miyazakidb› › › dsn |
miyazaki-usr› › › username |
HtGaPa5n› › › password |
`› › identifier |
› › table_prefix |
utf8› › charset |
false› › collation |
true› › enable_cache |
true› › profiling |
false› › readonly |
› redis |
› › default |
127.0.0.1› › › hostname |
6379› › › port |
null› › › timeout |
0› › › database |
asset |
› paths |
assets/› › 0 |
img/› img_dir |
js/› js_dir |
css/› css_dir |
› folders |
› › css |
› › js |
› › img |
http://104.198.84.95/› url |
true› add_mtime |
1› indent_level |
› indent_with |
true› auto_render |
false› fail_silently |
false› always_resolve |
Based on PHP Quick Profiler | Close Height Bottom |