| 0.0014 |
SHOW TABLES FROM `ps_lentera`
|
| 0.0011 |
SHOW COLUMNS FROM `tinydb`
|
| 0.0003 |
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.0007 |
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 = '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.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 = 'jwsettingstore'
ORDER BY CAST(tiny_key AS UNSIGNED) ASC
LIMIT 0,18446744073709551615
|
| 0.0002 |
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.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 101 AND link_status > 0
ORDER BY id
|
| 0.0007 |
SHOW COLUMNS FROM `jw_blog`
|
| 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 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.0026 |
UPDATE jw_blog SET blog_counter = blog_counter + 1 WHERE id = 58
|
| 0.0002 |
SELECT 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_category_id AS blog_category_id,blog_counter AS blog_counter,blog_like AS blog_like,blog_html_template_id AS blog_html_template_id,blog_status AS blog_status,cby AS blog_author_id,meta_title,meta_description,meta_keyword
FROM jw_blog
WHERE id = '58'
ORDER BY id ASC
LIMIT 0,18446744073709551615
|
| 0.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `tinydb`
|
| 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 = 1 AND bloc_type IN (1,4)
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0002 |
SELECT * FROM adm_login WHERE id = '1'
|
| 0.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.1178 |
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 blog_parent_id = 58
ORDER BY blog_date DESC
LIMIT 0,18446744073709551615
|
| 0.0012 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0002 |
SELECT id,bloc_parent_id,bloc_title,bloc_type,bloc_image,bloc_content,bloc_date
FROM jw_blog_category
WHERE id = 1
ORDER BY id ASC
LIMIT 0,18446744073709551615
|
| 0.0002 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 22 AND link_status > 0
ORDER BY id
|
| 0.0001 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 22 AND adlk_allow_view = 1
|
| 0.0008 |
SHOW COLUMNS FROM `jw_blog_gallery`
|
| 0.0002 |
SELECT id,bgal_blog_id,bgal_prod_id,bgal_title,bgal_description,bgal_image
FROM jw_blog_gallery
WHERE bgal_blog_id = 58 AND bgal_status > 1 AND bgal_date <= NOW()
ORDER BY bgal_date DESC
LIMIT 0,18446744073709551615
|
| 0.0001 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 103 AND link_status > 0
ORDER BY id
|
| 0.1634 |
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 = 2 AND blog_status > 1 AND blog_date <= NOW()
) t
LEFT JOIN jw_blog b USING(id)
GROUP BY monthid
ORDER BY monthid DESC
|
| 0.0090 |
SELECT b.id,blog_parent_id AS stac_parent_id, blog_category_id AS stac_category_id, blog_title AS stac_title,blog_image AS stac_image,blog_content AS stac_content,blog_url AS stac_url,blog_date AS stac_date,blog_featured AS stac_featured,blog_counter AS stac_counter,blog_like AS stac_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 = 2 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.0009 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0001 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0007 |
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 = 1 AND bloc_type IN (1,4)
|
| 0.0006 |
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 = 1 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.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 = 1 AND bloc_type IN (1,4)
|
| 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.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 = 1 AND bloc_type IN (1,4)
|
| 0.0002 |
SELECT id,bloc_parent_id,bloc_title,bloc_type,bloc_image,bloc_date,mby
FROM jw_blog_category
WHERE bloc_type = 2 AND bloc_status > 1
ORDER BY bloc_date DESC
LIMIT 0,18446744073709551615
|
| 0.0002 |
SELECT id,blog_title AS stac_title,blog_date AS stac_date,blog_image AS stac_image,blog_featured AS stac_featured,blog_counter AS stac_counter,blog_like AS stac_like
FROM jw_blog
WHERE CONCAT('; ', blog_category_id,'; ') LIKE '%; 1; %'
AND blog_status > 1 AND blog_date < '2000-01-01 00:00:00'
ORDER BY blog_date DESC
LIMIT 0,1
|
| 0.0001 |
SELECT id,blog_title AS stac_title,blog_date AS stac_date,blog_image AS stac_image,blog_featured AS stac_featured,blog_counter AS stac_counter,blog_like AS stac_like
FROM jw_blog
WHERE CONCAT('; ', blog_category_id,'; ') LIKE '%; 1; %'
AND blog_status > 1 AND blog_date > '2000-01-01 00:00:00'
ORDER BY blog_date ASC
LIMIT 0,1
|
| 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.0086 |
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.0009 |
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.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 = 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.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 = 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.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 = 12 AND bloc_type IN (1,4)
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0004 |
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.0071 |
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.1602 |
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.1607 |
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.0011 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0002 |
SELECT * FROM adm_table_list WHERE id='3'
|
| 0.0008 |
SHOW COLUMNS FROM `jw_blog_category`
|
| 0.0005 |
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.0007 |
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.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.0002 |
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.0002 |
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 `language`
|
| 0.0073 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0003 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 21 AND link_status > 0
ORDER BY id
|
| 0.0002 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 21 AND adlk_allow_view = 1
|
| 0.0003 |
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.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 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.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.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0002 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 51 AND link_status > 0
ORDER BY id
|
| 0.0002 |
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.0008 |
SHOW COLUMNS FROM `jw_banner`
|
| 0.0004 |
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.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0003 |
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.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0003 |
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.0002 |
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.0002 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 92 AND adlk_allow_view = 1
|
| 0.0009 |
SHOW COLUMNS FROM `jw_html_script`
|
| 0.0002 |
SELECT htsc_title,htsc_content
FROM jw_html_script
WHERE htsc_status > 1
ORDER BY htsc_date DESC
LIMIT 0,18446744073709551615
|
| 0.0002 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 102 AND link_status > 0
ORDER BY id
|
| 0.0011 |
SHOW COLUMNS FROM `language`
|
| 0.0087 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0004 |
SELECT id,link_type,link_description
FROM adm_link_list
WHERE id = 51 AND link_status > 0
ORDER BY id
|
| 0.0002 |
SELECT id
FROM adm_link_priviledge
WHERE adlk_login_id = 0 AND adlk_link_id = 51 AND adlk_allow_view = 1
|
| 0.0002 |
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.2815 |
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.0011 |
SHOW COLUMNS FROM jw_shortcut WHERE Field = 'shor_route'
|
| 0.0008 |
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.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 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.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.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.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.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.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0002 |
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.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0083 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0017 |
SHOW COLUMNS FROM `language`
|
| 0.0091 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0018 |
SHOW COLUMNS FROM `language`
|
| 0.0088 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0018 |
SHOW COLUMNS FROM `language`
|
| 0.0092 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0016 |
SHOW COLUMNS FROM `language`
|
| 0.0088 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0018 |
SHOW COLUMNS FROM `language`
|
| 0.0088 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0019 |
SHOW COLUMNS FROM `language`
|
| 0.0099 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0007 |
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.0010 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0015 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0013 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0013 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0009 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0011 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0015 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0011 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 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.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 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.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 `language`
|
| 0.0075 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0009 |
SHOW COLUMNS FROM `language`
|
| 0.0072 |
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 (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.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 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 `language`
|
| 0.0073 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0005 |
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.0008 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0005 |
SHOW COLUMNS FROM `adm_table_list`
|
| 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.0006 |
SHOW COLUMNS FROM `language`
|
| 0.0072 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0010 |
SHOW COLUMNS FROM `language`
|
| 0.0075 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0005 |
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.0009 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0006 |
SHOW COLUMNS FROM `adm_table_list`
|
| 0.0007 |
SHOW COLUMNS FROM `adm_table_list`
|
| 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 `language`
|
| 0.0072 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0009 |
SHOW COLUMNS FROM `language`
|
| 0.0073 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
| 0.0010 |
SHOW COLUMNS FROM `language`
|
| 0.0082 |
SELECT lang_key, lang_indonesia AS lang
FROM language
WHERE lang_category IN (0,2)
|
