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. [100.47 ms] connect
2. [51.16 ms] SELECT `users`.* FROM `users` WHERE (login='reddesert')
3. [31.77 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
4. [8.58 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='1562')))
5. [0.35 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='178')
6. [96.44 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 = '1562')
7. [25.98 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 = '1562')
8. [112.92 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='1562') 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='1562') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [5.08 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. [25.2 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='1562') 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='1562') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [124.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_rejected_video = 0 AND v.owner_id = '1562') ORDER BY `v`.`dt_published_video` DESC
12. [32.4 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 = '1562')
13. [63.91 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 = '1562') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [15.82 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 = '1562') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [108.56 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='1562') 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='1562') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [31.72 ms] SELECT `c`.* FROM `countries` AS `c`
17. [30.99 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 = '1562') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [32.08 ms] SELECT `c`.* FROM `countries` AS `c`
19. [24.97 ms] SELECT `users`.* FROM `users` WHERE (user_id='1562')
20. [30.48 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1562 and sender_id = -1) OR (sender_id = 1562 and recepient_id = -1)
21. [15.59 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 = '1562')
22. [84.84 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
23. [34.55 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
24. [187.67 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 = '1562') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC LIMIT 9
25. [29.75 ms] SELECT `c`.* FROM `countries` AS `c`
26. [31.94 ms] SELECT `v`.* FROM `user_types` AS `v`
27. [22.04 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='1562') 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='1562') AND (f.status = 2) ORDER BY `dt_approved` DESC LIMIT 12
28. [18.1 ms] SELECT FOUND_ROWS() AS zend_paginator_row_count
29. [0.45 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1741 and sender_id = -1) OR (sender_id = 1741 and recepient_id = -1)
30. [0.33 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 = '1741')
31. [0.39 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
32. [30.62 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
33. [48.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 = '1741') ORDER BY `v`.`dt_published_video` DESC
34. [23.3 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 2059 and sender_id = -1) OR (sender_id = 2059 and recepient_id = -1)
35. [0.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 = '2059')
36. [1.01 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '2059')
37. [8.58 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '2059')
38. [81.19 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 = '2059') ORDER BY `v`.`dt_published_video` DESC
39. [35.74 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1581 and sender_id = -1) OR (sender_id = 1581 and recepient_id = -1)
40. [31.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 = '1581')
41. [32.42 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1581')
42. [22.45 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1581')
43. [41.76 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 = '1581') ORDER BY `v`.`dt_published_video` DESC
44. [26.59 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 208 and sender_id = -1) OR (sender_id = 208 and recepient_id = -1)
45. [34.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 = '208')
46. [23.77 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '208')
47. [48.26 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '208')
48. [22.28 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
49. [35.34 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1973 and sender_id = -1) OR (sender_id = 1973 and recepient_id = -1)
50. [5.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 = '1973')
51. [19.3 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1973')
52. [13.58 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1973')
53. [19.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 = '1973') ORDER BY `v`.`dt_published_video` DESC
54. [32.53 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 9 and sender_id = -1) OR (sender_id = 9 and recepient_id = -1)
55. [47.77 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 = '9')
56. [63.59 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '9')
57. [77.75 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '9')
58. [31.26 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 = '9') ORDER BY `v`.`dt_published_video` DESC
59. [2.33 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 41 and sender_id = -1) OR (sender_id = 41 and recepient_id = -1)
60. [0.26 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 = '41')
61. [0.18 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '41')
62. [0.24 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '41')
63. [1.2 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 = '41') ORDER BY `v`.`dt_published_video` DESC
64. [0.37 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 497 and sender_id = -1) OR (sender_id = 497 and recepient_id = -1)
65. [7.59 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 = '497')
66. [16.61 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '497')
67. [1.2 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '497')
68. [341.74 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 = '497') ORDER BY `v`.`dt_published_video` DESC
69. [20.14 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1635 and sender_id = -1) OR (sender_id = 1635 and recepient_id = -1)
70. [0.3 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 = '1635')
71. [0.42 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1635')
72. [13.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1635')
73. [0.48 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 = '1635') ORDER BY `v`.`dt_published_video` DESC
74. [4.94 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 748 and sender_id = -1) OR (sender_id = 748 and recepient_id = -1)
75. [0.16 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')
76. [0.17 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '748')
77. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '748')
78. [0.46 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
79. [14.06 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1589 and sender_id = -1) OR (sender_id = 1589 and recepient_id = -1)
80. [0.26 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')
81. [0.22 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1589')
82. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1589')
83. [0.32 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
84. [0.21 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1569 and sender_id = -1) OR (sender_id = 1569 and recepient_id = -1)
85. [1.59 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')
86. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1569')
87. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1569')
88. [9.33 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
89. [3.8 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
90. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
91. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
92. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
93. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
94. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
95. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
96. [8.74 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
97. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
98. [0.19 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
99. [3.66 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
100. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
101. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
102. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
103. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
104. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
105. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
106. [0.17 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')
107. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1562')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances