Total execution time: 0.104559 sec.
Framework 1.25 v6.00
Memory Usage 873.41kB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => search
)
[route] => /search
[template] => front/themes/master/search.tpl.php
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/var/www/html/tennisforfree.com/view/admin/modules_/blog/
[Bootstrap::Autoloader[2]] => autoloaded class "/var/www/html/tennisforfree.com/view/admin/modules_/blog/Blog.class.php
[Bootstrap::Autoloader[3]] => registered path "autoloaded class "/var/www/html/tennisforfree.com/view/admin/modules_/sites/
[Bootstrap::Autoloader[4]] => autoloaded class "/var/www/html/tennisforfree.com/view/admin/modules_/sites/Site.class.php
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 18 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
3. select |
total: 1 SELECT * FROM `pages` WHERE page_type = "search" AND active = 1 LIMIT 1;
4. SELECT |
total: 10 SELECT
title_en AS title,
body_en AS body,
slug_en AS slug ,
page_type
FROM
`pages`
WHERE active = 1
AND page_type = "normal"
AND (`title_en` LIKE '%%') OR (`body_en` LIKE '%%')
ORDER BY created DESC
LIMIT 10;
5. SELECT |
total: 0 SELECT
title_en AS title,
body_en AS body,
slug_en AS slug
FROM
`mod_blog`
WHERE MATCH (title_en) AGAINST ('*' IN BOOLEAN MODE)
OR MATCH (body_en) AGAINST ('*' IN BOOLEAN MODE)
AND active = 1
ORDER BY created DESC
LIMIT 10;
6. SELECT |
total: 0 SELECT
title_en AS title,
body_en AS body,
slug_en AS slug
FROM
`mod_sites`
WHERE MATCH (title_en) AGAINST ('*' IN BOOLEAN MODE)
OR MATCH (body_en) AGAINST ('*' IN BOOLEAN MODE)
ORDER BY created DESC
LIMIT 10;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 18 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
3. select | total: 1 . SELECT * FROM `pages` WHERE page_type = "search" AND active = 1 LIMIT 1;
4. SELECT | total: 10 . SELECT
title_en AS title,
body_en AS body,
slug_en AS slug ,
page_type
FROM
`pages`
WHERE active = 1
AND page_type = "normal"
AND (`title_en` LIKE '%%') OR (`body_en` LIKE '%%')
ORDER BY created DESC
LIMIT 10;
5. SELECT | total: 0 . SELECT
title_en AS title,
body_en AS body,
slug_en AS slug
FROM
`mod_blog`
WHERE MATCH (title_en) AGAINST ('*' IN BOOLEAN MODE)
OR MATCH (body_en) AGAINST ('*' IN BOOLEAN MODE)
AND active = 1
ORDER BY created DESC
LIMIT 10;6. SELECT | total: 0 . SELECT
title_en AS title,
body_en AS body,
slug_en AS slug
FROM
`mod_sites`
WHERE MATCH (title_en) AGAINST ('*' IN BOOLEAN MODE)
OR MATCH (body_en) AGAINST ('*' IN BOOLEAN MODE)
ORDER BY created DESC
LIMIT 10;
