Home page - Alnasser.com

Messages Request Timeline Exceptions Database350

8.1.31207ms6MB

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

Booting (6.56ms)
Configs (2.39ms)
Controller (171ms)
1 x Controller (82.31%)
170.76ms
1 x Booting (3.16%)
6.56ms
1 x Configs (1.15%)
2.39ms

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

SET NAMES utf8mb4137μs0
SET SESSION sql_mode=''58μs0
SELECT * FROM `i18n_cat` ORDER BY `default_lang` DESC 39μs2
SELECT * FROM `configs`186μs104
SELECT * FROM `countries` ORDER BY `en_name`51μs244
SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id` 92μs5
SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 74μs5
SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id` 35μs0
SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id` 31μs0
SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 34μs9
SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id` 29μs0
SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id` 35μs0
SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id` 35μs0
SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id` 34μs11
SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id` 32μs0
SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id` 34μs2
SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id` 32μs8
SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id` 28μs0
SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `header_ads` WHERE NOW() BETWEEN`date_start` AND `date_expire` AND `status` = 1 ORDER BY `id` DESC Limit 1178μs0
SELECT * FROM `faq_cat` WHERE `status` =135μs2
SELECT * FROM `products_cat` WHERE `id`IN (SELECT `sub_of` FROM `products` WHERE `is_new` = 1) LIMIT 834μs8
SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`41μs6
INSERT INTO `sessions` ( `admins`,`session`,`last_ip` )VALUES( '0','90ff4c5e59c6a07c8c79ebb505017d56','3.148.106.39' )18.79ms1
SELECT * FROM `carts` WHERE `sub_of` IN (189741)207μs0
SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id` 577μs5
SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 38μs5
SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id` 30μs0
SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id` 32μs0
SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id` 32μs0
SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id` 33μs0
SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 34μs9
SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id` 28μs0
SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id` 34μs0
SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id` 41μs0
SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id` 112μs0
SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id` 40μs0
SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id` 39μs0
SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id` 28μs0
SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id` 28μs11
SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id` 25μs0
SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id` 26μs0
SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id` 25μs0
SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id` 26μs0
SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id` 25μs0
SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id` 25μs0
SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id` 26μs0
SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id` 23μs0
SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id` 25μs0
SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id` 23μs0
SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id` 26μs0
SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id` 26μs2
SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id` 26μs8
SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id` 25μs0
SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id` 26μs0
SELECT * FROM `faq_cat` WHERE `status` =125μs2
SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`53μs6
SELECT * FROM `products_cat` WHERE `sub_of`=0 AND `status` =1 ORDER BY `sort_id` , `id` 33μ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,30624μs0
SELECT * FROM `attributes` WHERE `type`='quantity'42μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 35μ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,1115.42ms11
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)223μs11
SELECT * FROM `attributes` WHERE `type`='quantity'459μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 21μ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.92ms20
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)234μs24
SELECT * FROM `attributes` WHERE `type`='quantity'330μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 19μ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` DESC18μs45
SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 84μ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,5456μ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)98μs7
SELECT * FROM `attributes` WHERE `type`='quantity'273μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (316,317,318,319,321,322,331) AND `for_quantity` = 1 ORDER BY `main` DESC18μs16
SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id` 20μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='39' GROUP BY p.id LIMIT 0,5377μ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)92μs8
SELECT * FROM `attributes` WHERE `type`='quantity'213μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (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,5346μ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)91μs5
SELECT * FROM `attributes` WHERE `type`='quantity'241μ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` DESC16μs10
SELECT * FROM `products_cat` WHERE `sub_of`=40 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` ='41' GROUP BY p.id LIMIT 0,5380μ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'55μ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` DESC16μs8
SELECT * FROM `products_cat` WHERE `sub_of`=41 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` ='42' GROUP BY p.id LIMIT 0,5416μ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)96μs5
SELECT * FROM `attributes` WHERE `type`='quantity'73μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μ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,30251μs0
SELECT * FROM `attributes` WHERE `type`='quantity'19μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY p.date_update LIMIT 0,1112.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)21μs11
SELECT * FROM `attributes` WHERE `type`='quantity'15μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35) AND `for_quantity` = 1 ORDER BY `main` DESC15μs33
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY sold DESC LIMIT 0,2012.27ms20
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'15μ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`=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,5379μ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)97μs10
SELECT * FROM `attributes` WHERE `type`='quantity'413μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μ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` DESC15μs24
SELECT * FROM `products_cat` WHERE `sub_of`=26 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` ='53' GROUP BY p.id LIMIT 0,5321μs4
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (616,620,632,633)93μs4
SELECT * FROM `attributes` WHERE `type`='quantity'39μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (688,692,704,705) AND `for_quantity` = 1 ORDER BY `main` DESC16μs8
SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id` 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,5452μ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)88μs6
SELECT * FROM `attributes` WHERE `type`='quantity'156μ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` DESC14μ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,5340μ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)93μs13
SELECT * FROM `attributes` WHERE `type`='quantity'129μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (440,441,442,445,446,447,450,461,462,463,465,466,2023) AND `for_quantity` = 1 ORDER BY `main` DESC16μs34
SELECT * FROM `products_cat` WHERE `sub_of`=29 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` ='30' GROUP BY p.id LIMIT 0,5332μ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)88μs7
SELECT * FROM `attributes` WHERE `type`='quantity'190μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (484,485,511,512,2040,2041,536) AND `for_quantity` = 1 ORDER BY `main` DESC15μs7
SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id` 20μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='45' GROUP BY p.id LIMIT 0,5380μ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)86μs9
SELECT * FROM `attributes` WHERE `type`='quantity'223μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μ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` DESC15μs27
SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='31' GROUP BY p.id LIMIT 0,5321μs4
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (458,613,614,615)88μs10
SELECT * FROM `attributes` WHERE `type`='quantity'150μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μ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` DESC15μs3
SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='28' GROUP BY p.id LIMIT 0,5277μs1
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (462)65μs1
SELECT * FROM `attributes` WHERE `type`='quantity'260μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (491) AND `for_quantity` = 1 ORDER BY `main` DESC15μs2
SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id` 15μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='32' GROUP BY p.id LIMIT 0,5312μs4
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (481,482,498,499)84μs10
SELECT * FROM `attributes` WHERE `type`='quantity'74μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (515,517,516,2024,539,601,2050,540,602,2049) AND `for_quantity` = 1 ORDER BY `main` DESC15μ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,30226μs0
SELECT * FROM `attributes` WHERE `type`='quantity'19μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 GROUP BY p.id ORDER BY p.date_update LIMIT 0,1112.15ms11
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (23,26,27,28,29,30,31,32,33,34,35)21μs11
SELECT * FROM `attributes` WHERE `type`='quantity'14μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 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.56ms20
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)115μs24
SELECT * FROM `attributes` WHERE `type`='quantity'105μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 89μ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` DESC90μs45
SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id` 28μ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,5528μ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)159μs16
SELECT * FROM `attributes` WHERE `type`='quantity'227μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 19μ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` DESC91μs47
SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id` 42μ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,5461μ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)241μs20
SELECT * FROM `attributes` WHERE `type`='quantity'20μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μ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` DESC17μs48
SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id` 20μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='4' GROUP BY p.id LIMIT 0,5326μs2
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (585,681)80μs2
SELECT * FROM `attributes` WHERE `type`='quantity'319μ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` DESC15μ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,5362μ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)89μs5
SELECT * FROM `attributes` WHERE `type`='quantity'374μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μ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` DESC17μs11
SELECT * FROM `products_cat` WHERE `sub_of`=43 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` ='44' GROUP BY p.id LIMIT 0,5260μs0
SELECT * FROM `attributes` WHERE `type`='quantity'20μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 19μs90
SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id` 64μ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,5355μ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)103μs12
SELECT * FROM `attributes` WHERE `type`='quantity'278μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT `sub_of`, `file_url` FROM `products_files` WHERE `sub_of` IN (631,632,636,639,646,633,637,640,647,634,635,645) AND `for_quantity` = 1 ORDER BY `main` DESC20μs34
SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id` 18μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='23' GROUP BY p.id LIMIT 0,5348μ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)86μs5
SELECT * FROM `attributes` WHERE `type`='quantity'62μ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` 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` ='24' GROUP BY p.id LIMIT 0,5340μs5
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (623,624,625,626,627)86μs5
SELECT * FROM `attributes` WHERE `type`='quantity'175μ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` DESC16μs5
SELECT * FROM `products_cat` WHERE `sub_of`=24 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` ='22' GROUP BY p.id LIMIT 0,5331μs5
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (414,415,419,422,423)85μs5
SELECT * FROM `attributes` WHERE `type`='quantity'300μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 20μ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` DESC14μs8
SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id` 20μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='49' GROUP BY p.id LIMIT 0,5350μs5
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (636,637,638,639,702)97μs17
SELECT * FROM `attributes` WHERE `type`='quantity'246μ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` DESC16μs49
SELECT * FROM `products_cat` WHERE `sub_of`=49 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` ='25' GROUP BY p.id LIMIT 0,5275μs1
SELECT `id`, `title`, `description`, `small_description`, `variations`, `sub_of`, `price`, `price_before`, `quantity` FROM `quantities` WHERE `sub_of` IN (739)69μs1
SELECT * FROM `attributes` WHERE `type`='quantity'268μ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` DESC15μ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,30764μ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)149μs30
SELECT * FROM `attributes` WHERE `type`='quantity'288μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μ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,1118.93ms11
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)27μs11
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 (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.96ms20
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)24μs24
SELECT * FROM `attributes` WHERE `type`='quantity'18μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 19μ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` DESC45μs45
SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id` 79μ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,5326μs0
SELECT * FROM `attributes` WHERE `type`='quantity'20μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id` 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,5384μ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)98μs5
SELECT * FROM `attributes` WHERE `type`='quantity'83μ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` DESC15μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='58' GROUP BY p.id LIMIT 0,5330μ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)93μs5
SELECT * FROM `attributes` WHERE `type`='quantity'48μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 22μ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` DESC16μ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,5263μs0
SELECT * FROM `attributes` WHERE `type`='quantity'20μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='60' GROUP BY p.id LIMIT 0,5249μ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` ='61' GROUP BY p.id LIMIT 0,5219μ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,5311μ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)93μs5
SELECT * FROM `attributes` WHERE `type`='quantity'23μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 17μ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` DESC15μs0
SELECT p.id,p.`slug`,p.external_id,p.youtube_url,p.3d_url,p.spec_sheet,p.sku,p.date_update,p.warranty, p.about,p.description,p.cashback,p.title,d.name AS brand, d.id AS brand_id,p.sub_of,p.tags,p.stock,p.low_stock,p.cost,p.sub_of,IF(od.s,od.s,0) AS sold, (r.`value_rating` + r.`quality_rating` + r.`price_rating`) /3 AS avg, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` = 1 ORDER BY RAND() limit 1) as `pic_url`, (SELECT `file_url` FROM `products_files` WHERE `sub_of` = p.`id` and `for_quantity` = 0 AND `main` != 1 limit 1) as `file_url`, q.price AS priceMin,q.price AS commercial_price,q.price_before AS market_price, pc.name AS category,pc.id AS `category_id` FROM `products` p LEFT JOIN quantities q ON ( q.sub_of = p.id and q.price = (SELECT MIN(`price`) FROM quantities WHERE `sub_of` = p.id)) LEFT JOIN `products_cat` pc ON pc.id= p.sub_of LEFT JOIN `brands` d ON p.`brand_id` = d.`id` LEFT JOIN `reviews` r ON r.`sub_of` = p.`id` LEFT JOIN (SELECT product_id,IF(SUM(quantity),SUM(quantity),0) AS s FROM `orders_data` WHERE `sub_of` IN ( SELECT `id` FROM `orders` WHERE `status` < 4 ) GROUP BY product_id ) od ON od.`product_id` = p.`id` WHERE p.`status` = 1 AND pc.`status`= 1 AND p.`sub_of` ='63' GROUP BY p.id LIMIT 0,5337μ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)83μs5
SELECT * FROM `attributes` WHERE `type`='quantity'27μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 18μ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` DESC15μ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,5328μ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)84μs5
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 (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,5382μ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)113μs5
SELECT * FROM `attributes` WHERE `type`='quantity'48μs5
SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μ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` DESC15μ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,30245μ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 GROUP BY p.id ORDER BY p.date_update LIMIT 0,1112.81ms11
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` 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.88ms20
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)24μ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,30785μ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)158μs30
SELECT * FROM `attributes` WHERE `type`='quantity'406μ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,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` DESC19μs85
SELECT * FROM `brands` WHERE `status` =1 ORDER BY `sort_id`17μs6

{title}

Products

1 x Controller (82.31%)	170.76ms
1 x Booting (3.16%)	6.56ms
1 x Configs (1.15%)	2.39ms

Login

{title}

Products