Total execution time: 0.01016 sec.
Framework 1.25 v5.50
Memory Usage 876.16kB
POST:
Array
(
)
GET:
Array
(
[filter] => true
[order] => price|DESC
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => shop
[1] => category
[2] => advertising
)
[route] => /shop/category/advertising
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/var/www/vfma/view/admin/modules_/shop/
[Bootstrap::Autoloader[2]] => autoload registered
[Bootstrap::Autoloader[3]] => autoloaded class "/var/www/vfma/view/admin/modules_/shop/Shop.class.php
[template] => front/themes/master/mod_index.tpl.php
[Bootstrap::Autoloader[4]] => autoload registered
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 1 SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "shop" LIMIT 1;
3. select |
total: 16 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select |
total: 1 SELECT * FROM `mod_shop_categories` WHERE slug_en = "advertising" LIMIT 1;
5. count |
total: 9
SELECT
COUNT(p.id)
FROM
`mod_shop` AS p
INNER JOIN `mod_shop_related_categories` AS rc
ON p.id = rc.item_id
WHERE rc.category_id = 1
AND p.active = 1
LIMIT 1;
6. SELECT |
total: 9 SELECT
d.id,
d.created,
d.price,
d.price_sale,
d.quantity,
d.subtract,
d.label,
d.ratings,
d.variation_data,
FORMAT((d.likes/d.ratings),0) as stars,
d.title_en AS title,
d.slug_en AS slug,
d.thumb,
d.likes,
c.slug_en AS cslug,
c.name_en AS name,
(SELECT
COUNT(parent_id)
FROM
`mod_comments`
WHERE `mod_comments`.parent_id = d.id
AND section = 'shop') as comments
FROM
`mod_shop` AS d
LEFT JOIN `mod_shop_categories` AS c
ON c.id = d.category_id
INNER JOIN `mod_shop_related_categories` AS rc
ON d.id = rc.item_id
WHERE rc.category_id = 1
AND d.active = 1
AND c.active = 1
GROUP BY d.id
ORDER BY price ASC LIMIT 0,10
7. SELECT |
total: 0 SELECT
p.id,
l.plug_id,
l.space,
l.place,
p.system,
p.alt_class,
p.plugalias,
p.plugin_id,
p.title_en as title,
p.body_en as body,
p.jscode,
p.show_title,
p.cplugin
FROM
`layout` AS l
LEFT JOIN plugins AS p
ON p.id = l.plug_id
WHERE l.modalias = "shop"
AND p.active = 1
ORDER BY l.sorting;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 1 . SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "shop" LIMIT 1;
3. select | total: 16 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select | total: 1 . SELECT * FROM `mod_shop_categories` WHERE slug_en = "advertising" LIMIT 1;
5. count | total: 9 .
SELECT
COUNT(p.id)
FROM
`mod_shop` AS p
INNER JOIN `mod_shop_related_categories` AS rc
ON p.id = rc.item_id
WHERE rc.category_id = 1
AND p.active = 1
LIMIT 1;
6. SELECT | total: 9 . SELECT
d.id,
d.created,
d.price,
d.price_sale,
d.quantity,
d.subtract,
d.label,
d.ratings,
d.variation_data,
FORMAT((d.likes/d.ratings),0) as stars,
d.title_en AS title,
d.slug_en AS slug,
d.thumb,
d.likes,
c.slug_en AS cslug,
c.name_en AS name,
(SELECT
COUNT(parent_id)
FROM
`mod_comments`
WHERE `mod_comments`.parent_id = d.id
AND section = 'shop') as comments
FROM
`mod_shop` AS d
LEFT JOIN `mod_shop_categories` AS c
ON c.id = d.category_id
INNER JOIN `mod_shop_related_categories` AS rc
ON d.id = rc.item_id
WHERE rc.category_id = 1
AND d.active = 1
AND c.active = 1
GROUP BY d.id
ORDER BY price ASC LIMIT 0,10
7. SELECT | total: 0 . SELECT
p.id,
l.plug_id,
l.space,
l.place,
p.system,
p.alt_class,
p.plugalias,
p.plugin_id,
p.title_en as title,
p.body_en as body,
p.jscode,
p.show_title,
p.cplugin
FROM
`layout` AS l
LEFT JOIN plugins AS p
ON p.id = l.plug_id
WHERE l.modalias = "shop"
AND p.active = 1
ORDER BY l.sorting;
