Close
Your shopping cart is empty
Go to the shop
Share
Close

Products

24 48 96 144
Sort by Newest Best seller Price: Low to High Price: High to Low (A-Z) (Z-A)
Remove selection
Loading ...
MessagesRequestTimelineExceptionsDatabase350
8.1.31Version173msRequest Duration6MBMemory Usage
    $_GET
    array:1 [ "f" => array:1 [ "c" => "31" ] ]
    $_POST
    []
    $_COOKIE
    []
    $_SERVER
    array:64 [ "USER" => "alnasserstaging" "HOME" => "/home/alnasserstaging" "SCRIPT_NAME" => "/pu...
    • Booting (6.44ms)
    • Configs (1.8ms)
    • Controller (157ms)
    • 1 x Controller (90.79%)
      157.46ms
      1 x Booting (3.71%)
      6.44ms
      1 x Configs (1.04%)
      1.80ms
      350 statements were executed, 234 of which were duplicates, 116 unique155ms✌ Duration
      • SET NAMES utf8mb469μs0
      • SET SESSION sql_mode=''39μs0
      • SELECT * FROM `i18n_cat` ORDER BY `default_lang` DESC 28μs2
      • SELECT * FROM `configs`122μs104
      • SELECT * FROM `countries` ORDER BY `en_name`100μs244
      • SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id` 64μs5
      • SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 17μs5
      • SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id` 13μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 16μs9
      • SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id` 13μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id` 16μs11
      • SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id` 15μs2
      • SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id` 15μs8
      • SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `header_ads` WHERE NOW() BETWEEN`date_start` AND `date_expire` AND `status` = 1 ORDER BY `id` DESC Limit 1138μs0
      • SELECT * FROM `faq_cat` WHERE `status` =115μs2
      • SELECT * FROM `products_cat` WHERE `id`IN (SELECT `sub_of` FROM `products` WHERE `is_new` = 1) LIMIT 815μs8
      • SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`21μs6
      • INSERT INTO `sessions` ( `admins`,`session`,`last_ip` )VALUES( '0','39e14aa682c0dbcd8db3249b00dc486e','18.223.255.147' )1.82ms1
      • SELECT * FROM `carts` WHERE `sub_of` IN (190169)78μs0
      • SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id` 781μs5
      • SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 13μs5
      • SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id` 14μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 16μs9
      • SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id` 14μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id` 15μs11
      • SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id` 12μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id` 18μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id` 15μs2
      • SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id` 15μs8
      • SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id` 12μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT * FROM `faq_cat` WHERE `status` =115μs2
      • SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`22μs6
      • SELECT * FROM `products_cat` WHERE `sub_of`=0 AND `status` =1 ORDER BY `sort_id` , `id` 22μs5
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='37' GROUP BY p.id LIMIT 0,30333μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'19μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY p.date_update LIMIT 0,1112.41ms11
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) 137μs11
      • SELECT * FROM `attributes` WHERE `type`='quantity'311μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) AND `for_quantity` = 1 ORDER BY `main` DESC20μs33
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY sold DESC LIMIT 0,2012.26ms20
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1958,1794,1953,407,431,376,371,3,328,332,2,5,314,1864,47,256,4,13,1915,335) 156μs24
      • SELECT * FROM `attributes` WHERE `type`='quantity'223μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (2,3,4,5,13,47,256,318,319,334,339,340,341,344,384,389,420,448,449,1892,1975,2048,2089,2094) AND `for_quantity` = 1 ORDER BY `main` DESC20μs45
      • SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 19μs5
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='38' GROUP BY p.id LIMIT 0,5421μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (312,313,314,316,325) 93μs7
      • SELECT * FROM `attributes` WHERE `type`='quantity'44μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (316,317,318,319,321,322,331) AND `for_quantity` = 1 ORDER BY `main` DESC18μs16
      • SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id` 18μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='39' GROUP BY p.id LIMIT 0,5363μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (306,307,308,311,318) 93μs8
      • SELECT * FROM `attributes` WHERE `type`='quantity'55μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (308,309,310,2118,311,314,315,324) AND `for_quantity` = 1 ORDER BY `main` DESC17μs20
      • SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='40' GROUP BY p.id LIMIT 0,5329μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (372,373,379,394,395) 82μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'365μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (385,386,392,407,408) AND `for_quantity` = 1 ORDER BY `main` DESC15μs10
      • SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='41' GROUP BY p.id LIMIT 0,5345μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (309,315,322,358,359) 88μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'213μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (312,320,328,371,372) AND `for_quantity` = 1 ORDER BY `main` DESC18μs8
      • SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='42' GROUP BY p.id LIMIT 0,5413μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (310,367,368,389,1864) 87μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'143μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (313,380,381,402,1975) AND `for_quantity` = 1 ORDER BY `main` DESC17μs8
      • SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='8' GROUP BY p.id LIMIT 0,30227μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'19μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY p.date_update LIMIT 0,1112.5ms11
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) 21μs11
      • SELECT * FROM `attributes` WHERE `type`='quantity'12μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) AND `for_quantity` = 1 ORDER BY `main` DESC15μs33
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY sold DESC LIMIT 0,2012.47ms20
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1958,1794,1953,407,431,376,371,3,328,332,2,5,314,1864,47,256,4,13,1915,335) 23μs24
      • SELECT * FROM `attributes` WHERE `type`='quantity'16μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (2,3,4,5,13,47,256,318,319,334,339,340,341,344,384,389,420,448,449,1892,1975,2048,2089,2094) AND `for_quantity` = 1 ORDER BY `main` DESC16μs45
      • SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 18μs9
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='26' GROUP BY p.id LIMIT 0,5388μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (472,473,474,475,476) 105μs10
      • SELECT * FROM `attributes` WHERE `type`='quantity'327μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (504,2042,505,507,506,2039,508,510,2111,509) AND `for_quantity` = 1 ORDER BY `main` DESC18μs24
      • SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='53' GROUP BY p.id LIMIT 0,5324μs4
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (616,620,632,633) 82μs4
      • SELECT * FROM `attributes` WHERE `type`='quantity'229μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (688,692,704,705) AND `for_quantity` = 1 ORDER BY `main` DESC16μs8
      • SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='27' GROUP BY p.id LIMIT 0,5458μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (426,428,429,431,434) 89μs6
      • SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (439,443,444,448,449,452) AND `for_quantity` = 1 ORDER BY `main` DESC18μs9
      • SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='29' GROUP BY p.id LIMIT 0,5353μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (427,430,432,441,443) 101μs13
      • SELECT * FROM `attributes` WHERE `type`='quantity'381μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (440,441,442,445,446,447,450,461,462,463,465,466,2023) AND `for_quantity` = 1 ORDER BY `main` DESC17μs34
      • SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id` 17μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='30' GROUP BY p.id LIMIT 0,5362μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (456,457,477,478,496) 86μs7
      • SELECT * FROM `attributes` WHERE `type`='quantity'101μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (484,485,511,512,2040,2041,536) AND `for_quantity` = 1 ORDER BY `main` DESC15μs7
      • SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='45' GROUP BY p.id LIMIT 0,5350μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (463,464,479,483,484) 97μs9
      • SELECT * FROM `attributes` WHERE `type`='quantity'188μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (492,493,494,495,513,518,520,519,521) AND `for_quantity` = 1 ORDER BY `main` DESC20μs27
      • SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='31' GROUP BY p.id LIMIT 0,5324μs4
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (458,613,614,615) 91μs10
      • SELECT * FROM `attributes` WHERE `type`='quantity'223μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (486,683,684,686,1997,685,687,1992,2027,2107) AND `for_quantity` = 1 ORDER BY `main` DESC16μs3
      • SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='28' GROUP BY p.id LIMIT 0,5278μs1
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (462) 68μs1
      • SELECT * FROM `attributes` WHERE `type`='quantity'60μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (491) AND `for_quantity` = 1 ORDER BY `main` DESC17μs2
      • SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='32' GROUP BY p.id LIMIT 0,5305μs4
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (481,482,498,499) 94μs10
      • SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (515,517,516,2024,539,601,2050,540,602,2049) AND `for_quantity` = 1 ORDER BY `main` DESC18μs29
      • SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id` 17μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='9' GROUP BY p.id LIMIT 0,30229μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY p.date_update LIMIT 0,1112.25ms11
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) 21μs11
      • SELECT * FROM `attributes` WHERE `type`='quantity'14μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) AND `for_quantity` = 1 ORDER BY `main` DESC15μs33
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY sold DESC LIMIT 0,2012.19ms20
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1958,1794,1953,407,431,376,371,3,328,332,2,5,314,1864,47,256,4,13,1915,335) 23μs24
      • SELECT * FROM `attributes` WHERE `type`='quantity'16μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (2,3,4,5,13,47,256,318,319,334,339,340,341,344,384,389,420,448,449,1892,1975,2048,2089,2094) AND `for_quantity` = 1 ORDER BY `main` DESC17μs45
      • SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id` 17μs11
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='20' GROUP BY p.id LIMIT 0,5392μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (629,640,641,642,643) 119μs16
      • SELECT * FROM `attributes` WHERE `type`='quantity'186μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 18μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (701,724,727,729,731,725,728,730,732,726,1962,1963,733,736,739,742) AND `for_quantity` = 1 ORDER BY `main` DESC19μs47
      • SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='21' GROUP BY p.id LIMIT 0,5369μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (599,600,601,602,603) 159μs20
      • SELECT * FROM `attributes` WHERE `type`='quantity'27μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (650,652,1946,1947,651,653,654,1999,655,1945,2025,2026,656,659,661,2217,657,662,663,2216) AND `for_quantity` = 1 ORDER BY `main` DESC20μs48
      • SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id` 20μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='4' GROUP BY p.id LIMIT 0,5322μs2
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (585,681) 77μs2
      • SELECT * FROM `attributes` WHERE `type`='quantity'68μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (628,779) AND `for_quantity` = 1 ORDER BY `main` DESC17μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='43' GROUP BY p.id LIMIT 0,5348μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (617,618,619,621,622) 90μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'123μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (689,690,691,693,694) AND `for_quantity` = 1 ORDER BY `main` DESC20μs11
      • SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id` 17μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='44' GROUP BY p.id LIMIT 0,5244μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='51' GROUP BY p.id LIMIT 0,5356μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (588,589,590,591,592) 96μs12
      • SELECT * FROM `attributes` WHERE `type`='quantity'95μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (631,632,636,639,646,633,637,640,647,634,635,645) AND `for_quantity` = 1 ORDER BY `main` DESC21μs34
      • SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id` 18μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='23' GROUP BY p.id LIMIT 0,5347μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (704,705,706,707,708) 85μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'214μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (802,803,804,805,806) AND `for_quantity` = 1 ORDER BY `main` DESC19μs10
      • SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='24' GROUP BY p.id LIMIT 0,5340μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (623,624,625,626,627) 89μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'23μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (695,696,697,698,699) AND `for_quantity` = 1 ORDER BY `main` DESC15μs5
      • SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id` 17μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='22' GROUP BY p.id LIMIT 0,5330μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (414,415,419,422,423) 92μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'129μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (427,428,432,435,436) AND `for_quantity` = 1 ORDER BY `main` DESC16μs8
      • SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id` 18μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='49' GROUP BY p.id LIMIT 0,5355μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (636,637,638,639,702) 109μs17
      • SELECT * FROM `attributes` WHERE `type`='quantity'307μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (708,712,716,720,709,713,717,721,710,714,718,722,711,715,719,723,800) AND `for_quantity` = 1 ORDER BY `main` DESC19μs49
      • SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id` 19μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='25' GROUP BY p.id LIMIT 0,5282μs1
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (739) 75μs1
      • SELECT * FROM `attributes` WHERE `type`='quantity'120μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (837) AND `for_quantity` = 1 ORDER BY `main` DESC18μs0
      • SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id` 17μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='1' GROUP BY p.id LIMIT 0,30748μs30
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (2,6,12,23,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50) 24μs30
      • SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (2,6,12,23,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50) AND `for_quantity` = 1 ORDER BY `main` DESC21μs89
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY p.date_update LIMIT 0,1112.75ms11
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) 25μs11
      • SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) AND `for_quantity` = 1 ORDER BY `main` DESC16μs33
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY sold DESC LIMIT 0,2012.72ms20
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1958,1794,1953,407,431,376,371,3,328,332,2,5,314,1864,47,256,4,13,1915,335) 25μs24
      • SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (2,3,4,5,13,47,256,318,319,334,339,340,341,344,384,389,420,448,449,1892,1975,2048,2089,2094) AND `for_quantity` = 1 ORDER BY `main` DESC17μs45
      • SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id` 18μs2
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='17' GROUP BY p.id LIMIT 0,5291μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'22μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id` 16μs8
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='56' GROUP BY p.id LIMIT 0,5353μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (804,805,806,807,808) 95μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (902,903,904,905,906) AND `for_quantity` = 1 ORDER BY `main` DESC15μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='58' GROUP BY p.id LIMIT 0,5327μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1291,1344,15906,15920,15934) 90μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'350μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (1389,1442,2469,2483,2497) AND `for_quantity` = 1 ORDER BY `main` DESC18μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='59' GROUP BY p.id LIMIT 0,5256μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'19μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='60' GROUP BY p.id LIMIT 0,5244μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'19μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='61' GROUP BY p.id LIMIT 0,5229μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='62' GROUP BY p.id LIMIT 0,5308μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1027,1029,1033,1035,1039) 87μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'305μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (1125,1127,1131,1133,1137) AND `for_quantity` = 1 ORDER BY `main` DESC19μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='63' GROUP BY p.id LIMIT 0,5331μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1539,1540,1541,1542,1543) 89μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'232μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (1637,1638,1639,1640,1641) AND `for_quantity` = 1 ORDER BY `main` DESC20μs3
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='64' GROUP BY p.id LIMIT 0,5331μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1537,1549,1550,1552,1553) 85μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'160μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (1635,1647,1648,1650,1651) AND `for_quantity` = 1 ORDER BY `main` DESC18μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='18' GROUP BY p.id LIMIT 0,5366μs5
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (3,4,5,7,8) 87μs5
      • SELECT * FROM `attributes` WHERE `type`='quantity'22μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (3,4,5,7,8) AND `for_quantity` = 1 ORDER BY `main` DESC16μs11
      • SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='12' GROUP BY p.id LIMIT 0,30232μs0
      • SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY p.date_update LIMIT 0,1112.53ms11
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) 26μs11
      • SELECT * FROM `attributes` WHERE `type`='quantity'15μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) AND `for_quantity` = 1 ORDER BY `main` DESC16μs33
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY sold DESC LIMIT 0,2012.97ms20
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (1958,1794,1953,407,431,376,371,3,328,332,2,5,314,1864,47,256,4,13,1915,335) 26μs24
      • SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (2,3,4,5,13,47,256,318,319,334,339,340,341,344,384,389,420,448,449,1892,1975,2048,2089,2094) AND `for_quantity` = 1 ORDER BY `main` DESC17μs45
      • SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id` 19μs0
      • SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id LIMIT 0,30824μs30
      • SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32) 172μs30
      • SELECT * FROM `attributes` WHERE `type`='quantity'330μs5
      • SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
      • SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32) AND `for_quantity` = 1 ORDER BY `main` DESC22μs85
      • SELECT * FROM `brands` WHERE `status` =1 ORDER BY `sort_id`21μs6