اغلاق
CMPL SOKO 2G SW 13A 2P WH D3 NEON
1 x Controller (36.42%) | 13.53ms |
1 x Booting (17.72%) | 6.58ms |
1 x Configs (8.43%) | 3.13ms |
SET NAMES utf8mb4
75μs0SET SESSION sql_mode=''
29μs0SELECT * FROM `i18n_cat` ORDER BY `default_lang` DESC
21μs2SELECT * FROM `configs`
26μs104SELECT `origin_column`,`translation` FROM `i18n`
WHERE `sub_of`='3' AND `origin_table`='configs'
22μs22SELECT * FROM `countries` ORDER BY `ar_name`
26μ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`='513'
GROUP BY p.id
LIMIT 0,30
444μs1SELECT
`id`,
`title`,
`description`,
`small_description`,
`variations`,
`sub_of`,
`price`,
`price_before`,
`quantity`
FROM `quantities`
WHERE `sub_of` IN (513)
84μs1SELECT * FROM `attributes`
WHERE `type`='quantity'
1.02ms5SELECT `sub_of`,`cat_id` FROM `attributes_relations`
21μs90SELECT `sub_of`, `file_url`
FROM `products_files`
WHERE `sub_of` IN (554)
AND `for_quantity` = 1
ORDER BY `main` DESC
75μs0SELECT i.`origin_table`, i.`origin_column`, i.`origin_id`, i.`translation`
FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang` = 'ar'
WHERE i.`sub_of` = ic.`id`
AND (i.`origin_table`, i.`origin_column`, i.`origin_id`) IN (('quantities', 'title', '554'),('quantities', 'description', '554'),('quantities', 'small_description', '554'))
1.41ms0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='513' Limit 1
425μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='513' Limit 1
722μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='513' Limit 1
223μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
288μs1SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id`
18μs5SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='37' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id`
16μs5SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='38' Limit 1
13μs1SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id`
18μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='39' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='40' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='41' Limit 1
17μs1SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id`
18μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='42' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='8' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id`
17μs9SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='26' Limit 1
12μs1SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='53' Limit 1
17μs1SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='27' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='29' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='30' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='45' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='31' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='28' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='32' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='9' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id`
17μs11SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='20' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='21' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='4' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='43' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='44' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='51' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id`
18μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='23' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='24' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='22' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='49' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='25' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id`
17μs2SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='17' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id`
17μs8SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='56' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='58' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='59' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='60' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='61' Limit 1
17μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='62' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='63' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='64' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='18' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='12' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT * FROM `header_ads` WHERE NOW() BETWEEN`date_start` AND `date_expire` AND `status` = 1 ORDER BY `id` DESC Limit 1
70μs0SELECT * FROM `faq_cat` WHERE `status` =1
18μs2SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='faq_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='faq_cat'
AND i.`origin_column`='description'
AND i.`origin_id`='1' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='faq_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='2' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='faq_cat'
AND i.`origin_column`='description'
AND i.`origin_id`='2' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `id`IN (SELECT `sub_of` FROM `products` WHERE `is_new` = 1) LIMIT 8
17μs8SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='22' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='27' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='28' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='29' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='38' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='40' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='63' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='22' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='27' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='28' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='29' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='38' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='40' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='63' Limit 1
16μs1SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`
26μs6SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='8' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='9' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='5' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='11' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='12' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='13' Limit 1
14μs1INSERT INTO `sessions` ( `admins`,`session`,`last_ip` )VALUES( '0','6e11317c695635b47e8b2c752f95b973','18.191.50.205' )
1.44ms1SELECT * FROM `carts` WHERE `sub_of` IN (198160)
271μs0SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id`
145μs5SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='37' Limit 1
13μs1SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id`
16μs5SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='38' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=38 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='39' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=39 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='40' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=40 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='41' Limit 1
17μs1SELECT * FROM `products_cat` WHERE `sub_of`=41 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='42' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=42 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='8' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id`
17μs9SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='26' Limit 1
12μs1SELECT * FROM `products_cat` WHERE `sub_of`=26 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='53' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=53 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='27' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=27 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='29' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=29 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='30' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=30 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='45' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=45 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='31' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=31 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='28' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=28 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='32' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=32 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='9' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=9 AND `status` =1 ORDER BY `sort_id` , `id`
17μs11SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='20' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=20 AND `status` =1 ORDER BY `sort_id` , `id`
19μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='21' Limit 1
16μs1SELECT * FROM `products_cat` WHERE `sub_of`=21 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='4' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=4 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='43' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=43 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='44' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=44 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='51' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=51 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='23' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='24' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=24 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='22' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=22 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='49' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=49 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='25' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=25 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=1 AND `status` =1 ORDER BY `sort_id` , `id`
16μs2SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='17' Limit 1
14μs1SELECT * FROM `products_cat` WHERE `sub_of`=17 AND `status` =1 ORDER BY `sort_id` , `id`
17μs8SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='56' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='58' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='59' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='60' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='61' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='62' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='63' Limit 1
17μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='64' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='18' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=18 AND `status` =1 ORDER BY `sort_id` , `id`
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='12' Limit 1
15μs1SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id`
17μs0SELECT * FROM `faq_cat` WHERE `status` =1
15μs2SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`
26μs6SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='8' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='9' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='5' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='11' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='12' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='pages'
AND i.`origin_column`='title'
AND i.`origin_id`='13' Limit 1
14μs1SELECT 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`='513'
GROUP BY p.id
LIMIT 0,30
313μs1SELECT
`id`,
`title`,
`description`,
`small_description`,
`variations`,
`sub_of`,
`price`,
`price_before`,
`quantity`
FROM `quantities`
WHERE `sub_of` IN (513)
19μs1SELECT * FROM `attributes`
WHERE `type`='quantity'
17μs5SELECT `sub_of`,`cat_id` FROM `attributes_relations`
15μs90SELECT `sub_of`, `file_url`
FROM `products_files`
WHERE `sub_of` IN (554)
AND `for_quantity` = 1
ORDER BY `main` DESC
13μs0SELECT i.`origin_table`, i.`origin_column`, i.`origin_id`, i.`translation`
FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang` = 'ar'
WHERE i.`sub_of` = ic.`id`
AND (i.`origin_table`, i.`origin_column`, i.`origin_id`) IN (('quantities', 'title', '554'),('quantities', 'description', '554'),('quantities', 'small_description', '554'))
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='513' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='513' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='513' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT `file_url` FROM `products_files` WHERE `for_quantity` = 0 AND `sub_of` ='513' ORDER BY `main` DESC
73μs0SELECT 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 ORDER BY 5
LIMIT 0,30
7.29ms30SELECT
`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)
23μs30SELECT * FROM `attributes`
WHERE `type`='quantity'
16μs5SELECT `sub_of`,`cat_id` FROM `attributes_relations`
16μs90SELECT `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` DESC
17μs89SELECT i.`origin_table`, i.`origin_column`, i.`origin_id`, i.`translation`
FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang` = 'ar'
WHERE i.`sub_of` = ic.`id`
AND (i.`origin_table`, i.`origin_column`, i.`origin_id`) IN (('quantities', 'title', '2'),('quantities', 'description', '2'),('quantities', 'small_description', '2'),('quantities', 'title', '6'),('quantities', 'description', '6'),('quantities', 'small_description', '6'),('quantities', 'title', '12'),('quantities', 'description', '12'),('quantities', 'small_description', '12'),('quantities', 'title', '23'),('quantities', 'description', '23'),('quantities', 'small_description', '23'),('quantities', 'title', '25'),('quantities', 'description', '25'),('quantities', 'small_description', '25'),('quantities', 'title', '26'),('quantities', 'description', '26'),('quantities', 'small_description', '26'),('quantities', 'title', '27'),('quantities', 'description', '27'),('quantities', 'small_description', '27'),('quantities', 'title', '28'),('quantities', 'description', '28'),('quantities', 'small_description', '28'),('quantities', 'title', '29'),('quantities', 'description', '29'),('quantities', 'small_description', '29'),('quantities', 'title', '30'),('quantities', 'description', '30'),('quantities', 'small_description', '30'),('quantities', 'title', '31'),('quantities', 'description', '31'),('quantities', 'small_description', '31'),('quantities', 'title', '32'),('quantities', 'description', '32'),('quantities', 'small_description', '32'),('quantities', 'title', '33'),('quantities', 'description', '33'),('quantities', 'small_description', '33'),('quantities', 'title', '34'),('quantities', 'description', '34'),('quantities', 'small_description', '34'),('quantities', 'title', '35'),('quantities', 'description', '35'),('quantities', 'small_description', '35'),('quantities', 'title', '36'),('quantities', 'description', '36'),('quantities', 'small_description', '36'),('quantities', 'title', '37'),('quantities', 'description', '37'),('quantities', 'small_description', '37'),('quantities', 'title', '38'),('quantities', 'description', '38'),('quantities', 'small_description', '38'),('quantities', 'title', '39'),('quantities', 'description', '39'),('quantities', 'small_description', '39'),('quantities', 'title', '40'),('quantities', 'description', '40'),('quantities', 'small_description', '40'),('quantities', 'title', '41'),('quantities', 'description', '41'),('quantities', 'small_description', '41'),('quantities', 'title', '42'),('quantities', 'description', '42'),('quantities', 'small_description', '42'),('quantities', 'title', '43'),('quantities', 'description', '43'),('quantities', 'small_description', '43'),('quantities', 'title', '44'),('quantities', 'description', '44'),('quantities', 'small_description', '44'),('quantities', 'title', '45'),('quantities', 'description', '45'),('quantities', 'small_description', '45'),('quantities', 'title', '46'),('quantities', 'description', '46'),('quantities', 'small_description', '46'),('quantities', 'title', '47'),('quantities', 'description', '47'),('quantities', 'small_description', '47'),('quantities', 'title', '48'),('quantities', 'description', '48'),('quantities', 'small_description', '48'),('quantities', 'title', '49'),('quantities', 'description', '49'),('quantities', 'small_description', '49'),('quantities', 'title', '50'),('quantities', 'description', '50'),('quantities', 'small_description', '50'))
25μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='2' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='2' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='2' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='6' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='6' Limit 1
17μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='6' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='12' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='12' Limit 1
17μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='12' Limit 1
17μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='23' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='23' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='23' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='25' Limit 1
16μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='25' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='25' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='26' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='26' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='26' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='27' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='27' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='27' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='28' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='28' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='28' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='29' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='29' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='29' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='30' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='30' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='30' Limit 1
13μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='31' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='31' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='31' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='32' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='32' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='32' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='33' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='33' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='33' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='34' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='34' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='34' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='35' Limit 1
27μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='35' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='35' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='36' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='36' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='36' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='37' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='37' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='37' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='38' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='38' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='38' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='39' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='39' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='39' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='40' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='40' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='40' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='41' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='41' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='41' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='42' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='42' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='42' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='43' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='43' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='43' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='44' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='44' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='44' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='45' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='45' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='45' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='46' Limit 1
14μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='46' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='46' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
15μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='47' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='47' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='47' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='48' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='48' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='48' Limit 1
17μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='49' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='49' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='49' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
14μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='title'
AND i.`origin_id`='50' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='description'
AND i.`origin_id`='50' Limit 1
15μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products'
AND i.`origin_column`='about'
AND i.`origin_id`='50' Limit 1
16μs0SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
13μs1SELECT * FROM `attributes_products` p LEFT JOIN `attributes` a ON a.`id`=p.`sub_of`
WHERE p.`product_id`= 513 ORDER BY a.`sort_id`
1.95ms3SELECT
( SELECT `id` FROM `products` WHERE `id` >513 LIMIT 1 ) AS next_value,
( SELECT `id` FROM `products` WHERE `id` <513 ORDER BY `id` DESC LIMIT 1 ) AS prev_value
FROM `products` Limit 1
352μ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` =513 AND c.`status` = 1 Limit 1
206μs1SELECT i.`translation` FROM `i18n` i
LEFT JOIN `i18n_cat` ic ON ic.`lang`='ar'
WHERE i.`sub_of`=ic.`id`
AND i.`origin_table`='products_cat'
AND i.`origin_column`='name'
AND i.`origin_id`='1' Limit 1
299μs1SELECT `name`,`id`,`sub_of` FROM `products_cat`
WHERE `id` =0 AND `status` = 1 Limit 1
18μs0SELECT * FROM `quantities` WHERE `sub_of` =513
63μs1SELECT * FROM `attributes`
WHERE `type`='quantity' ORDER BY `sort_id`
203μs5SELECT * FROM `reviews`
WHERE `status`=1 AND `sub_of`=513
57μs0