Prague Private Guides

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

Database queries

Adapter 0

1. [1.31 ms] connect
2. [0.28 ms] SET SQL_BIG_SELECTS=1
3. [0.33 ms] SELECT `content_pages`.* FROM `content_pages` WHERE (type = "uri" AND uri = '/ru/') OR (type = "mvc" AND module = "default" AND controller = "index" AND action = "index") LIMIT 1
4. [0.39 ms] SELECT `ad_block`.* FROM `ad_block` WHERE (router LIKE '%others%') AND (NOW() BETWEEN started AND closed) ORDER BY `position` ASC
5. [1.11 ms] SELECT `shop_category`.* FROM `shop_category` WHERE (id IN (26,92,97,96) AND lang LIKE "%ru%")
6. [3.2 ms] SELECT `shop_kind`.`id`, `shop_kind`.`art_no`, `shop_kind`.`name`, `shop_kind`.`desc_short`, `shop_kind`.`desc_long`, `shop_kind`.`price`, `shop_kind`.`price_sale`, `shop_kind`.`weight`, `shop_kind`.`router`, `shop_kind`.`views`, `shop_kind`.`presence`, `shop_kind`.`per_person`, `shop_kind`.`priority`, `shop_category`.`title` AS `cat_title`, `t`.`image_id`, `t`.`is_primary`, `img_images`.`fname` FROM `shop_kind` LEFT JOIN `shop_category_kind` ON shop_category_kind.item_id = shop_kind.id LEFT JOIN `shop_category` ON shop_category_kind.cat_id = shop_category.id LEFT JOIN (SELECT `shop_kinds_images`.* FROM `shop_kinds_images` ORDER BY `is_primary` DESC) AS `t` ON t.item_id = shop_kind.id LEFT JOIN `img_images` ON t.image_id = img_images.id LEFT JOIN `shop_group_kind` ON shop_group_kind.item_id = shop_kind.id WHERE (shop_kind.deleted = 0 AND shop_kind.moderation = 0 ) AND (shop_group_kind.group_id IN(1)) AND (shop_category.left >= '2') AND (shop_category.right <= '13') AND (shop_kind.lang LIKE "%ru%") GROUP BY `shop_kind`.`id`, `shop_kind`.`id`
7. [9.04 ms] SELECT `shop_kind`.`id`, `shop_kind`.`art_no`, `shop_kind`.`name`, `shop_kind`.`desc_short`, `shop_kind`.`desc_long`, `shop_kind`.`price`, `shop_kind`.`price_sale`, `shop_kind`.`weight`, `shop_kind`.`router`, `shop_kind`.`views`, `shop_kind`.`presence`, `shop_kind`.`per_person`, `shop_kind`.`priority`, `shop_category`.`title` AS `cat_title`, `t`.`image_id`, `t`.`is_primary`, `img_images`.`fname` FROM `shop_kind` LEFT JOIN `shop_category_kind` ON shop_category_kind.item_id = shop_kind.id LEFT JOIN `shop_category` ON shop_category_kind.cat_id = shop_category.id LEFT JOIN (SELECT `shop_kinds_images`.* FROM `shop_kinds_images` ORDER BY `is_primary` DESC) AS `t` ON t.item_id = shop_kind.id LEFT JOIN `img_images` ON t.image_id = img_images.id LEFT JOIN `shop_group_kind` ON shop_group_kind.item_id = shop_kind.id WHERE (shop_kind.deleted = 0 AND shop_kind.moderation = 0 ) AND (shop_group_kind.group_id IN(1)) AND (shop_category.left >= '20') AND (shop_category.right <= '21') AND (shop_kind.lang LIKE "%ru%") GROUP BY `shop_kind`.`id`, `shop_kind`.`id`
8. [0.8 ms] SELECT `shop_kind`.`id`, `shop_kind`.`art_no`, `shop_kind`.`name`, `shop_kind`.`desc_short`, `shop_kind`.`desc_long`, `shop_kind`.`price`, `shop_kind`.`price_sale`, `shop_kind`.`weight`, `shop_kind`.`router`, `shop_kind`.`views`, `shop_kind`.`presence`, `shop_kind`.`per_person`, `shop_kind`.`priority`, `shop_category`.`title` AS `cat_title`, `t`.`image_id`, `t`.`is_primary`, `img_images`.`fname` FROM `shop_kind` LEFT JOIN `shop_category_kind` ON shop_category_kind.item_id = shop_kind.id LEFT JOIN `shop_category` ON shop_category_kind.cat_id = shop_category.id LEFT JOIN (SELECT `shop_kinds_images`.* FROM `shop_kinds_images` ORDER BY `is_primary` DESC) AS `t` ON t.item_id = shop_kind.id LEFT JOIN `img_images` ON t.image_id = img_images.id LEFT JOIN `shop_group_kind` ON shop_group_kind.item_id = shop_kind.id WHERE (shop_kind.deleted = 0 AND shop_kind.moderation = 0 ) AND (shop_group_kind.group_id IN(1)) AND (shop_category.left >= '26') AND (shop_category.right <= '27') AND (shop_kind.lang LIKE "%ru%") GROUP BY `shop_kind`.`id`, `shop_kind`.`id`
9. [0.53 ms] SELECT `shop_kind`.`id`, `shop_kind`.`art_no`, `shop_kind`.`name`, `shop_kind`.`desc_short`, `shop_kind`.`desc_long`, `shop_kind`.`price`, `shop_kind`.`price_sale`, `shop_kind`.`weight`, `shop_kind`.`router`, `shop_kind`.`views`, `shop_kind`.`presence`, `shop_kind`.`per_person`, `shop_kind`.`priority`, `shop_category`.`title` AS `cat_title`, `t`.`image_id`, `t`.`is_primary`, `img_images`.`fname` FROM `shop_kind` LEFT JOIN `shop_category_kind` ON shop_category_kind.item_id = shop_kind.id LEFT JOIN `shop_category` ON shop_category_kind.cat_id = shop_category.id LEFT JOIN (SELECT `shop_kinds_images`.* FROM `shop_kinds_images` ORDER BY `is_primary` DESC) AS `t` ON t.item_id = shop_kind.id LEFT JOIN `img_images` ON t.image_id = img_images.id LEFT JOIN `shop_group_kind` ON shop_group_kind.item_id = shop_kind.id WHERE (shop_kind.deleted = 0 AND shop_kind.moderation = 0 ) AND (shop_group_kind.group_id IN(1)) AND (shop_category.left >= '28') AND (shop_category.right <= '29') AND (shop_kind.lang LIKE "%ru%") GROUP BY `shop_kind`.`id`, `shop_kind`.`id`
10. [0.26 ms] SELECT `info_group`.* FROM `info_group` WHERE (id IN (9))
11. [244.67 ms] SELECT `i`.*, `m`.* FROM `info_group_page` AS `i` INNER JOIN `info_news` AS `m` ON `i`.`item_id` = `m`.`id` WHERE (deleted = 0) AND (lang LIKE "%ru%") AND (`i`.`group_id` = 9) ORDER BY `added` DESC LIMIT 10
12. [0.36 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 97)
13. [0.36 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 95)
14. [0.35 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 94)
15. [0.34 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 93)
16. [0.38 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 92)
17. [0.33 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 91)
18. [1.79 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 90)
19. [0.37 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 89)
20. [0.31 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 88)
21. [0.31 ms] SELECT `i`.*, `m`.* FROM `info_news_images` AS `i` INNER JOIN `img_images` AS `m` ON `i`.`image_id` = `m`.`id` WHERE (`i`.`item_id` = 87)
22. [0.27 ms] SELECT `default_menu`.* FROM `default_menu` WHERE (`left` = 1) LIMIT 1
23. [0.38 ms] SELECT `default_menu`.* FROM `default_menu` WHERE (`left` BETWEEN 1 AND 12) GROUP BY `id` ORDER BY `left` ASC, `order` ASC
24. [0.35 ms] SELECT `info_group`.* FROM `info_group` WHERE (id IN (11))
25. [8.03 ms] SELECT `i`.*, `m`.* FROM `info_group_page` AS `i` INNER JOIN `info_news` AS `m` ON `i`.`item_id` = `m`.`id` WHERE (deleted = 0) AND (lang LIKE "%ru%") AND (`i`.`group_id` = 11) ORDER BY `added` DESC LIMIT 1000
26. [0.35 ms] SELECT `shop_category`.* FROM `shop_category` WHERE (`left` = 1) LIMIT 1
27. [0.98 ms] SELECT `shop_category`.* FROM `shop_category` WHERE (`left` BETWEEN 1 AND 30) AND (level = 1 AND lang LIKE "%ru%") GROUP BY `id` ORDER BY `left` ASC, `order` ASC
28. [0.29 ms] SELECT `default_pages`.* FROM `default_pages` WHERE (alias = 'leftmenu') LIMIT 1
29. [0.28 ms] SELECT `info_group`.* FROM `info_group` WHERE (id IN (10))
30. [0.67 ms] SELECT `i`.*, `m`.* FROM `info_group_page` AS `i` INNER JOIN `info_news` AS `m` ON `i`.`item_id` = `m`.`id` WHERE (deleted = 0) AND (lang LIKE "%ru%") AND (`i`.`group_id` = 10) ORDER BY `added` DESC LIMIT 1000

File Information

Application Files

Zend Library Files

ZFDebug Library Files

HTML Information

Memory Usage

Registered Instances

Custom Timers

Overall Timers

$_COOKIE

Request

View vars