SELECT bcategory_id
FROM cmsdetail
WHERE no = '281'Connection name: default Speed: 0.504 ms Query analysis: · Query: SIMPLE on cmsdetail · Type: ALL · Rows: 119 (Using where) Call trace for this query:File: APPPATH/classes/model/cmsinfo.php, line 1175File: APPPATH/classes/controller/archive.php, line 127File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT A.*,B.name AS bcategory_name,C.category_name FROM cmsdetail A LEFT JOIN categorybig B ON A.bcategory_id = B.group_id LEFT JOIN category C ON A.bcategory_id = C.bcategory_id AND A.category_id = C.category_id WHERE current_timestamp >= A.starttime AND current_timestamp < ( A.endtime + interval 1 day ) AND A.no = '281'Connection name: default Speed: 1.622 ms Query analysis: · Query: SIMPLE on A · Type: ALL · Rows: 119 (Using where) · Query: SIMPLE on B · Type: ALL · Rows: 8 (Using where; Using join buffer (Block Nested Loop)) · Query: SIMPLE on C · Type: ALL · Rows: 31 (Using where; Using join buffer (Block Nested Loop)) Call trace for this query:File: APPPATH/classes/model/front.php, line 238File: APPPATH/classes/model/cmsinfo.php, line 1001File: APPPATH/classes/controller/archive.php, line 166File: 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.517 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 1022File: APPPATH/classes/controller/archive.php, line 166File: 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.743 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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.391 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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.347 ms · DUPLICATE 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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.329 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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.329 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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: 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.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/model/cmsinfo.php, line 1114File: APPPATH/classes/controller/archive.php, line 174File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |