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

HTML Information

Database queries

Adapter 0

1. [81.98 ms] connect
2. [15.43 ms] SELECT `users`.* FROM `users` WHERE (login='Alex')
3. [20.57 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
4. [28.5 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='119')))
5. [5.77 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
6. [0.82 ms] SELECT `us`.*, `u`.* FROM `user_subscribers` AS `us` LEFT JOIN `users` AS `u` ON us.subscriber_id = u.user_id WHERE (u.is_deleted_user = 0) AND (us.subscription_id = '119')
7. [1.05 ms] SELECT `us`.*, `u`.* FROM `user_subscribers` AS `us` LEFT JOIN `users` AS `u` ON us.subscription_id = u.user_id WHERE (u.is_deleted_user = 0) AND (us.subscriber_id = '119')
8. [163.84 ms] SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.sender_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.recepient_id='119') AND (f.status = 2) UNION SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.recepient_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.sender_id='119') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [31.39 ms] SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.sender_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.recepient_id=-1) AND (f.status = 2) UNION SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.recepient_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.sender_id=-1) AND (f.status = 2) ORDER BY `dt_approved` DESC
10. [27.76 ms] SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.sender_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.recepient_id='119') AND (f.status = 2) UNION SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.recepient_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.sender_id='119') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [39.24 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '119') ORDER BY `v`.`dt_published_video` DESC
12. [23.88 ms] SELECT DISTINCT `ch`.* FROM `channels` AS `ch` WHERE (1 AND ch.is_published_channel = 1 AND ch.is_deleted_channel = 0 AND ch.owner_id = '119')
13. [209.25 ms] SELECT `pt`.*, `gt`.* FROM `user_photos` AS `pt` LEFT JOIN `user_gallery` AS `gt` ON pt.photo_gallery_id = gt.gallery_id WHERE (object_id = '119') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [1.62 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '119') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [36.52 ms] SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.sender_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.recepient_id='119') AND (f.status = 2) UNION SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.recepient_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.sender_id='119') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [47.96 ms] SELECT `c`.* FROM `countries` AS `c`
17. [24.11 ms] SELECT `us`.*, `u`.* FROM `user_subscribers` AS `us` LEFT JOIN `users` AS `u` ON us.subscriber_id = u.user_id WHERE (u.is_deleted_user = 0) AND (us.subscription_id = '119') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [3.57 ms] SELECT `c`.* FROM `countries` AS `c`
19. [31.37 ms] SELECT `users`.* FROM `users` WHERE (user_id='119')
20. [15.92 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 119 and sender_id = -1) OR (sender_id = 119 and recepient_id = -1)
21. [0.76 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '119')
22. [103.66 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
23. [1.41 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
24. [448.77 ms] SELECT `pt`.*, `gt`.* FROM `user_photos` AS `pt` LEFT JOIN `user_gallery` AS `gt` ON pt.photo_gallery_id = gt.gallery_id WHERE (object_id = '119') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC LIMIT 9
25. [4.58 ms] SELECT `c`.* FROM `countries` AS `c`
26. [0.71 ms] SELECT `v`.* FROM `user_types` AS `v`
27. [18.36 ms] SELECT SQL_CALC_FOUND_ROWS `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.sender_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.recepient_id='119') AND (f.status = 2) UNION SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.recepient_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.sender_id='119') AND (f.status = 2) ORDER BY `dt_approved` DESC LIMIT 12
28. [0.49 ms] SELECT FOUND_ROWS() AS zend_paginator_row_count
29. [91.74 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 194 and sender_id = -1) OR (sender_id = 194 and recepient_id = -1)
30. [1.9 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '194')
31. [9.9 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '194')
32. [0.85 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '194')
33. [0.85 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '194') ORDER BY `v`.`dt_published_video` DESC
34. [18.33 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 189 and sender_id = -1) OR (sender_id = 189 and recepient_id = -1)
35. [1.83 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '189')
36. [3.31 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '189')
37. [0.46 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '189')
38. [0.55 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '189') ORDER BY `v`.`dt_published_video` DESC
39. [0.66 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1456 and sender_id = -1) OR (sender_id = 1456 and recepient_id = -1)
40. [1.98 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '1456')
41. [0.78 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1456')
42. [10.36 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1456')
43. [2.72 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '1456') ORDER BY `v`.`dt_published_video` DESC
44. [0.54 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 748 and sender_id = -1) OR (sender_id = 748 and recepient_id = -1)
45. [0.51 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '748')
46. [0.74 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '748')
47. [6.3 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '748')
48. [16.5 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '748') ORDER BY `v`.`dt_published_video` DESC
49. [25.24 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1441 and sender_id = -1) OR (sender_id = 1441 and recepient_id = -1)
50. [1.41 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '1441')
51. [0.44 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1441')
52. [0.38 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1441')
53. [0.66 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '1441') ORDER BY `v`.`dt_published_video` DESC
54. [1.59 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 16 and sender_id = -1) OR (sender_id = 16 and recepient_id = -1)
55. [0.43 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '16')
56. [1.2 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '16')
57. [0.62 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '16')
58. [15.39 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '16') ORDER BY `v`.`dt_published_video` DESC
59. [9.24 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 480 and sender_id = -1) OR (sender_id = 480 and recepient_id = -1)
60. [0.38 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '480')
61. [0.46 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '480')
62. [1.25 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '480')
63. [0.38 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '480') ORDER BY `v`.`dt_published_video` DESC
64. [0.28 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1 and sender_id = -1) OR (sender_id = 1 and recepient_id = -1)
65. [2.15 ms] SELECT IF(COUNT(user_subscriber_id), 1, 0) AS `is_subscribe` FROM `user_subscribers` AS `us` WHERE (us.subscriber_id = -1) AND (us.subscription_id = '1')
66. [28.79 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1')
67. [5.77 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1')
68. [183.84 ms] SELECT DISTINCT `v`.* FROM `videos` AS `v` WHERE (1 AND v.is_published_video = 1 AND v.is_deleted_video = 0 AND v.is_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '1') ORDER BY `v`.`dt_published_video` DESC
69. [30.78 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
70. [70.88 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
71. [0.52 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
72. [0.28 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
73. [0.35 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
74. [0.4 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
75. [0.3 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
76. [0.39 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
77. [0.54 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
78. [61.2 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
79. [6.52 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
80. [15.63 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
81. [0.32 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
82. [0.29 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
83. [6.06 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
84. [0.85 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
85. [24.45 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
86. [0.39 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')
87. [0.62 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '119')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances