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. [44.73 ms] connect
2. [25.5 ms] SELECT `users`.* FROM `users` WHERE (login='CaptainDisillusion')
3. [32.01 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
4. [17 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='93')))
5. [21.66 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
6. [10.14 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 = '93')
7. [6.31 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 = '93')
8. [22.1 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='93') 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='93') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [0.89 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. [11.15 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='93') 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='93') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [0.87 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 = '93') ORDER BY `v`.`dt_published_video` DESC
12. [0.48 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 = '93')
13. [40.66 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 = '93') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [0.67 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 = '93') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [74.6 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='93') 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='93') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [9.31 ms] SELECT `c`.* FROM `countries` AS `c`
17. [85.55 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 = '93') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [1.82 ms] SELECT `c`.* FROM `countries` AS `c`
19. [24.69 ms] SELECT `users`.* FROM `users` WHERE (user_id='93')
20. [31.99 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 93 and sender_id = -1) OR (sender_id = 93 and recepient_id = -1)
21. [28.06 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 = '93')
22. [9.8 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
23. [38.25 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
24. [48.08 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 = '93') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC LIMIT 9
25. [38.11 ms] SELECT `c`.* FROM `countries` AS `c`
26. [11.18 ms] SELECT `v`.* FROM `user_types` AS `v`
27. [20.41 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='93') 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='93') AND (f.status = 2) ORDER BY `dt_approved` DESC LIMIT 12
28. [3.59 ms] SELECT FOUND_ROWS() AS zend_paginator_row_count
29. [2.71 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1708 and sender_id = -1) OR (sender_id = 1708 and recepient_id = -1)
30. [64.69 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 = '1708')
31. [7.18 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1708')
32. [17.5 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1708')
33. [0.47 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 = '1708') ORDER BY `v`.`dt_published_video` DESC
34. [0.54 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1659 and sender_id = -1) OR (sender_id = 1659 and recepient_id = -1)
35. [38.31 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 = '1659')
36. [21.36 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1659')
37. [1.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1659')
38. [0.41 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 = '1659') ORDER BY `v`.`dt_published_video` DESC
39. [33.15 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 748 and sender_id = -1) OR (sender_id = 748 and recepient_id = -1)
40. [4.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 = '748')
41. [17.38 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '748')
42. [22.15 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '748')
43. [8.93 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
44. [9.14 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1542 and sender_id = -1) OR (sender_id = 1542 and recepient_id = -1)
45. [0.29 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 = '1542')
46. [0.3 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1542')
47. [48.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1542')
48. [40.05 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 = '1542') ORDER BY `v`.`dt_published_video` DESC
49. [15.73 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1569 and sender_id = -1) OR (sender_id = 1569 and recepient_id = -1)
50. [32.49 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 = '1569')
51. [9.04 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1569')
52. [1.16 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1569')
53. [9.47 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 = '1569') ORDER BY `v`.`dt_published_video` DESC
54. [26.14 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1589 and sender_id = -1) OR (sender_id = 1589 and recepient_id = -1)
55. [6 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 = '1589')
56. [25.99 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1589')
57. [22.22 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1589')
58. [0.59 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 = '1589') ORDER BY `v`.`dt_published_video` DESC
59. [15.8 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1539 and sender_id = -1) OR (sender_id = 1539 and recepient_id = -1)
60. [21.55 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 = '1539')
61. [0.33 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1539')
62. [9.03 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1539')
63. [24.04 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 = '1539') ORDER BY `v`.`dt_published_video` DESC
64. [22.72 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 208 and sender_id = -1) OR (sender_id = 208 and recepient_id = -1)
65. [17.22 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 = '208')
66. [19.04 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '208')
67. [20.99 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '208')
68. [2.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 = '208') ORDER BY `v`.`dt_published_video` DESC
69. [38.39 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1515 and sender_id = -1) OR (sender_id = 1515 and recepient_id = -1)
70. [11.8 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 = '1515')
71. [30.72 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1515')
72. [30.41 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1515')
73. [32.05 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 = '1515') ORDER BY `v`.`dt_published_video` DESC
74. [32.9 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1488 and sender_id = -1) OR (sender_id = 1488 and recepient_id = -1)
75. [32.31 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 = '1488')
76. [33.29 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1488')
77. [34.23 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1488')
78. [20.08 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 = '1488') ORDER BY `v`.`dt_published_video` DESC
79. [6.01 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1423 and sender_id = -1) OR (sender_id = 1423 and recepient_id = -1)
80. [12.84 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 = '1423')
81. [2.28 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
82. [9.91 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
83. [1.79 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 = '1423') ORDER BY `v`.`dt_published_video` DESC
84. [2.68 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 62 and sender_id = -1) OR (sender_id = 62 and recepient_id = -1)
85. [0.7 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 = '62')
86. [61.41 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '62')
87. [19.75 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '62')
88. [0.91 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 = '62') ORDER BY `v`.`dt_published_video` DESC
89. [12.69 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
90. [3.59 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
91. [13.33 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
92. [0.79 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
93. [0.15 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
94. [0.55 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
95. [0.55 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
96. [6.97 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
97. [0.28 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
98. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
99. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
100. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
101. [2.01 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
102. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
103. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
104. [0.25 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
105. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
106. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')
107. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '93')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances