مفتاح كبس مفرد دركسيون ابيض اي3
| 1 x Controller (30.47%) | 12.65ms |
| 1 x Booting (15.73%) | 6.53ms |
| 1 x Configs (7.99%) | 3.31ms |
الإنارة الديكورية 
إنارة معلقة 
إنارة جدارية 
إنارة سقفية 
إنارة طاولة 
إنارة ستاند 
إنارة سقفية خارجية 
سبوت لايت خارجي 
إنارة جدارية خارجية 
أعمدة الحدائق 
إنارة غرس 
إنارة أرضية غاطسة 
إنارة الإسقاط 
إنارة فوق السور 
انارة جدارية للدرج 
داون لايت (سي او بي ) 
داون لايت مانع للتوهج 
داون لايت 
داون لايت ( بانل ) 
لمبات ليد 
الإنارة المخفية 
إطار سبوت لايت 
المحولات 
بيركر 
آرت دي إن أيه SET NAMES utf8mb4131μs0SET SESSION sql_mode=''33μs0SELECT * FROM `i18n_cat` ORDER BY `default_lang` DESC 23μs2SELECT * FROM `configs`87μs104SELECT `origin_column`,`translation` FROM `i18n`
WHERE `sub_of`='3' AND `origin_table`='configs'18μs22SELECT * FROM `countries` ORDER BY `ar_name`25μ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`='7'
GROUP BY p.id
LIMIT 0,30486μs1SELECT
`id`,
`title`,
`description`,
`small_description`,
`variations`,
`sub_of`,
`price`,
`price_before`,
`quantity`
FROM `quantities`
WHERE `sub_of` IN (7) 86μs1SELECT * FROM `attributes`
WHERE `type`='quantity'18μs5SELECT `sub_of`,`cat_id` FROM `attributes_relations` 14μs90SELECT `sub_of`, `file_url`
FROM `products_files`
WHERE `sub_of` IN (7)
AND `for_quantity` = 1
ORDER BY `main` DESC70μ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', '7'),('quantities', 'description', '7'),('quantities', 'small_description', '7'))118μ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`='7' Limit 1114μ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`='7' Limit 169μ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`='7' Limit 165μ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 116μ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 114μs1SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 17μ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 115μ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 115μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=40 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`='41' Limit 115μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=42 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`='8' Limit 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 18μ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 112μs1SELECT * FROM `products_cat` WHERE `sub_of`=26 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`='53' Limit 115μ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 114μ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 114μ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 114μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=45 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`='31' Limit 115μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=28 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`='32' Limit 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=32 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`='9' Limit 116μ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 114μ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 115μ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 114μ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 116μs1SELECT * FROM `products_cat` WHERE `sub_of`=43 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`='44' Limit 115μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=51 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`='23' Limit 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=23 AND `status` =1 ORDER BY `sort_id` , `id` 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`='24' Limit 114μ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 115μ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 115μ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 115μ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 115μ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 117μ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 113μ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 116μ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 116μ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 115μ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 116μ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 115μ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 115μ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 115μ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 115μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id` 16μs0SELECT * FROM `header_ads` WHERE NOW() BETWEEN`date_start` AND `date_expire` AND `status` = 1 ORDER BY `id` DESC Limit 168μs0SELECT * FROM `faq_cat` WHERE `status` =115μ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 114μ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 116μ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 115μ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 115μs1SELECT * FROM `products_cat` WHERE `id`IN (SELECT `sub_of` FROM `products` WHERE `is_new` = 1) LIMIT 817μ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 111μ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 115μ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 115μ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 115μ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 115μ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 116μ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 115μ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 115μ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 115μ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 115μ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 115μ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 116μ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 115μ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 116μ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 115μ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 115μs1SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`27μ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 116μ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 116μ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 116μ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 114μ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 114μ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 114μs1INSERT INTO `sessions` ( `admins`,`session`,`last_ip` )VALUES( '0','225daab8db26151eed8336aa41a8d2a5','52.14.114.234' )10.34ms1SELECT * FROM `carts` WHERE `sub_of` IN (198168)144μs0SELECT * FROM `products_cat` WHERE `sub_of` = 0 AND `status` =1 ORDER BY `sort_id` , `id` 88μ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 185μs1SELECT * FROM `products_cat` WHERE `sub_of`=37 AND `status` =1 ORDER BY `sort_id` , `id` 19μ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 114μ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 114μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=40 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`='41' Limit 115μ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 115μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=8 AND `status` =1 ORDER BY `sort_id` , `id` 18μ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 112μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=53 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`='27' Limit 115μ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 115μ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 115μ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 116μs1SELECT * FROM `products_cat` WHERE `sub_of`=45 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`='31' Limit 116μ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 119μ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 115μ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 115μ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 114μ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 115μ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 115μ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 116μs1SELECT * FROM `products_cat` WHERE `sub_of`=43 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`='44' Limit 115μ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 116μ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 115μ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 114μ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 115μ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 115μ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 115μs1SELECT * FROM `products_cat` WHERE `sub_of`=25 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`='1' Limit 115μ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 114μ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 114μ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 116μ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 116μ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 116μ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 116μ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 116μ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 116μ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 117μ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 115μ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 116μs1SELECT * FROM `products_cat` WHERE `sub_of`=12 AND `status` =1 ORDER BY `sort_id` , `id` 17μs0SELECT * FROM `faq_cat` WHERE `status` =115μs2SELECT * FROM `pages` WHERE `status` =1 ORDER BY `sort_id`27μ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 114μ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 114μ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 114μ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 113μ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 114μ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 114μ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`='7'
GROUP BY p.id
LIMIT 0,30331μs1SELECT
`id`,
`title`,
`description`,
`small_description`,
`variations`,
`sub_of`,
`price`,
`price_before`,
`quantity`
FROM `quantities`
WHERE `sub_of` IN (7) 20μs1SELECT * FROM `attributes`
WHERE `type`='quantity'18μs5SELECT `sub_of`,`cat_id` FROM `attributes_relations` 15μs90SELECT `sub_of`, `file_url`
FROM `products_files`
WHERE `sub_of` IN (7)
AND `for_quantity` = 1
ORDER BY `main` DESC14μ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', '7'),('quantities', 'description', '7'),('quantities', 'small_description', '7'))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`='title'
AND i.`origin_id`='7' Limit 114μ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`='7' Limit 116μ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`='7' Limit 115μ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 114μs1SELECT `file_url` FROM `products_files` WHERE `for_quantity` = 0 AND `sub_of` ='7' ORDER BY `main` DESC75μ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`=18
GROUP BY p.id ORDER BY 5
LIMIT 0,30821μs19SELECT
`id`,
`title`,
`description`,
`small_description`,
`variations`,
`sub_of`,
`price`,
`price_before`,
`quantity`
FROM `quantities`
WHERE `sub_of` IN (3,4,5,7,8,9,10,11,13,14,15,16,18,19,20,21,22,24,54) 151μs19SELECT * FROM `attributes`
WHERE `type`='quantity'465μs5SELECT `sub_of`,`cat_id` FROM `attributes_relations` 16μs90SELECT `sub_of`, `file_url`
FROM `products_files`
WHERE `sub_of` IN (3,4,5,7,8,9,10,11,13,14,15,16,18,19,20,21,22,24,54)
AND `for_quantity` = 1
ORDER BY `main` DESC413μs53SELECT 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', '3'),('quantities', 'description', '3'),('quantities', 'small_description', '3'),('quantities', 'title', '4'),('quantities', 'description', '4'),('quantities', 'small_description', '4'),('quantities', 'title', '5'),('quantities', 'description', '5'),('quantities', 'small_description', '5'),('quantities', 'title', '7'),('quantities', 'description', '7'),('quantities', 'small_description', '7'),('quantities', 'title', '8'),('quantities', 'description', '8'),('quantities', 'small_description', '8'),('quantities', 'title', '9'),('quantities', 'description', '9'),('quantities', 'small_description', '9'),('quantities', 'title', '10'),('quantities', 'description', '10'),('quantities', 'small_description', '10'),('quantities', 'title', '11'),('quantities', 'description', '11'),('quantities', 'small_description', '11'),('quantities', 'title', '13'),('quantities', 'description', '13'),('quantities', 'small_description', '13'),('quantities', 'title', '14'),('quantities', 'description', '14'),('quantities', 'small_description', '14'),('quantities', 'title', '15'),('quantities', 'description', '15'),('quantities', 'small_description', '15'),('quantities', 'title', '16'),('quantities', 'description', '16'),('quantities', 'small_description', '16'),('quantities', 'title', '18'),('quantities', 'description', '18'),('quantities', 'small_description', '18'),('quantities', 'title', '19'),('quantities', 'description', '19'),('quantities', 'small_description', '19'),('quantities', 'title', '20'),('quantities', 'description', '20'),('quantities', 'small_description', '20'),('quantities', 'title', '21'),('quantities', 'description', '21'),('quantities', 'small_description', '21'),('quantities', 'title', '22'),('quantities', 'description', '22'),('quantities', 'small_description', '22'),('quantities', 'title', '24'),('quantities', 'description', '24'),('quantities', 'small_description', '24'),('quantities', 'title', '54'),('quantities', 'description', '54'),('quantities', 'small_description', '54'))348μ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`='3' Limit 188μ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`='3' Limit 1412μ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`='3' Limit 1433μ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 118μ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`='4' Limit 177μ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`='4' Limit 181μ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`='4' Limit 157μ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 116μ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`='5' Limit 170μ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`='5' Limit 1246μ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`='5' Limit 1350μ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 116μ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`='7' Limit 114μ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`='7' Limit 116μ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`='7' Limit 115μ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 114μ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`='8' Limit 173μ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`='8' Limit 172μ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`='8' Limit 156μ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 114μ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`='9' Limit 155μ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`='9' Limit 1234μ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`='9' Limit 1218μ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 116μ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`='10' Limit 189μ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`='10' Limit 167μ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`='10' Limit 152μ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 114μ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`='11' Limit 155μ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`='11' Limit 1261μ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`='11' Limit 1133μ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 116μ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`='13' Limit 1134μ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`='13' Limit 160μ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`='13' Limit 159μ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 114μ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`='14' Limit 154μ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`='14' Limit 151μ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`='14' Limit 1178μ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 116μ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`='15' Limit 1136μ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`='15' Limit 1128μ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`='15' Limit 159μ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 115μ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`='16' Limit 157μ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`='16' Limit 152μ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`='16' Limit 151μ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 116μ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`='18' Limit 1147μ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`='18' Limit 1132μ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`='18' Limit 1134μ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 116μ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`='19' Limit 190μ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`='19' Limit 1119μ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`='19' Limit 154μ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 115μ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`='20' Limit 155μ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`='20' Limit 1175μ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`='20' Limit 1141μ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 116μ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`='21' Limit 1147μ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`='21' Limit 174μ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`='21' Limit 154μ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 115μ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`='22' Limit 156μ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`='22' Limit 152μ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`='22' Limit 1204μ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 116μ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`='24' Limit 1160μ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`='24' Limit 1171μ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`='24' Limit 175μ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 116μ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`='54' Limit 160μ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`='54' Limit 154μ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`='54' Limit 148μ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`='18' Limit 122μs1SELECT * FROM `attributes_products` p LEFT JOIN `attributes` a ON a.`id`=p.`sub_of`
WHERE p.`product_id`= 7 ORDER BY a.`sort_id`1.71ms5SELECT
( SELECT `id` FROM `products` WHERE `id` >7 LIMIT 1 ) AS next_value,
( SELECT `id` FROM `products` WHERE `id` <7 ORDER BY `id` DESC LIMIT 1 ) AS prev_value
FROM `products` Limit 1112μ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` =7 AND c.`status` = 1 Limit 178μ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 116μs1SELECT `name`,`id`,`sub_of` FROM `products_cat`
WHERE `id` =1 AND `status` = 1 Limit 144μ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 114μs1SELECT * FROM `quantities` WHERE `sub_of` =755μs1SELECT * FROM `attributes`
WHERE `type`='quantity' ORDER BY `sort_id`581μs5SELECT * FROM `reviews`
WHERE `status`=1 AND `sub_of`=783μs0