Home page - Alnasser.com

Messages Request Timeline Exceptions Database350

8.1.31195ms6MB

$_GET: array:1 [ "f" => array:1 [ "c" => "26" ] ]
$_POST: []
$_COOKIE: []
$_SERVER: array:64 [ "USER" => "alnasserstaging" "HOME" => "/home/alnasserstaging" "SCRIPT_NAME" => "/pu...

Booting (9.31ms)
Configs (1.93ms)
Controller (160ms)
1 x Controller (82.06%)
160.34ms
1 x Booting (4.76%)
9.31ms
1 x Configs (0.99%)
1.93ms

350 statements were executed, 234 of which were duplicates, 116 unique174ms✌ Duration

SET NAMES utf8mb4174μs0
SET SESSION sql_mode=''31μs0
SELECT * FROM `i18n_cat` ORDER BY `default_lang` DESC 22μs2
SELECT * FROM `configs`128μs104
SELECT * FROM `countries` ORDER BY `en_name`28μs244
SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id` 81μ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` 14μs0
SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id` 14μs0
SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id` 15μ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` 16μs0
SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 15μ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` 15μs0
SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id` 15μ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` 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` 14μs0
SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id` 15μ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` 16μs0
SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id` 14μ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` 14μs0
SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id` 16μ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` 15μ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` 14μs2
SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id` 14μs8
SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id` 14μs0
SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id` 14μs0
SELECT * FROM `header_ads` WHERE NOW() BETWEEN`date_start` AND `date_expire` AND `status` = 1 ORDER BY `id` DESC Limit 1166μs0
SELECT * FROM `faq_cat` WHERE `status` =117μs2
SELECT * FROM `products_cat` WHERE `id`IN (SELECT `sub_of` FROM `products` WHERE `is_new` = 1) LIMIT 814μs8
SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`21μs6
INSERT INTO `sessions` ( `admins`,`session`,`last_ip` )VALUES( '0','79f6a50d8a43e929ca70d11433deb588','3.137.151.130' )18.34ms1
SELECT * FROM `carts` WHERE `sub_of` IN (190107)130μs0
SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id` 17μs5
SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 14μs5
SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id` 16μ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` 16μ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` 15μ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` 16μs0
SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id` 19μs0
SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id` 18μ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` 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` 13μ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` 16μ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` 16μs0
SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id` 16μ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` 16μs0
SELECT * FROM `faq_cat` WHERE `status` =115μs2
SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`23μs6
SELECT * FROM `products_cat` WHERE `sub_of`=0 AND `status` =1 ORDER BY `sort_id` , `id` 82μ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,30332μ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,1113.17ms11
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)728μs11
SELECT * FROM `attributes` WHERE `type`='quantity'21μ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` DESC19μ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.83ms20
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)296μs24
SELECT * FROM `attributes` WHERE `type`='quantity'821μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 25μ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` DESC22μ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,5397μ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)122μs7
SELECT * FROM `attributes` WHERE `type`='quantity'21μ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` DESC17μ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,5355μ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)291μs8
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 (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` 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` ='40' GROUP BY p.id LIMIT 0,5343μ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)94μs5
SELECT * FROM `attributes` WHERE `type`='quantity'17μ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` DESC14μ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,5360μ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)89μs5
SELECT * FROM `attributes` WHERE `type`='quantity'405μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μ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` DESC15μ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,5414μ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)91μs5
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 (313,380,381,402,1975) AND `for_quantity` = 1 ORDER BY `main` DESC15μs8
SELECT * FROM `products_cat` WHERE `sub_of`=42 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` ='8' GROUP BY p.id LIMIT 0,30239μs0
SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 18μ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.78ms11
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)23μs11
SELECT * FROM `attributes` WHERE `type`='quantity'14μ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.8ms20
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'21μ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` DESC16μs45
SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 19μ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,5397μ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)113μs10
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 (504,2042,505,507,506,2039,508,510,2111,509) AND `for_quantity` = 1 ORDER BY `main` DESC16μs24
SELECT * FROM `products_cat` WHERE `sub_of`=26 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` ='53' GROUP BY p.id LIMIT 0,5331μs4
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (616,620,632,633)116μs4
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 (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` 14μ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,5480μ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)95μs6
SELECT * FROM `attributes` WHERE `type`='quantity'316μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μ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` DESC17μs9
SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id` 14μ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,5357μ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)95μs13
SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μ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` DESC15μ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,5351μ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)267μs7
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 (484,485,511,512,2040,2041,536) AND `for_quantity` = 1 ORDER BY `main` DESC16μ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,5370μ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)94μs9
SELECT * FROM `attributes` WHERE `type`='quantity'515μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μ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` DESC18μs27
SELECT * FROM `products_cat` WHERE `sub_of`=45 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` ='31' GROUP BY p.id LIMIT 0,5329μs4
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (458,613,614,615)92μs10
SELECT * FROM `attributes` WHERE `type`='quantity'17μ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` DESC14μs3
SELECT * FROM `products_cat` WHERE `sub_of`=31 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` ='28' GROUP BY p.id LIMIT 0,5286μs1
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (462)370μs1
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 (491) AND `for_quantity` = 1 ORDER BY `main` DESC14μs2
SELECT * FROM `products_cat` WHERE `sub_of`=28 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` ='32' GROUP BY p.id LIMIT 0,5331μs4
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (481,482,498,499)143μs10
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 (515,517,516,2024,539,601,2050,540,602,2049) AND `for_quantity` = 1 ORDER BY `main` DESC16μs29
SELECT * FROM `products_cat` WHERE `sub_of`=32 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` ='9' GROUP BY p.id LIMIT 0,30231μ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.88ms11
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'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` 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.8ms20
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` 18μ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,5405μ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)109μs16
SELECT * FROM `attributes` WHERE `type`='quantity'238μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 22μ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` DESC17μ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,5367μ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)105μs20
SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μ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` DESC18μs48
SELECT * FROM `products_cat` WHERE `sub_of`=21 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` ='4' GROUP BY p.id LIMIT 0,5323μs2
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (585,681)95μs2
SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (628,779) AND `for_quantity` = 1 ORDER BY `main` DESC14μ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,5327μ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)85μs5
SELECT * FROM `attributes` WHERE `type`='quantity'188μ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` DESC18μ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,5226μs0
SELECT * FROM `attributes` WHERE `type`='quantity'19μ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` 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` ='51' GROUP BY p.id LIMIT 0,5354μ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'17μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μ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` DESC17μs34
SELECT * FROM `products_cat` WHERE `sub_of`=51 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` ='23' GROUP BY p.id LIMIT 0,5323μ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)281μs5
SELECT * FROM `attributes` WHERE `type`='quantity'19μ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` DESC15μs10
SELECT * FROM `products_cat` WHERE `sub_of`=23 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` ='24' GROUP BY p.id LIMIT 0,5346μ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)88μs5
SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μ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,5310μ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)82μs5
SELECT * FROM `attributes` WHERE `type`='quantity'64μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μ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` DESC15μs8
SELECT * FROM `products_cat` WHERE `sub_of`=22 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` ='49' GROUP BY p.id LIMIT 0,5359μ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)99μs17
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 (708,712,716,720,709,713,717,721,710,714,718,722,711,715,719,723,800) AND `for_quantity` = 1 ORDER BY `main` DESC17μs49
SELECT * FROM `products_cat` WHERE `sub_of`=49 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` ='25' GROUP BY p.id LIMIT 0,5268μs1
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (739)296μs1
SELECT * FROM `attributes` WHERE `type`='quantity'20μ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` DESC17μs0
SELECT * FROM `products_cat` WHERE `sub_of`=25 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` ='1' GROUP BY p.id LIMIT 0,30740μ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'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,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` DESC18μ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.68ms11
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)22μ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` 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.68ms20
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` 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` DESC15μs45
SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id` 15μ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,5266μs0
SELECT * FROM `attributes` WHERE `type`='quantity'19μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μs90
SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id` 15μ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,5349μ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)116μs5
SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μ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` DESC13μ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,5333μ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'46μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μ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` 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` ='59' GROUP BY p.id LIMIT 0,5255μ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` ='60' GROUP BY p.id LIMIT 0,5239μ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 AND p.`sub_of` ='61' GROUP BY p.id LIMIT 0,5213μs0
SELECT * FROM `attributes` WHERE `type`='quantity'18μ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` ='62' GROUP BY p.id LIMIT 0,5321μ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)89μs5
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 (1125,1127,1131,1133,1137) AND `for_quantity` = 1 ORDER BY `main` DESC14μ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,5313μ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)149μ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 (1637,1638,1639,1640,1641) AND `for_quantity` = 1 ORDER BY `main` DESC14μ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,5357μ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)159μs5
SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 18μ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` DESC14μ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,5374μ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)93μs5
SELECT * FROM `attributes` WHERE `type`='quantity'17μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μ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` DESC14μs11
SELECT * FROM `products_cat` WHERE `sub_of`=18 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` ='12' GROUP BY p.id LIMIT 0,30234μ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.65ms11
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)23μ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` 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.69ms20
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)22μs24
SELECT * FROM `attributes` WHERE `type`='quantity'16μ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` DESC15μs45
SELECT * FROM `products_cat` WHERE `sub_of`=12 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 GROUP BY p.id LIMIT 0,30777μ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)779μs30
SELECT * FROM `attributes` WHERE `type`='quantity'197μ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` DESC20μs85
SELECT * FROM `brands` WHERE `status` =1 ORDER BY `sort_id`17μs6

{title}

Products

1 x Controller (82.06%)	160.34ms
1 x Booting (4.76%)	9.31ms
1 x Configs (0.99%)	1.93ms

Login

{title}

Products