SELECT bcategory_id
FROM cmsdetail
WHERE no = '282'Connection name: default Speed: 0.499 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 = '282'Connection name: default Speed: 1.269 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 = '282'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.461 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 (1)
AND t1.starttime <= NOW()
AND t1.endtime >= NOW()
ORDER BY t1.starttime DESCConnection name: default Speed: 0.632 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 = '291'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.390 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 = '288'
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 = '286'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.396 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 = '283'
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 |
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.353 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 = '277'
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 = '276'
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/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 = '275'
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 = '274'
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/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 = '271'
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 = '268'
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/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 = '267'
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/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 = '264'
AND starttime <= NOW()
AND endtime >= NOW()
ORDER BY starttime DESC
LIMIT 1Connection name: default Speed: 0.356 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 = '263'
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/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 = '261'
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 = '259'
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 = '257'
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 |