| 0.0010 |
SELECT *
FROM `cle_categories`
WHERE `public` = 1
AND `slug` = 'du-lich'
|
| 0.0003 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '2'
AND `rgt` <= '3'
ORDER BY `order`
|
| 0.0025 |
SELECT COUNT(DISTINCT `cle_relationships`.`object_id`) as `count`
FROM `cle_relationships`
JOIN `cle_post` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('3')
|
| 0.0002 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '2'
AND `rgt` <= '3'
ORDER BY `order`
|
| 0.0144 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('3')
GROUP BY `cle_post`.`id`
ORDER BY `cle_post`.`order`, `cle_post`.`created` desc
LIMIT 20, 10
|
| 0.0153 |
SELECT *
FROM `cle_group`
WHERE `options` = 'main-nav'
AND `object_type` = 'menu'
|
| 0.0003 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '2'
AND `rgt` <= '3'
ORDER BY `order`
|
| 0.0003 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('3')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0013 |
SELECT `id`
FROM `cle_categories`
WHERE `lft` >= '2'
AND `rgt` <= '3'
ORDER BY `order`
|
| 0.0063 |
SELECT `cle_post`.*
FROM `cle_post`
JOIN `cle_relationships` ON `cle_relationships`.`object_id` = `cle_post`.`id`
WHERE `public` = 1
AND `trash` = 0
AND `post_type` = 'post'
AND `status` = 1
AND `cle_relationships`.`object_type` = 'post'
AND `cle_relationships`.`category_id` IN('3')
GROUP BY `cle_post`.`id`
ORDER BY `order`, `created` desc
LIMIT 5
|
| 0.0001 |
SELECT *
FROM `cle_widget`
WHERE `sidebar_id` = 'footer-top'
AND `template` = 'theme-store'
ORDER BY `order`
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `cle_statistics`
WHERE `visited_timestamp` >= 1752771600
AND `visited_timestamp` <= 1752857999
|
| 2.5323 |
SELECT *
FROM `cle_statistics`
ORDER BY `order`, `created` desc
|
| 0.1065 |
SELECT COUNT(*) AS `numrows`
FROM `cle_statistics`
|
