Total execution time: 0.010589 sec.
Framework 1.50 v5.01
Memory Usage 745.2kB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => index
)
[route] => /
[template] => front/themes/master/index.tpl.php
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. SELECT |
total: 12 SELECT
p.id,
p.price,
p.sprice,
p.is_sale,
p.created,
p.title,
p.slug,
p.likes,
p.category_id,
p.body,
p.thumb,
p.type,
p.token,
p.affiliate,
p.membership_id,
GROUP_CONCAT(m.title SEPARATOR ', ') AS memberships,
c.name,
c.slug as cslug
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.active =1
GROUP BY p.id
ORDER BY p.created DESC LIMIT 0,14
3. select |
total: 1 SELECT title, body, keywords, description FROM `pages` WHERE page_type = "home" LIMIT 1;
4. 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;
5. select |
total: 8 SELECT id, parent_id, name, slug FROM `categories` ORDER BY parent_id, sorting;
6. SELECT |
total: 0 SELECT
COUNT(id) AS items
FROM
`cart`
WHERE user_id = "e64c344260c2c905763fdee1b3dfd82f54a0f7d9"
AND membership_id = 0
GROUP BY user_id;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. SELECT | total: 12 . SELECT
p.id,
p.price,
p.sprice,
p.is_sale,
p.created,
p.title,
p.slug,
p.likes,
p.category_id,
p.body,
p.thumb,
p.type,
p.token,
p.affiliate,
p.membership_id,
GROUP_CONCAT(m.title SEPARATOR ', ') AS memberships,
c.name,
c.slug as cslug
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.active =1
GROUP BY p.id
ORDER BY p.created DESC LIMIT 0,14
3. select | total: 1 . SELECT title, body, keywords, description FROM `pages` WHERE page_type = "home" LIMIT 1;
4. 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;
5. select | total: 8 . SELECT id, parent_id, name, slug FROM `categories` ORDER BY parent_id, sorting;
6. SELECT | total: 0 . SELECT
COUNT(id) AS items
FROM
`cart`
WHERE user_id = "e64c344260c2c905763fdee1b3dfd82f54a0f7d9"
AND membership_id = 0
GROUP BY user_id;
