Total execution time: 0.067158 sec.
Framework 1.20 v5.20
Memory Usage 4.47MB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => search
)
[route] => /search
[template] => front/themes/master/search.tpl.php
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 25 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 (`title_en` LIKE '%%') OR (`body_en` LIKE '%%')
AND page_type = "normal"
ORDER BY created DESC
LIMIT 10;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 25 . 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 (`title_en` LIKE '%%') OR (`body_en` LIKE '%%')
AND page_type = "normal"
ORDER BY created DESC
LIMIT 10;