| 0.0087 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('57aab496c3fd88adaa55de8ea05dcae0', '18.206.48.243', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1701900074, '')
|
| 0.0001 |
DELETE FROM ci_captcha_sessions WHERE captcha_time < 1701899174
|
| 0.0001 |
SELECT p.id, p.front_page, p.menu_title AS name, p.page_title AS title, r.url
FROM (`ci_pages` AS p)
INNER JOIN `ci_routes` AS r ON `r`.`id` = `p`.`id` AND r.type = "page"
WHERE `p`.`active` = 1
AND `p`.`menu` = 1
AND `p`.`language` = 1
ORDER BY `p`.`id` ASC
LIMIT 10
|
| 0.0001 |
SELECT `node_details`.`translated_name`, `node`.`lft`, `node`.`rgt`, `node`.`name`, `node`.`id` AS node_id, (COUNT(parent.id) - 1) AS depth, `route`.`url`
FROM (`ci_categories` AS node, `ci_categories` AS parent, `ci_categories_details` AS node_details, `ci_routes` AS route)
WHERE `node`.`lft` BETWEEN parent.lft AND parent.rgt
AND
node.active = 1
AND
node.menu_visibility = 1
AND
node_details.category_id = node.id AND node_details.language_id = 1
AND
route.id = node.id AND route.type = 'category' AND route.language = 1
GROUP BY `node`.`lft`
HAVING `depth` <= 1
ORDER BY `node`.`lft` ASC
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 88
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 89
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '548'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '548'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 101
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '553'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '553'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '551'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '551'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '550'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '550'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '554'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '554'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 121
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '489'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '489'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '555'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '555'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 137
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '558'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '558'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '645'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '645'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '651'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '651'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '549'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '549'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '557'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '557'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 312
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 313
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '314'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '314'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 339
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '330'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '330'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '342'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '342'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '343'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '343'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 357
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '329'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '329'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '404'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '404'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 379
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '328'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '328'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 383
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '334'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '334'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 394
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '367'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '367'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '368'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '368'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '369'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '369'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '370'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '370'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '371'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '371'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '372'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '372'
LIMIT 1
|
| 0.0001 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '345'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '345'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '373'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '373'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 412
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '425'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '425'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 415
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '429'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '429'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 435
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '426'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '426'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '428'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '428'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 450
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 451
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '398'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '398'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '408'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '408'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '396'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '396'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 459
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '397'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '397'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 469
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '411'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '411'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '403'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '403'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '349'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '349'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '378'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '378'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '409'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '409'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '410'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '410'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 485
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '401'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '401'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 494
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 495
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '445'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '445'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 503
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '443'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '443'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '567'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '567'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '452'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '452'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '453'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '453'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '454'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '454'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '469'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '469'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '460'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '460'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '461'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '461'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '523'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '523'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 528
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '382'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '382'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '380'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '380'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '490'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '490'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '381'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '381'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '379'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '379'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '383'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '383'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 544
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 545
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '508'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '508'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '521'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '521'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '522'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '522'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '462'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '462'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '466'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '466'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '465'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '465'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '478'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '478'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '479'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '479'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '463'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '463'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '449'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '449'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '480'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '480'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '477'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '477'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '474'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '474'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '471'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '471'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '494'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '494'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '472'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '472'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '448'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '448'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '482'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '482'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '473'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '473'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '470'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '470'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '447'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '447'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '464'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '464'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '506'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '506'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '476'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '476'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '475'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '475'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '468'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '468'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '467'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '467'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '505'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '505'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '562'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '562'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 606
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '483'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '483'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '485'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '485'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '484'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '484'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 88
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 89
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '548'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '548'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 101
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '553'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '553'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '551'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '551'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '550'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '550'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '554'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '554'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 121
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '489'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '489'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '555'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '555'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 137
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '558'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '558'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '645'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '645'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '651'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '651'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '549'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '549'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '557'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '557'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 312
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 313
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '314'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '314'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 339
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '330'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '330'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '342'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '342'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '343'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '343'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 357
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '329'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '329'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '404'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '404'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 379
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '328'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '328'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 383
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '334'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '334'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 394
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '367'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '367'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '368'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '368'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '369'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '369'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '370'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '370'
LIMIT 1
|
| 0.0001 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '371'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '371'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '372'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '372'
LIMIT 1
|
| 0.0003 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '345'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '345'
LIMIT 1
|
| 0.0021 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '373'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '373'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 412
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '425'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '425'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 415
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '429'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '429'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 435
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '426'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '426'
LIMIT 1
|
| 0.0001 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '428'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '428'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 450
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 451
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '398'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '398'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '408'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '408'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '396'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '396'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 459
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '397'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '397'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 469
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '411'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '411'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '403'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '403'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '349'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '349'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '378'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '378'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '409'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '409'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '410'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '410'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 485
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '401'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '401'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 494
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 495
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '445'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '445'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 503
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0001 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '443'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '443'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '567'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '567'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '452'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '452'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '453'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '453'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '454'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '454'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '469'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '469'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '460'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '460'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '461'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '461'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '523'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '523'
LIMIT 1
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 528
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '382'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '382'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '380'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '380'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '490'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '490'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '381'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '381'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '379'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '379'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '383'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '383'
LIMIT 1
|
| 0.0001 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 544
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT node.*, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth
FROM ci_categories AS node,
ci_categories AS parent,
ci_categories AS sub_parent,
(
SELECT node.id, (COUNT(parent.id) - 1) AS depth
FROM ci_categories AS node,
ci_categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft = 545
GROUP BY node.id
ORDER BY node.lft
)AS sub_tree
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.lft BETWEEN sub_parent.lft AND sub_parent.rgt
AND sub_parent.id = sub_tree.id
GROUP BY node.id
HAVING depth = 1
ORDER BY node.lft
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '508'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '508'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '521'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '521'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '522'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '522'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '462'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '462'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '466'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '466'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '465'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '465'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '478'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '478'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '479'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '479'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '463'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '463'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '449'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '449'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '480'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '480'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '477'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '477'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '474'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '474'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '471'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '471'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '494'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '494'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '472'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '472'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '448'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '448'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '482'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '482'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '473'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '473'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '470'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '470'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '447'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '447'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '464'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '464'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '506'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '506'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '476'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '476'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '475'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '475'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '468'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '468'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '467'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '467'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '505'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '505'
LIMIT 1
|
| 0.0000 |
SELECT `url`
FROM (`ci_routes`)
WHERE `type` = 'category'
AND `id` = '562'
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`ci_category_images`)
WHERE `type` = 'category'
AND `cid` = '562'
LIMIT 1
|
| 0.0000 |
SELECT `p`.*, `r`.`url`
FROM (`ci_pages` p)
JOIN `ci_routes` r ON `r`.`id` = `p`.`id`
WHERE `p`.`id` = 8
AND `r`.`type` = 'page'
|
| 0.0000 |
SELECT `p`.*, `r`.`url`
FROM (`ci_pages` p)
JOIN `ci_routes` r ON `r`.`id` = `p`.`id`
WHERE `p`.`id` = 4
AND `r`.`type` = 'page'
|
| 0.0000 |
SELECT `p`.*, `r`.`url`
FROM (`ci_pages` p)
JOIN `ci_routes` r ON `r`.`id` = `p`.`id`
WHERE `p`.`id` = 7
AND `r`.`type` = 'page'
|
| 0.0000 |
SELECT `p`.*, `r`.`url`
FROM (`ci_categories` p)
JOIN `ci_routes` r ON `r`.`id` = `p`.`id`
WHERE `p`.`id` = 313
AND `r`.`type` = 'category'
|
| 0.0000 |
SELECT *
FROM (`ci_news`)
WHERE `front_block` = 1
LIMIT 9
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `front_block` = 1
ORDER BY `position` asc
LIMIT 8
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `parent_id` = '6'
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `parent_id` = '9'
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `parent_id` = '27'
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `parent_id` = '51'
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `parent_id` = '47'
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `parent_id` = '58'
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `parent_id` = '8'
|
| 0.0000 |
SELECT *
FROM (`ci_packages`)
WHERE `parent_id` = '69'
|
| 0.0001 |
SELECT p.*, pv.*, pv.id AS product_version_id, r.url, pi.filename, c.name AS category
FROM (`ci_product_defaults` p)
INNER JOIN `ci_routes` AS r ON `r`.`id` = `p`.`id` AND r.type="product"
INNER JOIN `ci_product_versions` AS pv ON `pv`.`product_id` = `p`.`id`
LEFT JOIN `ci_product_images` pi ON `pi`.`product_id` = `p`.`id` AND pi.default = 1
INNER JOIN `ci_products_categories` pc ON `pc`.`product_id` = `p`.`id`
INNER JOIN `ci_categories` c ON `c`.`id` = `pc`.`category_id`
WHERE `p`.`published` = 1 AND ( p.id = 0 )
GROUP BY `p`.`id`
|
| 0.0000 |
SELECT `p`.`page_title`, `r`.`url`
FROM (`ci_pages` AS p)
INNER JOIN `ci_routes` AS r ON `r`.` |
Google útvonaltervezés
WAZE útvonaltervezés
