Total execution time: 0.077256 sec.
Framework 1.25 v6.00
Memory Usage 845.85kB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => sites
[1] => location
[2] => birmingham
)
[route] => /sites/location/birmingham
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/var/www/html/tennisforfree.com/view/admin/modules_/sites/
[Bootstrap::Autoloader[2]] => autoloaded class "/var/www/html/tennisforfree.com/view/admin/modules_/sites/Site.class.php
[template] => front/themes/master/mod_index.tpl.php
)
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 = "sites" LIMIT 1;
3. select |
total: 18 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select |
total: 1 SELECT * FROM `mod_sites_locations` WHERE slug = "birmingham" LIMIT 1;
5. count |
total: 4 SELECT COUNT(*) AS NUMROWS FROM `mod_sites` WHERE location_id = 22;
6. SELECT |
total: 4 SELECT
d.id,
d.site_type,
d.is_tff_all,
d.is_tff_12,
d.is_tff,
d.town,
d.title_en AS title,
d.slug_en AS slug,
d.thumb
FROM
`mod_sites` AS d
WHERE location_id = 22
ORDER BY town LIMIT 0,12
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 = "sites"
AND p.active = 1
ORDER BY l.sorting;
8. select |
total: 6 SELECT id, name_en, slug_en FROM `mod_sites_regions` ORDER BY 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 = "sites" LIMIT 1;
3. select | total: 18 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select | total: 1 . SELECT * FROM `mod_sites_locations` WHERE slug = "birmingham" LIMIT 1;
5. count | total: 4 . SELECT COUNT(*) AS NUMROWS FROM `mod_sites` WHERE location_id = 22;
6. SELECT | total: 4 . SELECT
d.id,
d.site_type,
d.is_tff_all,
d.is_tff_12,
d.is_tff,
d.town,
d.title_en AS title,
d.slug_en AS slug,
d.thumb
FROM
`mod_sites` AS d
WHERE location_id = 22
ORDER BY town LIMIT 0,12
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 = "sites"
AND p.active = 1
ORDER BY l.sorting;
8. select | total: 6 . SELECT id, name_en, slug_en FROM `mod_sites_regions` ORDER BY sorting;
