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. [5.52 ms] connect
2. [0.4 ms] SELECT `users`.* FROM `users` WHERE (login='IndigenousProductions')
3. [0.38 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
4. [0.34 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='465')))
5. [0.18 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
6. [0.79 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 = '465')
7. [0.25 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 = '465')
8. [46 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='465') 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='465') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [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=-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. [21.62 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='465') 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='465') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [0.9 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 = '465') ORDER BY `v`.`dt_published_video` DESC
12. [0.33 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 = '465')
13. [22.2 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 = '465') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [0.42 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 = '465') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [1.35 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='465') 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='465') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [4.02 ms] SELECT `c`.* FROM `countries` AS `c`
17. [0.34 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 = '465') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [0.29 ms] SELECT `c`.* FROM `countries` AS `c`
19. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
20. [0.17 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 465 and sender_id = -1) OR (sender_id = 465 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 = '465')
22. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
23. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
24. [1.8 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 = '465') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC LIMIT 9
25. [16 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. [15.89 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '465')
27. [8.36 ms] SELECT `stage_groups`.* FROM `stage_groups`
28. [1.3 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
29. [15.17 ms] SELECT `st`.* FROM `stages` AS `st` WHERE (1 AND st.is_deleted_stage = 0 AND st.stage_type_id IN(21,30,29,5,18,7,24,25,26,27,2,10,8,9,20,19,11,12,28,4,17,16,22,13,23,3,1,14,15) AND st.stage_owner_id = '465') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20
30. [1.17 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '465')
31. [9.08 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
32. [0.85 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='465') AND (f.status = 2) AND (f.dt_approved = '2010-01-24 01:47:56') 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='465') AND (f.status = 2) AND (f.dt_approved = '2010-01-24 01:47:56') ORDER BY `dt_approved` DESC
33. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='207')
34. [0.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 = '465' AND v.dt_published_video = '2010-01-22 06:03:27')
35. [0.38 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 = '2865')
36. [8.23 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
37. [0.22 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
38. [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='465') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 17:52:53') 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='465') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 17:52:53') ORDER BY `dt_approved` DESC
39. [0.2 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
40. [0.75 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-12-20 03:24:08') 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-12-20 03:24:08') ORDER BY `dt_approved` DESC
41. [4.19 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
42. [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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-30 02:14:25') 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-30 02:14:25') ORDER BY `dt_approved` DESC
43. [0.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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-14 19:10:34') 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-14 19:10:34') ORDER BY `dt_approved` DESC
44. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
45. [25.19 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-14 18:59:48') 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-14 18:59:48') ORDER BY `dt_approved` DESC
46. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
47. [0.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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-12 13:25:56') 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-12 13:25:56') ORDER BY `dt_approved` DESC
48. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
49. [0.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 = '465' AND v.dt_published_video = '2009-11-06 21:53:15')
50. [0.24 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 = '2421')
51. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
52. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
53. [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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-05 23:57:03') 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-05 23:57:03') ORDER BY `dt_approved` DESC
54. [9.83 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
55. [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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-05 14:18:32') 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-11-05 14:18:32') ORDER BY `dt_approved` DESC
56. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='226')
57. [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='465') AND (f.status = 2) AND (f.dt_approved = '2009-10-31 22:49:01') 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='465') AND (f.status = 2) AND (f.dt_approved = '2009-10-31 22:49:01') ORDER BY `dt_approved` DESC
58. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='159')
59. [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='465') AND (f.status = 2) AND (f.dt_approved = '2009-10-31 15:04: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='465') AND (f.status = 2) AND (f.dt_approved = '2009-10-31 15:04:13') ORDER BY `dt_approved` DESC
60. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
61. [0.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 = '465' AND v.dt_published_video = '2009-09-04 16:53:38')
62. [0.27 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 = '660')
63. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='6')
64. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
65. [0.27 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 = '465' AND v.dt_published_video = '2009-09-04 16:35:38')
66. [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 = '659')
67. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='6')
68. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
69. [2.52 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 = '465' AND v.dt_published_video = '2009-09-04 16:33:29')
70. [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 = '658')
71. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='7')
72. [0.22 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
73. [0.27 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 = '465' AND v.dt_published_video = '2009-09-04 16:33:03')
74. [4.61 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 = '657')
75. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='6')
76. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
77. [0.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 = '465' AND v.dt_published_video = '2009-09-04 16:30:47')
78. [0.19 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 = '656')
79. [14.18 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='6')
80. [14.95 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
81. [15.69 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 = '465' AND v.dt_published_video = '2009-09-04 16:30:16')
82. [27.19 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 = '655')
83. [28.05 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='7')
84. [27.22 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
85. [23.51 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 = '465' AND v.dt_published_video = '2009-09-04 16:29:53')
86. [3.46 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 = '654')
87. [14.76 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='7')
88. [0.42 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
89. [30.16 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(21,30,29,5,18,7,24,25,26,27,2,10,8,9,20,19,11,12,28,4,17,16,22,13,23,3,1,14,15) AND st.stage_owner_id = '465')
90. [1.36 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
91. [15.48 ms] SELECT `st`.* FROM `stages` AS `st` WHERE (1 AND st.is_deleted_stage = 0 AND st.stage_type_id IN(21,30,29,5,18,7,24,25,26,27,2,10,8,9,20,19,11,12,28,4,17,16,22,13,23,3,1,14,15) AND st.stage_owner_id = '465') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20 OFFSET 20
92. [0.18 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '465')
93. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
94. [0.54 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 = '465' AND v.dt_published_video = '2009-09-04 16:29:11')
95. [0.17 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 = '653')
96. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='7')
97. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
98. [0.34 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 = '465' AND v.dt_published_video = '2009-09-04 16:28:32')
99. [4.33 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 = '652')
100. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='7')
101. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
102. [0.34 ms] SELECT `c`.* FROM `channels` AS `c` WHERE (c.owner_id='465') AND (c.dt_published_channel='2009-09-04 10:00:00')
103. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
104. [4.13 ms] SELECT `ccg`.*, `cg`.* FROM `channel__channel_genres` AS `ccg` LEFT JOIN `channel_genres` AS `cg` ON cg.genre_id = ccg.genre_id WHERE (ccg.channel_id = '71')
105. [0.18 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='6')
106. [8.98 ms] SELECT `users`.* FROM `users` WHERE (user_id='465')
107. [0.98 ms] SELECT DISTINCT `v`.* FROM `channel__videos` AS `cv` LEFT JOIN `videos` AS `v` ON v.video_id = cv.video_id LEFT JOIN `video__video_genres` AS `vg` ON vg.video_id = v.video_id LEFT JOIN `video_featured` AS `vf` ON vf.video_id = v.video_id 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 cv.channel_id = '71') ORDER BY `v`.`dt_published_video` DESC
108. [0.41 ms] SELECT `users`.* FROM `users` WHERE (login='FilmNet')
109. [0.19 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
110. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
111. [4.2 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
112. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
113. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
114. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
115. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
116. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
117. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
118. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
119. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
120. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
121. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
122. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
123. [0.29 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
124. [0.3 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
125. [0.28 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
126. [8.33 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')
127. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '465')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances