Total execution time: 0.006849 sec.
Framework 1.50 v5.01
Memory Usage 682.76kB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => category
[1] => bussines-and-accounting
)
[route] => /category/bussines-and-accounting
[template] => front/themes/master/category.tpl.php
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 1 SELECT * FROM `categories` WHERE slug = "bussines-and-accounting" LIMIT 1;
3. count |
total: 1
SELECT
COUNT(p.id)
FROM
`products` AS p
INNER JOIN `categories_related` AS rc
ON p.id = rc.product_id
WHERE rc.category_id = 6
AND p.active = 1
LIMIT 1;
4. SELECT |
total: 1 SELECT
p.id,
p.created,
p.price,
p.sprice,
p.is_sale,
p.title,
p.slug,
p.thumb,
p.token,
p.likes,
p.body,
p.type,
p.token,
p.affiliate,
p.membership_id,
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) as comments
FROM
`products` AS p
LEFT JOIN `categories` AS c
ON c.id = p.category_id
INNER JOIN `categories_related` AS rc
ON p.id = rc.product_id
LEFT JOIN `memberships` AS m
ON FIND_IN_SET(m.id, p.membership_id)
WHERE rc.category_id = 6
AND p.active = 1
AND c.active = 1
GROUP BY p.id
ORDER BY created DESC
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 = "670080cc63fff211664f0eabd352436a410b1722"
AND membership_id = 0
GROUP BY user_id;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 1 . SELECT * FROM `categories` WHERE slug = "bussines-and-accounting" LIMIT 1;
3. count | total: 1 .
SELECT
COUNT(p.id)
FROM
`products` AS p
INNER JOIN `categories_related` AS rc
ON p.id = rc.product_id
WHERE rc.category_id = 6
AND p.active = 1
LIMIT 1;
4. SELECT | total: 1 . SELECT
p.id,
p.created,
p.price,
p.sprice,
p.is_sale,
p.title,
p.slug,
p.thumb,
p.token,
p.likes,
p.body,
p.type,
p.token,
p.affiliate,
p.membership_id,
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) as comments
FROM
`products` AS p
LEFT JOIN `categories` AS c
ON c.id = p.category_id
INNER JOIN `categories_related` AS rc
ON p.id = rc.product_id
LEFT JOIN `memberships` AS m
ON FIND_IN_SET(m.id, p.membership_id)
WHERE rc.category_id = 6
AND p.active = 1
AND c.active = 1
GROUP BY p.id
ORDER BY created DESC
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 = "670080cc63fff211664f0eabd352436a410b1722"
AND membership_id = 0
GROUP BY user_id;
