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. [0.53 ms] connect
2. [0.48 ms] SELECT `users`.* FROM `users` WHERE (login='NewHourFilm')
3. [0.42 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
4. [10.89 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='1472')))
5. [0.23 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='82')
6. [0.67 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 = '1472')
7. [0.33 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 = '1472')
8. [33.22 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='1472') 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='1472') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [1.68 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. [3.78 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='1472') 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='1472') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [1.06 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 = '1472') ORDER BY `v`.`dt_published_video` DESC
12. [0.23 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 = '1472')
13. [19.39 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 = '1472') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [0.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_rejected_video = 0 AND v.owner_id = '1472') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [1.48 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='1472') 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='1472') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [0.29 ms] SELECT `c`.* FROM `countries` AS `c`
17. [8.91 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 = '1472') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [0.28 ms] SELECT `c`.* FROM `countries` AS `c`
19. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='1472')
20. [0.17 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1472 and sender_id = -1) OR (sender_id = 1472 and recepient_id = -1)
21. [0.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 = '1472')
22. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
23. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
24. [51.44 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 = '1472') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC LIMIT 9
25. [0.57 ms] SELECT `st`.*, `sg`.`group_name` FROM `stage_types` AS `st` INNER JOIN `stage_groups` AS `sg` ON sg.group_id = st.stage_group_id WHERE (st.is_deleted = 0) ORDER BY `st`.`stage_group_id` ASC, `st`.`order` ASC
26. [0.24 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1472')
27. [18.02 ms] SELECT `stage_groups`.* FROM `stage_groups`
28. [0.72 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
29. [2.74 ms] SELECT `st`.* FROM `stages` AS `st` WHERE (1 AND st.is_deleted_stage = 0 AND st.stage_type_id IN(30,29,21,5,18,7,24,25,26,27,2,10,8,9,20,19,11,12,28,4,17,16,13,22,23,3,1,14,15) AND st.stage_owner_id = '1472') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20
30. [8.35 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1472')
31. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='1472')
32. [0.74 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-03-28 18:07:57') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-03-28 18:07:57') ORDER BY `dt_approved` DESC
33. [0.72 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-02-22 19:35:31') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-02-22 19:35:31') ORDER BY `dt_approved` DESC
34. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
35. [0.49 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1472' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2010-02-10 14:06:00') ORDER BY `pc`.`dt_posted_p_comment` DESC
36. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='53')
37. [1.72 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-02-08 18:24:07') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-02-08 18:24:07') ORDER BY `dt_approved` DESC
38. [8.38 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
39. [0.16 ms] SELECT `us`.* FROM `user_subscribers` AS `us` WHERE (us.subscriber_id='1472') AND (us.dt_subscriber='2010-02-08 12:30:30')
40. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1472')
41. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1634')
42. [0.18 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1472' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2010-02-08 12:26:40') ORDER BY `pc`.`dt_posted_p_comment` DESC
43. [0.18 ms] SELECT `users`.* FROM `users` WHERE (user_id='1472')
44. [0.82 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-02-08 12:25:23') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-02-08 12:25:23') ORDER BY `dt_approved` DESC
45. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='207')
46. [0.79 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 21:38:31') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 21:38:31') ORDER BY `dt_approved` DESC
47. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='207')
48. [1.03 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 21:38:29') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 21:38:29') ORDER BY `dt_approved` DESC
49. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
50. [1.31 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 21:38:26') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 21:38:26') ORDER BY `dt_approved` DESC
51. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
52. [8.87 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-12-10 01:18:11') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-12-10 01:18:11') ORDER BY `dt_approved` DESC
53. [0.18 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1472' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2009-11-21 17:56:20') ORDER BY `pc`.`dt_posted_p_comment` DESC
54. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1472')
55. [0.39 ms] SELECT `c`.* FROM `video_comments` AS `c` WHERE (1 AND c.level <> 0 AND c.dt_posted_comment = '2009-11-21 17:55:01' AND c.user_id = '1472' AND c.is_deleted_comment = 0) ORDER BY `left_id` ASC
56. [0.27 ms] SELECT `v`.* FROM `videos` AS `v` WHERE (video_id = '2488')
57. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1472')
58. [0.16 ms] SELECT `vvg`.*, `vg`.* FROM `video__video_genres` AS `vvg` LEFT JOIN `video_genres` AS `vg` ON vg.genre_id = vvg.genre_id WHERE (vvg.video_id = '2488')
59. [0.13 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
60. [9.98 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 = '1472' AND v.dt_published_video = '2009-11-16 11:44:15')
61. [0.15 ms] SELECT `vvg`.*, `vg`.* FROM `video__video_genres` AS `vvg` LEFT JOIN `video_genres` AS `vg` ON vg.genre_id = vvg.genre_id WHERE (vvg.video_id = '2488')
62. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
63. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1472')
64. [0.77 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-11-15 11:40:13') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-11-15 11:40:13') ORDER BY `dt_approved` DESC
65. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
66. [0.94 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-11-15 11:40:10') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-11-15 11:40:10') ORDER BY `dt_approved` DESC
67. [0.47 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
68. [1.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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-10-30 13:11:54') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-10-30 13:11:54') ORDER BY `dt_approved` DESC
69. [12.7 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-10-28 10:45:57') 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='1472') AND (f.status = 2) AND (f.dt_approved = '2009-10-28 10:45:57') ORDER BY `dt_approved` DESC
70. [32.13 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='159')
71. [32.12 ms] SELECT `users`.* FROM `users` WHERE (login='FilmNet')
72. [20.25 ms] SELECT COUNT(DISTINCT(st.stage_id)) AS `cnt` FROM `stages` AS `st` WHERE (1 AND st.is_deleted_stage = 0 AND st.stage_type_id IN(30,29,21,5,18,7,24,25,26,27,2,10,8,9,20,19,11,12,28,4,17,16,13,22,23,3,1,14,15) AND st.stage_owner_id = '1472')
73. [11.24 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
74. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
75. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
76. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
77. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
78. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
79. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
80. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
81. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
82. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
83. [2.38 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
84. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
85. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
86. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
87. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
88. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
89. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
90. [0.25 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')
91. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1472')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances