| 0.0009 |
SELECT *
FROM `general_settings`
WHERE `id` = 1
|
| 0.0003 |
SELECT *
FROM `storage_settings`
WHERE `id` = 1
|
| 0.0004 |
SELECT *
FROM `form_settings`
WHERE `id` = 1
|
| 0.0004 |
SELECT *
FROM `payment_settings`
WHERE `id` = 1
|
| 0.0003 |
SELECT * FROM languages WHERE id = 1
|
| 0.0016 |
SELECT * FROM language_translations WHERE lang_id = 1
|
| 0.0008 |
SELECT *
FROM `currencies`
|
| 0.0006 |
SELECT *
FROM `location_countries`
WHERE `status` = 1
ORDER BY `name`
|
| 0.0004 |
SELECT *
FROM `settings`
WHERE `lang_id` = '1'
|
| 0.0004 |
SELECT * FROM fonts WHERE id = 16
|
| 0.0005 |
SELECT `id`, `title`, `slug`, `page_order`, `location`, `page_default_name`
FROM `pages`
WHERE `lang_id` = 1
AND `visibility` = 1
ORDER BY `page_order`
|
| 0.0040 |
SELECT `categories`.`id`, `categories`.`slug`, `categories`.`parent_id`, `categories`.`category_order`, `categories`.`featured_order`, `categories`.`storage`, `categories`.`image`, `categories`.`show_image_on_navigation`, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE `visibility` = 1
ORDER BY `category_order`
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 0, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0005 |
SELECT `custom_fields`.*
FROM `custom_fields`
WHERE `custom_fields`.`status` = 1
AND `custom_fields`.`is_product_filter` = 1
ORDER BY `custom_fields`.`field_order`
|
| 0.0004 |
SELECT *
FROM `filters`
|
| 0.0038 |
SELECT id FROM
(SELECT * FROM categories ORDER BY parent_id, id) tbl,
(SELECT @pv := 0) INITIALISATION
WHERE FIND_IN_SET(parent_id, @pv) > 0
AND @pv := CONCAT(@pv, ',', id)
|
| 0.0006 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE `categories`.`id` IN('')
ORDER BY `categories`.`id`
|
| 0.1044 |
SELECT COUNT(*) AS `numrows`
FROM `products`
JOIN `users` ON `products`.`user_id` = `users`.`id`
WHERE `products`.`id` IS NOT NULL
AND `users`.`id` IS NOT NULL
AND `users`.`banned` = 0
AND `products`.`status` = 1
AND `products`.`visibility` = 1
AND `products`.`is_draft` = 0
AND `products`.`is_deleted` = 0
AND `users`.`role` != 'member'
AND (
`products`.`shipping_time` IN('1_business_day')
AND `products`.`add_meet` = 'Made to stock'
AND `products`.`stock` > 0
)
AND (
`products`.`discount_rate` =0
)
AND `is_shop_open` = 1
AND `products`.`category_id` != 15
AND `products`.`category_id` != 319
AND `products`.`category_id` != 16
AND `products`.`category_id` != 104
AND `products`.`category_id` != 105
AND `products`.`category_id` != 106
AND `products`.`category_id` != 107
AND `products`.`category_id` != 108
AND `products`.`category_id` != 109
AND `products`.`category_id` != 110
AND `products`.`category_id` != 111
AND `products`.`category_id` != 112
AND `products`.`category_id` != 113
AND `products`.`category_id` != 114
AND `products`.`category_id` != 115
AND `products`.`category_id` != 116
AND `products`.`category_id` != 117
|
| 0.0057 |
SELECT id FROM
(SELECT * FROM categories ORDER BY parent_id, id) tbl,
(SELECT @pv := 0) INITIALISATION
WHERE FIND_IN_SET(parent_id, @pv) > 0
AND @pv := CONCAT(@pv, ',', id)
|
| 0.0005 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE `categories`.`id` IN('')
ORDER BY `categories`.`id`
|
| 0.0052 |
SELECT `products`.*, `users`.`username` AS `user_username`, `users`.`brand_name` AS `brand_name`, `users`.`supplier_speciality` AS `user_supplier_speciality`, `users`.`id` AS `user_id`, `users`.`shop_name` AS `shop_name`, `users`.`role` AS `user_role`, `users`.`slug` AS `user_slug`, `users`.`is_shop_open` AS `is_shop_open`, (SELECT title FROM product_details WHERE product_details.product_id = products.id AND product_details.lang_id = 1 LIMIT 1) AS title, (SELECT CONCAT(storage, '::', image_small) FROM images WHERE products.id = images.product_id ORDER BY is_main DESC LIMIT 1) AS image, (SELECT CONCAT(storage, '::', image_small) FROM images WHERE products.id = images.product_id ORDER BY is_main DESC LIMIT 1, 1) AS image_second, (SELECT COUNT(wishlist.id) FROM wishlist WHERE products.id = wishlist.product_id) AS wishlist_count, 0 AS `is_in_wishlist`
FROM `products`
JOIN `users` ON `products`.`user_id` = `users`.`id`
WHERE `products`.`id` IS NOT NULL
AND `users`.`id` IS NOT NULL
AND `users`.`banned` = 0
AND `products`.`status` = 1
AND `products`.`visibility` = 1
AND `products`.`is_draft` = 0
AND `products`.`is_deleted` = 0
AND `users`.`role` != 'member'
AND (
`products`.`shipping_time` IN('1_business_day')
AND `products`.`add_meet` = 'Made to stock'
AND `products`.`stock` > 0
)
AND (
`products`.`discount_rate` =0
)
LIMIT 32
|
| 0.0073 |
SELECT id FROM
(SELECT * FROM categories ORDER BY parent_id, id) tbl,
(SELECT @pv := 0) INITIALISATION
WHERE FIND_IN_SET(parent_id, @pv) > 0
AND @pv := CONCAT(@pv, ',', id)
|
| 0.0028 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE `categories`.`id` IN('')
ORDER BY `categories`.`id`
|
| 0.1280 |
SELECT COUNT(*) AS `numrows`
FROM `products`
JOIN `users` ON `products`.`user_id` = `users`.`id`
WHERE `products`.`id` IS NOT NULL
AND `users`.`id` IS NOT NULL
AND `users`.`banned` = 0
AND `products`.`status` = 1
AND `products`.`visibility` = 1
AND `products`.`is_draft` = 0
AND `products`.`is_deleted` = 0
AND `users`.`role` != 'member'
AND (
`products`.`shipping_time` IN('1_business_day')
AND `products`.`add_meet` = 'Made to stock'
AND `products`.`stock` > 0
)
AND (
`products`.`discount_rate` =0
)
AND `is_shop_open` = 1
AND `products`.`category_id` != 15
AND `products`.`category_id` != 319
AND `products`.`category_id` != 16
AND `products`.`category_id` != 104
AND `products`.`category_id` != 105
AND `products`.`category_id` != 106
AND `products`.`category_id` != 107
AND `products`.`category_id` != 108
AND `products`.`category_id` != 109
AND `products`.`category_id` != 110
AND `products`.`category_id` != 111
AND `products`.`category_id` != 112
AND `products`.`category_id` != 113
AND `products`.`category_id` != 114
AND `products`.`category_id` != 115
AND `products`.`category_id` != 116
AND `products`.`category_id` != 117
|
| 0.0097 |
SELECT id FROM
(SELECT * FROM categories ORDER BY parent_id, id) tbl,
(SELECT @pv := 0) INITIALISATION
WHERE FIND_IN_SET(parent_id, @pv) > 0
AND @pv := CONCAT(@pv, ',', id)
|
| 0.0019 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE `categories`.`id` IN('')
ORDER BY `categories`.`id`
|
| 0.1667 |
SELECT DISTINCT `products`.`category_id` as `cat_id`
FROM `products`
JOIN `users` ON `products`.`user_id` = `users`.`id`
WHERE `products`.`id` IS NOT NULL
AND `users`.`id` IS NOT NULL
AND `users`.`banned` = 0
AND `products`.`status` = 1
AND `products`.`visibility` = 1
AND `products`.`is_draft` = 0
AND `products`.`is_deleted` = 0
AND `users`.`role` != 'member'
AND (
`products`.`shipping_time` IN('1_business_day')
AND `products`.`add_meet` = 'Made to stock'
AND `products`.`stock` > 0
)
AND (
`products`.`discount_rate` =0
)
|
| 0.0044 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 64, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0025 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0050 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 259, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0038 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 124, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0040 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 144, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0039 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 218, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0040 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 98, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0035 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 148, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0043 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 149, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0029 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 142, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0042 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 73, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0033 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 139, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0036 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 215, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0039 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 242, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0038 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 186, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0032 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 177, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 257, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0015 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 187, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0056 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 200, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0015 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 167, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 128, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0014 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 300, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0083 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 131, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0024 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 130, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 133, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0027 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 120, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0014 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 119, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0025 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 121, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0013 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 265, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0013 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 143, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 162, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 141, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0018 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 151, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 134, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 166, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 213, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 260, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 220, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 219, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 188, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 226, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 147, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 190, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 79, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 118, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 314, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 71, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 231, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 271, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 217, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 223, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 214, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 206, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 198, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 199, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 301, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 297, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0015 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 192, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 129, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 146, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 225, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 224, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 208, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 212, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 315, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 318, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 72, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0007 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 77, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 70, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 69, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 163, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 173, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 165, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0038 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 74, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 182, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 3, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 179, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 207, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 175, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 135, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0007 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 125, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 123, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 136, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 313, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 60, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 171, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 91, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 132, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 275, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 126, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 88, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 101, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 174, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 86, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 193, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 169, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 197, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 80, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 298, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 294, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 303, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 90, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 191, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 87, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 78, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0014 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 291, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 248, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 6, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 269, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 293, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 285, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 196, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 210, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 63, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 156, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 138, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 161, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 164, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 140, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 277, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 194, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0010 |
SELECT *
FROM `pages`
WHERE `page_default_name` = 'terms_conditions'
AND `visibility` = 1
AND `lang_id` = 1
|
| 0.0008 |
SELECT *
FROM `pages`
WHERE `page_default_name` = 'terms_conditions'
AND `visibility` = 1
AND `lang_id` = 1
|
| 0.0010 |
SELECT `description`
FROM `ui_content`
WHERE `label` = 'buyer_terms_conditions'
|
| 0.0006 |
SELECT `description`
FROM `ui_content`
WHERE `label` = 'buyer_terms_conditions1'
|
| 0.0004 |
SELECT *
FROM `ad_spaces`
WHERE `ad_space` = 'products_sidebar'
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 64, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 29
|
| 0.0005 |
SELECT * FROM variation_options WHERE variation_id = 3 and is_active = '1' ORDER BY id
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '152'
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `users`.`id` = '152'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 152
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 64, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 49
|
| 0.0005 |
SELECT * FROM variation_options WHERE variation_id = 6 and is_active = '1' ORDER BY id
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '152'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '152'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `id` = 152
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 64, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 50
|
| 0.0005 |
SELECT * FROM variation_options WHERE variation_id = 7 and is_active = '1' ORDER BY id
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '152'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '152'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 152
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 105
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 110
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 111
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 112
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0003 |
SELECT *
FROM `variations`
WHERE `product_id` = 113
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 114
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 115
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0003 |
SELECT *
FROM `variations`
WHERE `product_id` = 123
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 124
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0003 |
SELECT *
FROM `variations`
WHERE `product_id` = 125
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 126
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0003 |
SELECT *
FROM `variations`
WHERE `product_id` = 127
|
| 0.0011 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 128
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0026 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0007 |
SELECT *
FROM `variations`
WHERE `product_id` = 129
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0011 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 130
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 132
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0003 |
SELECT *
FROM `variations`
WHERE `product_id` = 133
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0003 |
SELECT *
FROM `variations`
WHERE `product_id` = 134
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0008 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0003 |
SELECT *
FROM `variations`
WHERE `product_id` = 135
|
| 0.0005 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0045 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0062 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0056 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0005 |
SELECT *
FROM `variations`
WHERE `product_id` = 136
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 137
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0003 |
SELECT *
FROM `variations`
WHERE `product_id` = 138
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 139
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0009 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0008 |
SELECT *
FROM `variations`
WHERE `product_id` = 140
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0009 |
SELECT *
FROM `variations`
WHERE `product_id` = 141
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 142
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0011 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 127, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 143
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '164'
|
| 0.0008 |
SELECT *
FROM `users`
WHERE `id` = 164
|
| 0.0012 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 259, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 145
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '181'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '181'
|
| 0.0006 |
SELECT *
FROM `users`
WHERE `id` = 181
|
| 0.0013 |
SELECT `categories`.*, `categories`.`parent_id` AS `join_parent_id`, (SELECT name FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS name, (SELECT actionable FROM categories_lang WHERE categories_lang.category_id = categories.id AND categories_lang.lang_id = 1 LIMIT 1) AS actionable_status, (SELECT slug FROM categories WHERE id = join_parent_id) AS parent_slug, (SELECT id FROM categories AS sub_categories WHERE sub_categories.parent_id = categories.id LIMIT 1) AS has_subcategory
FROM `categories`
WHERE categories.id IN (SELECT tbl2.id FROM (
SELECT @r AS _id,
(SELECT @r := parent_id FROM categories WHERE id = _id) AS parent_id, @l := @l + 1 AS cat_level
FROM (SELECT @r := 259, @l := 0) vars, categories h WHERE @r <> 0) tbl1
JOIN categories tbl2 ON tbl1._id = tbl2.id ORDER BY tbl1.cat_level DESC)
AND `categories`.`visibility` = 1
ORDER BY `categories`.`id`
|
| 0.0004 |
SELECT *
FROM `variations`
WHERE `product_id` = 146
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '181'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `users`.`id` = '181'
|
| 0.0007 |
SELECT *
FROM `users`
WHERE `id` = 181
|
| 0.0004 |
SELECT *
FROM `ad_spaces`
WHERE `ad_space` = 'products'
|
