ZFDebug v1.5

©2008-2009 Joakim Nygård & Andreas Pankratz

The project is hosted at http://zfdebug.googlecode.com and released under the BSD License
Includes images from the Silk Icon set by Mark James

$_COOKIE

Request

View vars

Custom Timers

Overall Timers

Memory Usage

Database queries

Adapter 0

1. [2.03 ms] SELECT `c`.`id` AS `c_id`, `c`.`name` AS `c_name`, `c`.`ident` AS `c_ident`, `s`.`id` AS `s_id`, `s`.`title` AS `s_title`, `l`.`id` AS `l_id`, `l`.`title` AS `l_title` FROM `cls_category` AS `c` LEFT JOIN `cls_categorylabelset` AS `s` ON s.category_id = c.id LEFT JOIN `cls_categorylabel` AS `l` ON l.categorylabelset_id = s.id WHERE (c.deleted = 0) ORDER BY `c`.`ord` DESC, `c`.`id` ASC, `c`.`name` ASC, `s`.`title` ASC, `l`.`title` ASC
2. [25.98 ms] SELECT `cls_advertisement`.`category_id`, count(*) AS `count` FROM `cls_advertisement` WHERE (adminstatus IN (1, 0)) AND (status = 1) AND (category_id IN (1, 2, 3, 4, 9, 11, 12, 14, 16, 17)) GROUP BY `category_id`
3. [45.16 ms] SELECT `a`.*, `aw`.`weight` FROM `cls_advertisement` AS `a` LEFT JOIN `cls_advertisement_weight` AS `aw` ON aw.advertisement_id = a.id WHERE (a.kind = 2) AND (status=1) AND (deleted='') AND (adminstatus=1) ORDER BY `category_id` ASC, `aw`.`weight` DESC, `id` DESC
4. [0.35 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 1 AND l.deleted = false ORDER BY s.id, l.id
5. [0.26 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 2 AND l.deleted = false ORDER BY s.id, l.id
6. [0.24 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 3 AND l.deleted = false ORDER BY s.id, l.id
7. [0.25 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 4 AND l.deleted = false ORDER BY s.id, l.id
8. [0.27 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 9 AND l.deleted = false ORDER BY s.id, l.id
9. [0.26 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 11 AND l.deleted = false ORDER BY s.id, l.id
10. [0.28 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 12 AND l.deleted = false ORDER BY s.id, l.id
11. [0.26 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 14 AND l.deleted = false ORDER BY s.id, l.id
12. [0.22 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 16 AND l.deleted = false ORDER BY s.id, l.id
13. [0.22 ms] SELECT s.id AS s_id, s.title AS s_title, s.category_id AS category_id, l.id AS l_id, l.title AS l_title FROM cls_categorylabelset s JOIN cls_categorylabel l ON l.categorylabelset_id = s.id WHERE s.category_id = 17 AND l.deleted = false ORDER BY s.id, l.id