1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. SELECT |
total: 1 SELECT
p.id,
p.created,
p.price,
p.sprice,
p.is_sale,
p.title,
p.thumb,
p.token,
p.likes,
p.ratings,
FORMAT((likes/ratings),0) as stars,
p.body,
p.pbody,
p.type,
p.token,
p.images,
p.audio,
p.youtube,
p.affiliate,
p.membership_id,
p.keywords,
p.description,
c.slug AS cslug,
c.name,
GROUP_CONCAT(m.title SEPARATOR ', ') AS memberships,
(SELECT
COUNT(product_id)
FROM
`comments`
WHERE `comments`.product_id = p.id AND `comments`.active = 1) as comments
FROM
`products` AS p
LEFT JOIN `categories` AS c
ON c.id = p.category_id
LEFT JOIN `memberships` AS m
ON FIND_IN_SET(m.id, p.membership_id)
WHERE p.slug = "gta-5pc"
AND p.active = 1
GROUP BY p.id;
3. SELECT |
total: 3 SELECT
p.id,
p.price,
p.sprice,
p.is_sale,
p.title,
p.slug,
p.category_id,
p.thumb,
p.type,
p.token,
p.affiliate,
p.membership_id,
c.name,
c.slug as cslug
FROM
`products` AS p
LEFT JOIN `categories` AS c
ON c.id = p.category_id
WHERE p.id NOT IN(3)
AND p.is_sale = 1
AND p.active = 1
ORDER BY RAND() LIMIT 3;
4. SELECT |
total: 0 SELECT
cf.*,
cfd.field_value
FROM
`custom_fields` AS cf
LEFT JOIN `custom_fields_data` AS cfd
ON cfd.field_id = cf.id
WHERE cfd.product_id = 3
AND cf.section = "product"
ORDER BY cf.sorting;
5. SELECT |
total: 7 SELECT
m.id,
m.name,
m.content_type,
m.link,
m.target,
p.slug,
p.page_type
FROM
`menus` AS m
LEFT JOIN `pages` AS p
ON p.id = m.page_id
WHERE m.active = 1
ORDER BY m.sorting;
6. select |
total: 8 SELECT id, parent_id, name, slug FROM `categories` ORDER BY parent_id, sorting;
7. SELECT |
total: 0 SELECT
COUNT(id) AS items
FROM
`cart`
WHERE user_id = "d657aed65158b233617068ee5964345f84d0be86"
AND membership_id = 0
GROUP BY user_id;
8. count |
total: 0
SELECT
COUNT(*)
FROM
`comments`
WHERE parent_id = 0
AND product_id = 3
AND active = 1
LIMIT 1;
9. SELECT |
total: 0 SELECT
c.id,
c.user_id,
c.product_id,
c.parent_id,
c.vote_down,
c.vote_up,
c.body,
c.created,
c.rating,
c.username as uname,
u.username,
CONCAT(u.fname, ' ', u.lname) AS name,
u.avatar
FROM
`comments` AS c
INNER JOIN
(SELECT
id
FROM
`comments`
WHERE product_id = 3
AND parent_id = 0
AND active = 1
ORDER BY created DESC
) AS ch
ON ch.id IN (c.id, c.parent_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE product_id = 3
AND c.active = 1
ORDER BY created DESC;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. SELECT | total: 1 . SELECT
p.id,
p.created,
p.price,
p.sprice,
p.is_sale,
p.title,
p.thumb,
p.token,
p.likes,
p.ratings,
FORMAT((likes/ratings),0) as stars,
p.body,
p.pbody,
p.type,
p.token,
p.images,
p.audio,
p.youtube,
p.affiliate,
p.membership_id,
p.keywords,
p.description,
c.slug AS cslug,
c.name,
GROUP_CONCAT(m.title SEPARATOR ', ') AS memberships,
(SELECT
COUNT(product_id)
FROM
`comments`
WHERE `comments`.product_id = p.id AND `comments`.active = 1) as comments
FROM
`products` AS p
LEFT JOIN `categories` AS c
ON c.id = p.category_id
LEFT JOIN `memberships` AS m
ON FIND_IN_SET(m.id, p.membership_id)
WHERE p.slug = "gta-5pc"
AND p.active = 1
GROUP BY p.id;
3. SELECT | total: 3 . SELECT
p.id,
p.price,
p.sprice,
p.is_sale,
p.title,
p.slug,
p.category_id,
p.thumb,
p.type,
p.token,
p.affiliate,
p.membership_id,
c.name,
c.slug as cslug
FROM
`products` AS p
LEFT JOIN `categories` AS c
ON c.id = p.category_id
WHERE p.id NOT IN(3)
AND p.is_sale = 1
AND p.active = 1
ORDER BY RAND() LIMIT 3;
4. SELECT | total: 0 . SELECT
cf.*,
cfd.field_value
FROM
`custom_fields` AS cf
LEFT JOIN `custom_fields_data` AS cfd
ON cfd.field_id = cf.id
WHERE cfd.product_id = 3
AND cf.section = "product"
ORDER BY cf.sorting;
5. SELECT | total: 7 . SELECT
m.id,
m.name,
m.content_type,
m.link,
m.target,
p.slug,
p.page_type
FROM
`menus` AS m
LEFT JOIN `pages` AS p
ON p.id = m.page_id
WHERE m.active = 1
ORDER BY m.sorting;
6. select | total: 8 . SELECT id, parent_id, name, slug FROM `categories` ORDER BY parent_id, sorting;
7. SELECT | total: 0 . SELECT
COUNT(id) AS items
FROM
`cart`
WHERE user_id = "d657aed65158b233617068ee5964345f84d0be86"
AND membership_id = 0
GROUP BY user_id;
8. count | total: 0 .
SELECT
COUNT(*)
FROM
`comments`
WHERE parent_id = 0
AND product_id = 3
AND active = 1
LIMIT 1;
9. SELECT | total: 0 . SELECT
c.id,
c.user_id,
c.product_id,
c.parent_id,
c.vote_down,
c.vote_up,
c.body,
c.created,
c.rating,
c.username as uname,
u.username,
CONCAT(u.fname, ' ', u.lname) AS name,
u.avatar
FROM
`comments` AS c
INNER JOIN
(SELECT
id
FROM
`comments`
WHERE product_id = 3
AND parent_id = 0
AND active = 1
ORDER BY created DESC
) AS ch
ON ch.id IN (c.id, c.parent_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE product_id = 3
AND c.active = 1
ORDER BY created DESC;
