Close
WALL-S INT-X13W-LED-3000K GR PEDRAZA
1 x Booting (24.2%) | 9.30ms |
1 x Controller (20.42%) | 7.85ms |
1 x Configs (8.22%) | 3.16ms |
SET NAMES utf8mb4
69μs0SET SESSION sql_mode=''
41μs0SELECT * FROM `i18n_cat` ORDER BY `default_lang` DESC
31μs2SELECT * FROM `configs`
103μs104SELECT * FROM `countries` ORDER BY `en_name`
52μs244SELECT 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.`id`='1875'
GROUP BY p.id
LIMIT 0,30
513μs1SELECT
`id`,
`title`,
`description`,
`small_description`,
`variations`,
`sub_of`,
`price`,
`price_before`,
`quantity`
FROM `quantities`
WHERE `sub_of` IN (1875)
128μs1SELECT * FROM `attributes`
WHERE `type`='quantity'
443μs5SELECT `sub_of`,`cat_id` FROM `attributes_relations`
25μs90SELECT `sub_of`, `file_url`
FROM `products_files`
WHERE `sub_of` IN (1988)
AND `for_quantity` = 1
ORDER BY `main` DESC
24μs0SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id`
28μs5SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id`
20μs5SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id`
21μs0SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id`
22μs0SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id`
23μs9SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id`
19μs0SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id`
22μs0SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id`
22μs0SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id`
26μs0SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id`
25μs11SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id`
19μs0SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id`
22μs0SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id`
22μs0SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id`
22μs0SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id`
22μs0SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id`
24μs0SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id`
25μs2SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id`
22μs8SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id`
18μs0SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id`
23μs0SELECT * FROM `header_ads` WHERE NOW() BETWEEN`date_start` AND `date_expire` AND `status` = 1 ORDER BY `id` DESC Limit 1
111μs0SELECT * FROM `faq_cat` WHERE `status` =1
22μs2SELECT * FROM `products_cat` WHERE `id`IN (SELECT `sub_of` FROM `products` WHERE `is_new` = 1) LIMIT 8
22μs8SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`
28μs6INSERT INTO `sessions` ( `admins`,`session`,`last_ip` )VALUES( '0','f7b6fa9ab00db9fff044dbca8c178b5b','18.220.173.236' )
7.72ms1SELECT * FROM `carts` WHERE `sub_of` IN (199869)
241μs0SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id`
208μs5SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id`
40μs5SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id`
49μs0SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id`
25μs0SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id`
13μs0SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id`
15μs0SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id`
15μs0SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id`
17μs9SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id`
15μs0SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id`
61μs0SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id`
117μs0SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id`
113μs0SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id`
119μs0SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id`
77μs0SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id`
76μs0SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id`
81μs0SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id`
33μs0SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id`
32μs11SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id`
32μs0SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id`
32μs0SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id`
37μs0SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id`
34μs0SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id`
33μs0SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id`
33μs0SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id`
32μs0SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id`
33μs0SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id`
32μs0SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id`
33μs0SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id`
33μs0SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id`
33μs2SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id`
30μs8SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id`
32μs0SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id`
32μs0SELECT * FROM `faq_cat` WHERE `status` =1
32μs2SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`
47μs6SELECT 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.`id`='1875'
GROUP BY p.id
LIMIT 0,30
754μs1SELECT
`id`,
`title`,
`description`,
`small_description`,
`variations`,
`sub_of`,
`price`,
`price_before`,
`quantity`
FROM `quantities`
WHERE `sub_of` IN (1875)
42μs1SELECT * FROM `attributes`
WHERE `type`='quantity'
39μs5SELECT `sub_of`,`cat_id` FROM `attributes_relations`
34μs90SELECT `sub_of`, `file_url`
FROM `products_files`
WHERE `sub_of` IN (1988)
AND `for_quantity` = 1
ORDER BY `main` DESC
34μs0SELECT `file_url` FROM `products_files` WHERE `for_quantity` = 0 AND `sub_of` ='1875' ORDER BY `main` DESC
168μs3SELECT 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 ORDER BY 5
LIMIT 0,30
2.27ms30SELECT
`id`,
`title`,
`description`,
`small_description`,
`variations`,
`sub_of`,
`price`,
`price_before`,
`quantity`
FROM `quantities`
WHERE `sub_of` IN (426,428,429,434,435,436,439,440,442,444,445,448,449,451,460,461,465,466,468,469,470,471,485,489,490,494,495,497,1828,1839)
72μs43SELECT * FROM `attributes`
WHERE `type`='quantity'
37μs5SELECT `sub_of`,`cat_id` FROM `attributes_relations`
103μs90SELECT `sub_of`, `file_url`
FROM `products_files`
WHERE `sub_of` IN (439,443,444,452,453,454,457,458,459,464,467,468,474,475,478,1983,489,490,497,498,500,501,502,2038,503,1995,522,523,1959,527,528,532,533,534,535,1961,2045,2046,2047,537,538,1926,1938)
AND `for_quantity` = 1
ORDER BY `main` DESC
38μs84SELECT * FROM `attributes_products` p LEFT JOIN `attributes` a ON a.`id`=p.`sub_of`
WHERE p.`product_id`= 1875 ORDER BY a.`sort_id`
2.14ms9SELECT
( SELECT `id` FROM `products` WHERE `id` >1875 LIMIT 1 ) AS next_value,
( SELECT `id` FROM `products` WHERE `id` <1875 ORDER BY `id` DESC LIMIT 1 ) AS prev_value
FROM `products` Limit 1
210μs1SELECT c.`name`,c.`id`,c.`sub_of` FROM `products` p
LEFT JOIN `products_cat` c ON p.`sub_of` = c.`id`
WHERE p.`id` =1875 AND c.`status` = 1 Limit 1
157μs1SELECT `name`,`id`,`sub_of` FROM `products_cat`
WHERE `id` =8 AND `status` = 1 Limit 1
38μs1SELECT * FROM `quantities` WHERE `sub_of` =1875
129μs1SELECT * FROM `attributes`
WHERE `type`='quantity' ORDER BY `sort_id`
112μs5SELECT * FROM `reviews`
WHERE `status`=1 AND `sub_of`=1875
137μs0