SQL: [1320]
SELECT
s.id AS specification_id,
s.name AS specification_name,
sv.id AS specification_value_id,
sv.name AS specification_value_name,
sc.catagory_id AS category_id,
s.multiple,
GROUP_CONCAT(DISTINCT(ps.product_id)) as products_ids
FROM specifications_catagories sc
INNER JOIN specifications_values sv ON sv.specification_id = sc.specification_id
INNER JOIN products_specifications ps ON ps.specification_value_id = sv.id
INNER JOIN products_data pd ON pd.id = ps.product_id
INNER JOIN products p ON p.id = pd.products_id AND p.status = 1
INNER JOIN specifications s ON s.id = sc.specification_id
WHERE sc.catagory_id IN ()
GROUP BY sv.id
UNION
SELECT
s.id AS specification_id,
s.name AS specification_name,
sv.id AS specification_value_id,
sv.name AS specification_value_name,
'0' AS category_id,
s.multiple,
GROUP_CONCAT(DISTINCT(ps.product_id)) as products_ids
FROM specifications s
INNER JOIN specifications_values sv ON sv.specification_id = s.id
INNER JOIN products_specifications ps ON ps.specification_value_id = sv.id
INNER JOIN products_data pd ON pd.id = ps.product_id
INNER JOIN products p ON p.id = pd.products_id AND p.status = 1
WHERE s.is_global = 1
GROUP BY sv.id
Params: 0
SQL: [530]
SELECT
COUNT(DISTINCT(p.id)) as cnt
FROM jt_categories_products cp
INNER JOIN products_data pd ON pd.products_id = cp.products_data_id
INNER JOIN categories_data cd ON cp.categories_data_id = cd.categories_id
INNER JOIN products p ON pd.products_id = p.id
INNER JOIN slugs s ON pd.id = s.item_id
WHERE
cp.categories_data_id IN () AND
s.type = 3 AND
p.status = 1 AND
s.slug IS NOT NULL
Params: 0
SQL: [703]
SELECT
pd.*, p.*,
s.slug,
(SELECT pv.price FROM products_variants pv WHERE pv.products_id = pd.products_id AND pv.status = 'favorite') AS price
FROM jt_categories_products cp
INNER JOIN products_data pd ON pd.products_id = cp.products_data_id
INNER JOIN categories_data cd ON cp.categories_data_id = cd.categories_id
INNER JOIN products p ON pd.products_id = p.id
INNER JOIN slugs s ON pd.id = s.item_id
WHERE
cp.categories_data_id IN () AND
s.type = 3 AND
p.status = 1 AND
s.slug IS NOT NULL
GROUP BY pd.id
ORDER BY pd.title ASC
LIMIT 0, 96
Params: 0