| 0.0008 |
SHOW TABLES FROM `ps_lentera`
|
| 0.0006 |
SHOW COLUMNS FROM `tinydb`
|
| 0.0002 |
SELECT tiny_key AS strKey,tiny_data1 AS strData,tiny_data2 AS strData2,tiny_data3 AS strData3
FROM tinydb
WHERE tiny_category = 'jwdefaultconfig'
ORDER BY CAST(tiny_key AS UNSIGNED) ASC
LIMIT 0,18446744073709551615
|
| 0.0005 |
SHOW COLUMNS FROM `tinydb`
|
| 0.0001 |
SELECT tiny_key AS strKey,tiny_data1 AS strData,tiny_data2 AS strData2,tiny_data3 AS strData3
FROM tinydb
WHERE tiny_category = 'language'
ORDER BY CAST(tiny_key AS UNSIGNED) ASC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT tiny_key AS strKey,tiny_data1 AS strData,tiny_data2 AS strData2,tiny_data3 AS strData3
FROM tinydb
WHERE tiny_category = 'language'
ORDER BY CAST(tiny_key AS UNSIGNED) ASC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT tiny_key AS strKey,tiny_data1 AS strData,tiny_data2 AS strData2,tiny_data3 AS strData3
FROM tinydb
WHERE tiny_category = 'jwsettingstore'
ORDER BY CAST(tiny_key AS UNSIGNED) ASC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT tiny_key AS strKey,tiny_data1 AS strData,tiny_data2 AS strData2,tiny_data3 AS strData3
FROM tinydb
WHERE tiny_category = 'jwsettingmeta'
ORDER BY CAST(tiny_key AS UNSIGNED) ASC
LIMIT 0,18446744073709551615
|
| 0.0005 |
SHOW COLUMNS FROM `tinydb`
|
| 0.0002 |
SELECT tiny_key AS strKey,tiny_data1 AS strData,tiny_data2 AS strData2,tiny_data3 AS strData3
FROM tinydb
WHERE tiny_category = 'jwsettingstore'
ORDER BY CAST(tiny_key AS UNSIGNED) ASC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT tiny_key AS strKey,tiny_data1 AS strData,tiny_data2 AS strData2,tiny_data3 AS strData3
FROM tinydb
WHERE tiny_category = 'jwsettingowner'
ORDER BY CAST(tiny_key AS UNSIGNED) ASC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 32 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 33 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 34 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 35 AND link_status > 0
ORDER BY id
|
| 0.0000 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 101 AND link_status > 0
ORDER BY id
|
| 0.0006 |
SHOW COLUMNS FROM `jw_blog`
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 51 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 51 AND adlk_allow_view = 1
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0001 |
SELECT id,bloc_parent_id,bloc_title,bloc_type,bloc_image,bloc_content,bloc_date
FROM jw_blog_category
WHERE id = 68
ORDER BY id ASC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 11 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 11 AND adlk_allow_view = 1
|
| 0.0001 |
SELECT bloc_parent_id
FROM jw_blog_category
WHERE id = 68
ORDER BY id ASC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT id,bloc_parent_id,bloc_title,bloc_type,bloc_image,bloc_date,mby
FROM jw_blog_category
WHERE id = 0
ORDER BY id ASC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT id,bloc_parent_id,bloc_title,bloc_type,bloc_image,bloc_date,mby
FROM jw_blog_category
WHERE bloc_parent_id = 68 AND bloc_status > 1
ORDER BY bloc_date DESC
LIMIT 0,18446744073709551615
|
| 0.1241 |
SELECT COUNT(*) AS c
FROM jw_blog
WHERE CONCAT('; ', blog_category_id,'; ') LIKE '%; 68; %'
AND blog_status > 1 AND blog_date <= NOW()
ORDER BY id ASC
LIMIT 0,18446744073709551615
|
| 0.0174 |
SELECT id,blog_parent_id AS blog_parent_id, blog_category_id AS blog_category_id, blog_title AS blog_title,blog_image AS blog_image,blog_content AS blog_content,blog_url AS blog_url,blog_date AS blog_date,blog_featured AS blog_featured,blog_counter AS blog_counter,blog_like AS blog_like
FROM jw_blog
WHERE CONCAT('; ', blog_category_id,'; ') LIKE '%; 68; %'
AND blog_status > 1 AND blog_date <= NOW()
ORDER BY blog_date DESC
LIMIT 1296,12
|
| 0.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `tinydb`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0004 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 78 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 78 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 68 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 103 AND link_status > 0
ORDER BY id
|
| 2.1103 |
SELECT EXTRACT(YEAR_MONTH FROM b.blog_date) AS monthid, EXTRACT(MONTH FROM b.blog_date) AS monthnow, EXTRACT(YEAR FROM blog_date) AS yearnow, COUNT(b.id) as number
FROM (
SELECT b.id, bc.id as category_id
FROM jw_blog AS b
LEFT JOIN jw_blog_category AS bc ON CONCAT('; ', b.blog_category_id,'; ') LIKE CONCAT('%; ', bc.id, '; %')
WHERE bloc_type = 1 AND blog_status > 1 AND blog_date <= NOW()
) t
LEFT JOIN jw_blog b USING(id)
GROUP BY monthid
ORDER BY monthid DESC
|
| 0.0020 |
SELECT b.id,blog_parent_id AS blog_parent_id, blog_category_id AS blog_category_id, blog_title AS blog_title,blog_image AS blog_image,blog_content AS blog_content,blog_url AS blog_url,blog_date AS blog_date,blog_featured AS blog_featured,blog_counter AS blog_counter,blog_like AS blog_like
FROM (
SELECT DISTINCT b.id
FROM jw_blog AS b
LEFT JOIN jw_blog_category AS bc ON CONCAT('; ', b.blog_category_id,'; ') LIKE CONCAT('%; ', bc.id, '; %')
WHERE bloc_type = 1 AND blog_status > 1
AND blog_featured > 1 AND blog_date <= NOW()
LIMIT 0,12
) t
LEFT JOIN jw_blog b USING (id)
ORDER BY blog_date DESC
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 101 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 11 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 11 AND adlk_allow_view = 1
|
| 0.0090 |
SELECT b.id,blog_parent_id AS blog_parent_id, blog_category_id AS blog_category_id, blog_title AS blog_title,blog_image AS blog_image,blog_content AS blog_content,blog_url AS blog_url,blog_date AS blog_date,blog_featured AS blog_featured,blog_counter AS blog_counter,blog_like AS blog_like
FROM (
SELECT DISTINCT b.id
FROM jw_blog AS b
LEFT JOIN jw_blog_category AS bc ON CONCAT('; ', b.blog_category_id,'; ') LIKE CONCAT('%; ', bc.id, '; %')
WHERE bloc_type = 1 AND blog_status > 1
AND blog_date <= NOW()
LIMIT 0,4
) t
LEFT JOIN jw_blog b USING (id)
ORDER BY blog_date DESC
|
| 0.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0006 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0004 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 2 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 37 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 22 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 12 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0003 |
SELECT b.id,blog_parent_id AS blog_parent_id, blog_category_id AS blog_category_id, blog_title AS blog_title,blog_image AS blog_image,blog_content AS blog_content,blog_url AS blog_url,blog_date AS blog_date,blog_featured AS blog_featured,blog_counter AS blog_counter,blog_like AS blog_like
FROM (
SELECT DISTINCT b.id
FROM jw_blog AS b
LEFT JOIN jw_blog_category AS bc ON CONCAT('; ', b.blog_category_id,'; ') LIKE CONCAT('%; ', bc.id, '; %')
WHERE bloc_type = 1 AND blog_status > 1
AND blog_featured > 1 AND blog_date <= NOW()
LIMIT 0,4
) t
LEFT JOIN jw_blog b USING (id)
ORDER BY blog_date DESC
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0002 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 12 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 12 AND adlk_allow_view = 1
|
| 0.1562 |
SELECT b.id,blog_parent_id AS news_parent_id, blog_category_id AS news_category_id, blog_title AS news_title,blog_image AS news_image,blog_content AS news_content,blog_url AS news_url,blog_date AS news_date,blog_featured AS news_featured,blog_counter AS news_counter,blog_like AS news_like
FROM (
SELECT DISTINCT b.id
FROM jw_blog AS b
LEFT JOIN jw_blog_category AS bc ON CONCAT('; ', b.blog_category_id,'; ') LIKE CONCAT('%; ', bc.id, '; %')
WHERE bloc_type = 5 AND blog_status > 1
AND blog_date <= NOW()
LIMIT 0,4
) t
LEFT JOIN jw_blog b USING (id)
ORDER BY blog_date DESC
|
| 0.0002 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 13 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 14 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 15 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 15 AND adlk_allow_view = 1
|
| 0.1526 |
SELECT b.id,blog_parent_id AS shou_parent_id, blog_category_id AS shou_category_id, blog_title AS shou_title,blog_image AS shou_image,blog_content AS shou_content,blog_url AS shou_url,blog_date AS shou_date,blog_featured AS shou_featured,blog_counter AS shou_counter,blog_like AS shou_like
FROM (
SELECT DISTINCT b.id
FROM jw_blog AS b
LEFT JOIN jw_blog_category AS bc ON CONCAT('; ', b.blog_category_id,'; ') LIKE CONCAT('%; ', bc.id, '; %')
WHERE bloc_type = 7 AND blog_status > 1
AND blog_date <= NOW()
LIMIT 0,4
) t
LEFT JOIN jw_blog b USING (id)
ORDER BY blog_date DESC
|
| 0.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0006 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0004 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 7 AND bloc_type IN (1,4)
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0004 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 7 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 7 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0005 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0003 |
SELECT id,strKey,strData
FROM (
SELECT id AS strKey,CONCAT(IFNULL(CONCAT(parent_title,' > '),''),bloc_title) AS strData,id,bloc_type,bloc_status
FROM jw_blog_category AS t
LEFT JOIN (
SELECT id AS parent_id,bloc_title AS parent_title
FROM jw_blog_category AS t
) AS bcp ON parent_id = bloc_parent_id
ORDER BY id ASC
LIMIT 0,18446744073709551615
) AS t
WHERE id = 7 AND bloc_type IN (1,4)
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0013 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 21 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 21 AND adlk_allow_view = 1
|
| 0.0002 |
SELECT id,bloc_parent_id,bloc_title,bloc_type,bloc_image,bloc_date,mby
FROM jw_blog_category
WHERE bloc_status > 1
ORDER BY bloc_date DESC
LIMIT 0,18446744073709551615
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0004 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0004 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0004 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 51 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 51 AND adlk_allow_view = 1
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 32 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 33 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 113 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 91 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 91 AND adlk_allow_view = 1
|
| 0.0005 |
SHOW COLUMNS FROM `jw_banner`
|
| 0.0002 |
SELECT id,bann_title,bann_link,bann_image,bann_description
FROM jw_banner
WHERE bann_status > 1 AND bann_placement = 1 AND (bann_deposit > 0 OR bann_deposit = -1) AND bann_date <= NOW()
ORDER BY RAND()
LIMIT 0,1
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0002 |
SELECT id,bann_title,bann_link,bann_image,bann_description
FROM jw_banner
WHERE bann_status > 1 AND bann_placement = 2 AND (bann_deposit > 0 OR bann_deposit = -1) AND bann_date <= NOW()
ORDER BY bann_date DESC
LIMIT 0,4
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0002 |
SELECT id,bann_title,bann_link,bann_image,bann_description
FROM jw_banner
WHERE bann_status > 1 AND bann_placement = 3 AND (bann_deposit > 0 OR bann_deposit = -1) AND bann_date <= NOW()
ORDER BY RAND()
LIMIT 0,1
|
| 0.0001 |
SELECT id,bann_title,bann_link,bann_image,bann_description
FROM jw_banner
WHERE bann_status > 1 AND bann_placement = 4 AND (bann_deposit > 0 OR bann_deposit = -1) AND bann_date <= NOW()
ORDER BY RAND()
LIMIT 0,1
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 92 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 92 AND adlk_allow_view = 1
|
| 0.0005 |
SHOW COLUMNS FROM `jw_html_script`
|
| 0.0001 |
SELECT htsc_title,htsc_content
FROM jw_html_script
WHERE htsc_status > 1
ORDER BY htsc_date DESC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 102 AND link_status > 0
ORDER BY id
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 51 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 51 AND adlk_allow_view = 1
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 104 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 103 AND link_status > 0
ORDER BY id
|
| 2.2501 |
SELECT EXTRACT(YEAR_MONTH FROM b.blog_date) AS monthid, EXTRACT(MONTH FROM b.blog_date) AS monthnow, EXTRACT(YEAR FROM blog_date) AS yearnow, COUNT(b.id) as number
FROM (
SELECT b.id, bc.id as category_id
FROM jw_blog AS b
LEFT JOIN jw_blog_category AS bc ON CONCAT('; ', b.blog_category_id,'; ') LIKE CONCAT('%; ', bc.id, '; %')
WHERE bloc_type = 1 AND blog_status > 1 AND blog_date <= NOW()
) t
LEFT JOIN jw_blog b USING(id)
GROUP BY monthid
ORDER BY monthid DESC
|
| 0.0009 |
SHOW COLUMNS FROM jw_shortcut WHERE Field = 'shor_route'
|
| 0.0006 |
SHOW COLUMNS FROM `jw_shortcut`
|
| 0.0003 |
SELECT id,shor_parent,shor_title,shor_link,shor_route,shor_image,shor_place
FROM jw_shortcut s
LEFT JOIN (
SELECT id AS parent_id, shor_title As parent_title, shor_position AS parent_position
FROM jw_shortcut
) sp ON sp.parent_id = s.shor_parent
WHERE shor_place IN (1,2,3,4,5) AND shor_status > 1
ORDER BY IF(s.shor_parent = 0, (s.shor_position * 100), (parent_position * 100) + s.shor_position) ASC
LIMIT 0,18446744073709551615
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0003 |
SELECT id,shor_parent,shor_title,shor_link,shor_route,shor_image,shor_place
FROM jw_shortcut s
LEFT JOIN (
SELECT id AS parent_id, shor_title As parent_title, shor_position AS parent_position
FROM jw_shortcut
) sp ON sp.parent_id = s.shor_parent
WHERE shor_place IN (0,2,6) AND shor_status > 1
ORDER BY IF(s.shor_parent = 0, (s.shor_position * 100), (parent_position * 100) + s.shor_position) ASC
LIMIT 0,18446744073709551615
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 56 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 56 AND adlk_allow_view = 1
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0092 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0010 |
SHOW COLUMNS FROM `language`
|
| 0.0077 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0004 |
SELECT id,shor_parent,shor_title,shor_link,shor_route,shor_image,shor_place
FROM jw_shortcut s
LEFT JOIN (
SELECT id AS parent_id, shor_title As parent_title, shor_position AS parent_position
FROM jw_shortcut
) sp ON sp.parent_id = s.shor_parent
WHERE shor_place IN (0,2,6) AND shor_status > 1
ORDER BY IF(s.shor_parent = 0, (s.shor_position * 100), (parent_position * 100) + s.shor_position) ASC
LIMIT 0,18446744073709551615
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0004 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0004 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0004 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0004 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0071 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0071 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0071 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0070 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0007 |
SHOW COLUMNS FROM `language`
|
| 0.0071 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0003 |
SELECT id,shor_parent,shor_title,shor_link,shor_route,shor_image,shor_place
FROM jw_shortcut s
LEFT JOIN (
SELECT id AS parent_id, shor_title As parent_title, shor_position AS parent_position
FROM jw_shortcut
) sp ON sp.parent_id = s.shor_parent
WHERE shor_place IN (1,2,3,4,5) AND shor_status > 1
ORDER BY IF(s.shor_parent = 0, (s.shor_position * 100), (parent_position * 100) + s.shor_position) ASC
LIMIT 0,18446744073709551615
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0003 |
SELECT id,shor_parent,shor_title,shor_link,shor_route,shor_image,shor_place
FROM jw_shortcut s
LEFT JOIN (
SELECT id AS parent_id, shor_title As parent_title, shor_position AS parent_position
FROM jw_shortcut
) sp ON sp.parent_id = s.shor_parent
WHERE shor_place IN (1,2,3,4,5) AND shor_status > 1
ORDER BY IF(s.shor_parent = 0, (s.shor_position * 100), (parent_position * 100) + s.shor_position) ASC
LIMIT 0,18446744073709551615
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0003 |
SELECT id,shor_parent,shor_title,shor_link,shor_route,shor_image,shor_place
FROM jw_shortcut s
LEFT JOIN (
SELECT id AS parent_id, shor_title As parent_title, shor_position AS parent_position
FROM jw_shortcut
) sp ON sp.parent_id = s.shor_parent
WHERE shor_place IN (1,2,3,4,5) AND shor_status > 1
ORDER BY IF(s.shor_parent = 0, (s.shor_position * 100), (parent_position * 100) + s.shor_position) ASC
LIMIT 0,18446744073709551615
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0005 |
SHOW COLUMNS FROM `language`
|
| 0.0069 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
.jpg)
