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. [10.47 ms] connect
2. [0.43 ms] SELECT `users`.* FROM `users` WHERE (login='FatCatFilms')
3. [0.32 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
4. [0.37 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='1423')))
5. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='75')
6. [0.96 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 = '1423')
7. [0.26 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 = '1423')
8. [28.43 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='1423') 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='1423') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [0.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=-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. [2.54 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='1423') 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='1423') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [17.07 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 = '1423') ORDER BY `v`.`dt_published_video` DESC
12. [0.19 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 = '1423')
13. [3.69 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 = '1423') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [11.14 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 = '1423') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [2.06 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='1423') 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='1423') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [1.75 ms] SELECT `c`.* FROM `countries` AS `c`
17. [5.21 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 = '1423') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [0.45 ms] SELECT `c`.* FROM `countries` AS `c`
19. [2.16 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
20. [0.19 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1423 and sender_id = -1) OR (sender_id = 1423 and recepient_id = -1)
21. [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 = '1423')
22. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
23. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
24. [14.76 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 = '1423') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC LIMIT 9
25. [2.76 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.16 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1423')
27. [0.21 ms] SELECT `stage_groups`.* FROM `stage_groups`
28. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
29. [2.91 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 = '1423') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20
30. [0.17 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1423')
31. [0.3 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
32. [0.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 = '1423' AND v.dt_published_video = '2010-11-14 18:55:18')
33. [1.25 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 = '3741')
34. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='10')
35. [3.87 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
36. [13.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_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '1423' AND v.dt_published_video = '2010-11-14 18:54:08')
37. [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 = '3740')
38. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='10')
39. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
40. [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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-11-14 15:07:00') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-11-14 15:07:00') ORDER BY `dt_approved` DESC
41. [3.36 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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-04-09 11:52: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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-04-09 11:52:07') ORDER BY `dt_approved` DESC
42. [0.31 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' AND v.dt_published_video = '2010-03-16 07:16:31')
43. [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 = '3029')
44. [2.65 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
45. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
46. [0.31 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' AND v.dt_published_video = '2010-03-09 18:44:20')
47. [22.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 = '3013')
48. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
49. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
50. [25.18 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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-03-09 10:02: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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-03-09 10:02:53') ORDER BY `dt_approved` DESC
51. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
52. [0.31 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' AND v.dt_published_video = '2010-02-09 06:04:49')
53. [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 = '2950')
54. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
55. [0.18 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
56. [0.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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-02-04 11:22: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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-02-04 11:22:10') ORDER BY `dt_approved` DESC
57. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='207')
58. [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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-01-25 00:45: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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-01-25 00:45:29') ORDER BY `dt_approved` DESC
59. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='82')
60. [0.97 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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 17:49:17') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 17:49:17') ORDER BY `dt_approved` DESC
61. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
62. [0.9 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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-01-14 09:12:37') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-01-14 09:12:37') ORDER BY `dt_approved` DESC
63. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
64. [11.54 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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-01-14 09: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='1423') AND (f.status = 2) AND (f.dt_approved = '2010-01-14 09:12:35') ORDER BY `dt_approved` DESC
65. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='207')
66. [0.18 ms] SELECT `c`.* FROM `channels` AS `c` WHERE (c.owner_id='1423') AND (c.dt_published_channel='2010-01-08 14:02:55')
67. [3.73 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
68. [0.57 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 = '146')
69. [0.17 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
70. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
71. [25.47 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 = '146') ORDER BY `v`.`dt_published_video` DESC
72. [0.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 = '1423' AND v.dt_published_video = '2010-01-08 09:06:47')
73. [0.73 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 = '2818')
74. [0.78 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
75. [12.59 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
76. [0.86 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-12-21 10:37:43') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-12-21 10:37:43') ORDER BY `dt_approved` DESC
77. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='233')
78. [2.3 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-12-21 10:37:41') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-12-21 10:37:41') ORDER BY `dt_approved` DESC
79. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
80. [0.65 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-12-21 10:37:40') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-12-21 10:37:40') ORDER BY `dt_approved` DESC
81. [13.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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-30 09:14:58') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-30 09:14:58') ORDER BY `dt_approved` DESC
82. [0.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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-21 15:39: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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-21 15:39:09') ORDER BY `dt_approved` DESC
83. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
84. [0.86 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 = '1423')
85. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
86. [0.66 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 = '1423') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20 OFFSET 20
87. [0.17 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1423')
88. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
89. [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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-21 15:39: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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-21 15:39:06') ORDER BY `dt_approved` DESC
90. [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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-07 16:13:20') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-07 16:13:20') ORDER BY `dt_approved` DESC
91. [15.32 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='100')
92. [18.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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-07 16:13: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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-07 16:13:19') ORDER BY `dt_approved` DESC
93. [0.95 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='226')
94. [2.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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-07 16:13:17') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-11-07 16:13:17') ORDER BY `dt_approved` DESC
95. [0.12 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
96. [128.86 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-31 03:49:05') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-31 03:49:05') ORDER BY `dt_approved` DESC
97. [1.41 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
98. [1.88 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-30 19:39: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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-30 19:39:34') ORDER BY `dt_approved` DESC
99. [8.64 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
100. [16.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 = '1423' AND v.dt_published_video = '2009-10-30 16:53:11')
101. [2.83 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 = '2334')
102. [0.64 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
103. [1.37 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
104. [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 = '1423' AND v.dt_published_video = '2009-10-30 16:45:44')
105. [0.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 = '2330')
106. [14.79 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
107. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
108. [2.55 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-30 14:51: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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-30 14:51:08') ORDER BY `dt_approved` DESC
109. [0.13 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
110. [1.25 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 21:33:21') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 21:33:21') ORDER BY `dt_approved` DESC
111. [1.52 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='183')
112. [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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 20:49:22') 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='1423') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 20:49:22') ORDER BY `dt_approved` DESC
113. [0.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='56')
114. [1.8 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' AND v.dt_published_video = '2009-10-29 13:24:13')
115. [0.6 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 = '2306')
116. [2.79 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
117. [0.23 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
118. [0.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 = '1423' AND v.dt_published_video = '2009-10-29 11:15:47')
119. [0.28 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 = '2305')
120. [0.88 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
121. [5.67 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
122. [12.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_hidden_video = 0 AND v.is_rejected_video = 0 AND v.owner_id = '1423' AND v.dt_published_video = '2009-10-29 11:11:32')
123. [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 = '2302')
124. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
125. [0.59 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
126. [1.13 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' AND v.dt_published_video = '2009-10-29 11:08:53')
127. [2.97 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 = '2300')
128. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
129. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
130. [0.31 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' AND v.dt_published_video = '2009-10-29 10:50:28')
131. [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 = '2297')
132. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
133. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
134. [0.3 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' AND v.dt_published_video = '2009-10-29 10:47:31')
135. [10.04 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 = '2304')
136. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
137. [1.65 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
138. [1.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 = '1423' AND v.dt_published_video = '2009-10-29 10:26:41')
139. [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 = '2303')
140. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
141. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
142. [11.96 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' AND v.dt_published_video = '2009-10-29 10:20:12')
143. [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 = '2301')
144. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
145. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
146. [2.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 = '1423' AND v.dt_published_video = '2009-10-29 10:13:48')
147. [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 = '2296')
148. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
149. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1423')
150. [0.16 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
151. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
152. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
153. [10.63 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
154. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
155. [0.17 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
156. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
157. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
158. [0.2 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
159. [0.51 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
160. [2.26 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
161. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
162. [0.17 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
163. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
164. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
165. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
166. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
167. [8.62 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')
168. [1.95 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1423')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances