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. [23.21 ms] connect
2. [21.19 ms] SELECT `users`.* FROM `users` WHERE (login='superjeans')
3. [13.81 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
4. [29.55 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='1548')))
5. [32.45 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='82')
6. [63.84 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 = '1548')
7. [23.01 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 = '1548')
8. [59.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='1548') 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='1548') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [34.58 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. [31.81 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='1548') 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='1548') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [32.35 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 = '1548') ORDER BY `v`.`dt_published_video` DESC
12. [39.43 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 = '1548')
13. [156.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 = '1548') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [8.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_rejected_video = 0 AND v.owner_id = '1548') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [31.95 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='1548') 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='1548') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [0.42 ms] SELECT `c`.* FROM `countries` AS `c`
17. [0.53 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 = '1548') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [0.29 ms] SELECT `c`.* FROM `countries` AS `c`
19. [0.25 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
20. [0.26 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1548 and sender_id = -1) OR (sender_id = 1548 and recepient_id = -1)
21. [0.2 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 = '1548')
22. [0.29 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
23. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
24. [288.42 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 = '1548') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC LIMIT 9
25. [31.65 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. [23.83 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1548')
27. [9.13 ms] SELECT `stage_groups`.* FROM `stage_groups`
28. [7.37 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
29. [80.81 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 = '1548') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20
30. [1.9 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1548')
31. [5.41 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
32. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
33. [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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-12-01 15:10:52') 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-12-01 15:10:52') ORDER BY `dt_approved` DESC
34. [8.96 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-13 17:24:09') 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-13 17:24:09') ORDER BY `dt_approved` DESC
35. [4.75 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
36. [0.8 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-11 15:12:35') 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-11 15:12:35') ORDER BY `dt_approved` DESC
37. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='226')
38. [19.56 ms] SELECT `uf`.* FROM `user_photos` AS `uf` WHERE (uf.dt_created_photo = '2009-11-06 15:24:45') AND (uf.is_published_photo = 1) AND (uf.is_deleted_photo = 0) AND (uf.is_hidden_photo = 0) LIMIT 1
39. [0.5 ms] SELECT DISTINCT `uf`.*, `ug`.`gallery_name`, `ug`.`gallery_name_clean`, `ug`.`object_id`, `ug`.`gallery_logo`, `ug`.`is_deleted_gallery` FROM `user_photos` AS `uf` INNER JOIN `user_gallery` AS `ug` ON ug.gallery_id = uf.photo_gallery_id WHERE (1 AND uf.is_published_photo = 1 AND uf.is_deleted_photo = 0 AND DATE_FORMAT(uf.dt_created_photo,'%Y%m%d') = '20091106' AND ug.object_id = '1548' AND uf.photo_gallery_id = '257') ORDER BY `uf`.`dt_created_photo` DESC
40. [6.15 ms] SELECT `uf`.* FROM `user_photos` AS `uf` WHERE (uf.dt_created_photo = '2009-11-06 15:21:08') AND (uf.is_published_photo = 1) AND (uf.is_deleted_photo = 0) AND (uf.is_hidden_photo = 0) LIMIT 1
41. [9.22 ms] SELECT DISTINCT `uf`.*, `ug`.`gallery_name`, `ug`.`gallery_name_clean`, `ug`.`object_id`, `ug`.`gallery_logo`, `ug`.`is_deleted_gallery` FROM `user_photos` AS `uf` INNER JOIN `user_gallery` AS `ug` ON ug.gallery_id = uf.photo_gallery_id WHERE (1 AND uf.is_published_photo = 1 AND uf.is_deleted_photo = 0 AND DATE_FORMAT(uf.dt_created_photo,'%Y%m%d') = '20091106' AND ug.object_id = '1548' AND uf.photo_gallery_id = '256') ORDER BY `uf`.`dt_created_photo` DESC
42. [92.02 ms] SELECT `uf`.* FROM `user_photos` AS `uf` WHERE (uf.dt_created_photo = '2009-11-06 15:15:10') AND (uf.is_published_photo = 1) AND (uf.is_deleted_photo = 0) AND (uf.is_hidden_photo = 0) LIMIT 1
43. [17.61 ms] SELECT DISTINCT `uf`.*, `ug`.`gallery_name`, `ug`.`gallery_name_clean`, `ug`.`object_id`, `ug`.`gallery_logo`, `ug`.`is_deleted_gallery` FROM `user_photos` AS `uf` INNER JOIN `user_gallery` AS `ug` ON ug.gallery_id = uf.photo_gallery_id WHERE (1 AND uf.is_published_photo = 1 AND uf.is_deleted_photo = 0 AND DATE_FORMAT(uf.dt_created_photo,'%Y%m%d') = '20091106' AND ug.object_id = '1548' AND uf.photo_gallery_id = '255') ORDER BY `uf`.`dt_created_photo` DESC
44. [5.42 ms] SELECT `uf`.* FROM `user_photos` AS `uf` WHERE (uf.dt_created_photo = '2009-11-06 15:10:37') AND (uf.is_published_photo = 1) AND (uf.is_deleted_photo = 0) AND (uf.is_hidden_photo = 0) LIMIT 1
45. [11.83 ms] SELECT DISTINCT `uf`.*, `ug`.`gallery_name`, `ug`.`gallery_name_clean`, `ug`.`object_id`, `ug`.`gallery_logo`, `ug`.`is_deleted_gallery` FROM `user_photos` AS `uf` INNER JOIN `user_gallery` AS `ug` ON ug.gallery_id = uf.photo_gallery_id WHERE (1 AND uf.is_published_photo = 1 AND uf.is_deleted_photo = 0 AND DATE_FORMAT(uf.dt_created_photo,'%Y%m%d') = '20091106' AND ug.object_id = '1548' AND uf.photo_gallery_id = '251') ORDER BY `uf`.`dt_created_photo` DESC
46. [32.4 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-06 15:06:19') 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-06 15:06:19') ORDER BY `dt_approved` DESC
47. [31.17 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='111')
48. [22.67 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1548' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2009-11-06 07:35:26') ORDER BY `pc`.`dt_posted_p_comment` DESC
49. [2.5 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
50. [8.93 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1548' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2009-11-06 07:34:25') ORDER BY `pc`.`dt_posted_p_comment` DESC
51. [23.62 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
52. [27.35 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1548' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2009-11-06 07:33:34') ORDER BY `pc`.`dt_posted_p_comment` DESC
53. [32.11 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
54. [22.64 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-06 07:26: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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-06 07:26:29') ORDER BY `dt_approved` DESC
55. [18.43 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
56. [57.16 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-05 07:37:06') 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-05 07:37:06') ORDER BY `dt_approved` DESC
57. [29.72 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
58. [10.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 = '1548' AND v.dt_published_video = '2009-11-04 15:17:33')
59. [5.42 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 = '2391')
60. [10.23 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
61. [5 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
62. [9.18 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 = '1548' AND v.dt_published_video = '2009-11-04 15:11:11')
63. [14.69 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 = '2388')
64. [48.25 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
65. [19.98 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
66. [16.22 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 = '1548' AND v.dt_published_video = '2009-11-04 15:06:52')
67. [0.58 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 = '2387')
68. [2.9 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
69. [0.34 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
70. [10.57 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 = '1548' AND v.dt_published_video = '2009-11-04 15:02:23')
71. [32.1 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 = '2386')
72. [32.14 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
73. [32.17 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
74. [48.02 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 = '1548' AND v.dt_published_video = '2009-11-04 14:53:39')
75. [23.65 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 = '2385')
76. [0.45 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
77. [0.41 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
78. [0.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 = '1548' AND v.dt_published_video = '2009-11-04 14:47:55')
79. [0.42 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 = '2384')
80. [0.3 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
81. [8.47 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
82. [23.8 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 = '1548')
83. [48.11 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
84. [18.89 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 = '1548') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20 OFFSET 20
85. [0.4 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1548')
86. [4.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
87. [0.63 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 = '1548' AND v.dt_published_video = '2009-11-04 14:32:07')
88. [0.42 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 = '2383')
89. [0.26 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
90. [0.34 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
91. [73.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 = '1548' AND v.dt_published_video = '2009-11-04 14:25:48')
92. [7.95 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 = '2382')
93. [0.35 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
94. [0.38 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
95. [0.53 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 = '1548' AND v.dt_published_video = '2009-11-04 14:23:46')
96. [0.45 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 = '2381')
97. [0.3 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
98. [0.31 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
99. [0.49 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 = '1548' AND v.dt_published_video = '2009-11-04 14:18:33')
100. [0.41 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 = '2380')
101. [19.48 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
102. [6.17 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
103. [18.91 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1548' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2009-11-04 14:18:09') ORDER BY `pc`.`dt_posted_p_comment` DESC
104. [8.84 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
105. [23.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 = '1548' AND v.dt_published_video = '2009-11-04 14:16:52')
106. [48.4 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 = '2379')
107. [0.41 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
108. [0.28 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
109. [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 = '1548' AND v.dt_published_video = '2009-11-04 14:09:42')
110. [0.44 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 = '2378')
111. [0.3 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
112. [0.32 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
113. [0.49 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 = '1548' AND v.dt_published_video = '2009-11-04 13:53:41')
114. [0.41 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 = '2377')
115. [0.52 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
116. [0.27 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
117. [9.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_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '1548' AND v.dt_published_video = '2009-11-04 13:47:52')
118. [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 = '2376')
119. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
120. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
121. [0.29 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 = '1548' AND v.dt_published_video = '2009-11-04 13:41:13')
122. [24.74 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 = '2375')
123. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
124. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1548')
125. [11.04 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-03 09:37:30') 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='1548') AND (f.status = 2) AND (f.dt_approved = '2009-11-03 09:37:30') ORDER BY `dt_approved` DESC
126. [0.27 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='159')
127. [0.35 ms] SELECT `users`.* FROM `users` WHERE (login='FilmNet')
128. [0.2 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
129. [0.29 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
130. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
131. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
132. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
133. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
134. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
135. [0.44 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
136. [0.17 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
137. [0.2 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
138. [0.25 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
139. [0.25 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
140. [0.25 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
141. [0.27 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
142. [0.27 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
143. [0.29 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
144. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
145. [0.16 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')
146. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1548')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances