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. [4.39 ms] connect
2. [1.95 ms] SELECT `users`.* FROM `users` WHERE (login='silvanderwoerd')
3. [0.4 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
4. [0.32 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='1323')))
5. [0.24 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='156')
6. [0.88 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 = '1323')
7. [0.27 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 = '1323')
8. [116.17 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='1323') 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='1323') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [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=-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. [12.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='1323') 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='1323') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [0.62 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 = '1323') ORDER BY `v`.`dt_published_video` DESC
12. [0.34 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 = '1323')
13. [467.02 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 = '1323') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [3.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_rejected_video = 0 AND v.owner_id = '1323') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [122.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='1323') 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='1323') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [19.42 ms] SELECT `c`.* FROM `countries` AS `c`
17. [73.45 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 = '1323') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [31.86 ms] SELECT `c`.* FROM `countries` AS `c`
19. [31.23 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
20. [31.98 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1323 and sender_id = -1) OR (sender_id = 1323 and recepient_id = -1)
21. [32.04 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 = '1323')
22. [35.94 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
23. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
24. [62.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 = '1323') 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.6 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.19 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1323')
27. [0.1 ms] SELECT `stage_groups`.* FROM `stage_groups`
28. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
29. [89.61 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 = '1323') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20
30. [0.25 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1323')
31. [0.29 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
32. [4.34 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-07-28 17:16: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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-07-28 17:16:40') ORDER BY `dt_approved` DESC
33. [0.38 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='231')
34. [0.63 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1323' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2010-05-31 06:37:10') ORDER BY `pc`.`dt_posted_p_comment` DESC
35. [0.36 ms] SELECT `users`.* FROM `users` WHERE (user_id='2328')
36. [0.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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-04-09 16:30: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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-04-09 16:30:40') ORDER BY `dt_approved` DESC
37. [0.31 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='207')
38. [0.98 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-04-08 17:40: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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-04-08 17:40:43') ORDER BY `dt_approved` DESC
39. [0.27 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
40. [12.52 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
41. [1.38 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-03-29 16:09:12') 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-03-29 16:09:12') ORDER BY `dt_approved` DESC
42. [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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-03-29 16:09: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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-03-29 16:09:11') ORDER BY `dt_approved` DESC
43. [4.09 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='207')
44. [0.71 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-28 16:34:55') 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-28 16:34:55') ORDER BY `dt_approved` DESC
45. [26.51 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-24 06:30: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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-24 06:30:17') ORDER BY `dt_approved` DESC
46. [52.89 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
47. [9.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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 18:16: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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 18:16:56') ORDER BY `dt_approved` DESC
48. [108.69 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
49. [33.45 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 18:16: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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-21 18:16:10') ORDER BY `dt_approved` DESC
50. [15.76 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
51. [23.99 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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-15 08:24: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='1323') AND (f.status = 2) AND (f.dt_approved = '2010-01-15 08:24:05') ORDER BY `dt_approved` DESC
52. [0.38 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='233')
53. [1.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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-12-12 16:43:38') 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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-12-12 16:43:38') ORDER BY `dt_approved` DESC
54. [29.07 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='108')
55. [5.71 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1323' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2009-12-12 10:00:45') ORDER BY `pc`.`dt_posted_p_comment` DESC
56. [0.45 ms] SELECT `users`.* FROM `users` WHERE (user_id='194')
57. [1.07 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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-12-02 15:38: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-12-02 15:38:34') ORDER BY `dt_approved` DESC
58. [39.88 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
59. [8.98 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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-11-29 22:52: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-11-29 22:52:20') ORDER BY `dt_approved` DESC
60. [30.28 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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-11-12 08:04: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-11-12 08:04:35') ORDER BY `dt_approved` DESC
61. [40.11 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='109')
62. [22.52 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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-11-06 06:56:36') 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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-11-06 06:56:36') ORDER BY `dt_approved` DESC
63. [15.6 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
64. [16.93 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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-11-05 08:55: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-11-05 08:55:06') ORDER BY `dt_approved` DESC
65. [22.86 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='143')
66. [17.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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-31 08:21: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-31 08:21:43') ORDER BY `dt_approved` DESC
67. [31.08 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='100')
68. [88.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 = '1323')
69. [55.71 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
70. [16.73 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 = '1323') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20 OFFSET 20
71. [31.34 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1323')
72. [32.14 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
73. [31.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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 22:55: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 22:55:31') ORDER BY `dt_approved` DESC
74. [76.65 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='159')
75. [1.92 ms] SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.sender_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.recepient_id='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 21:59: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 21:59:11') ORDER BY `dt_approved` DESC
76. [0.17 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
77. [0.76 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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 21:59: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 21:59:09') ORDER BY `dt_approved` DESC
78. [0.16 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
79. [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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 21:59: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='1323') AND (f.status = 2) AND (f.dt_approved = '2009-10-29 21:59:06') ORDER BY `dt_approved` DESC
80. [0.41 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 = '1323' AND v.dt_published_video = '2009-09-22 16:01:44')
81. [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 = '851')
82. [0.68 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='6')
83. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
84. [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 = '1323' AND v.dt_published_video = '2009-09-22 16:00:25')
85. [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 = '850')
86. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='6')
87. [0.76 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
88. [1.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 = '1323' AND v.dt_published_video = '2009-09-22 15:58:37')
89. [1.34 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 = '849')
90. [14.71 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
91. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
92. [0.25 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 = '1323' AND v.dt_published_video = '2009-09-22 15:57:45')
93. [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 = '848')
94. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
95. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
96. [2.56 ms] SELECT `uf`.* FROM `user_photos` AS `uf` WHERE (uf.dt_created_photo = '2009-09-22 14:14:10') AND (uf.is_published_photo = 1) AND (uf.is_deleted_photo = 0) AND (uf.is_hidden_photo = 0) LIMIT 1
97. [0.78 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') = '20090922' AND ug.object_id = '1323' AND uf.photo_gallery_id = '183') ORDER BY `uf`.`dt_created_photo` DESC
98. [0.32 ms] SELECT `c`.* FROM `channels` AS `c` WHERE (c.owner_id='1323') AND (c.dt_published_channel='2009-09-22 09:00:00')
99. [40.09 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
100. [52.77 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 = '79')
101. [31.34 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='6')
102. [28.81 ms] SELECT `users`.* FROM `users` WHERE (user_id='1323')
103. [7.34 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 = '79') ORDER BY `v`.`dt_published_video` DESC
104. [32.14 ms] SELECT `users`.* FROM `users` WHERE (login='FilmNet')
105. [4.83 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
106. [0.99 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
107. [18.28 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
108. [14.78 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
109. [40.71 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
110. [15.42 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
111. [16.09 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
112. [7.17 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
113. [1.21 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
114. [14.99 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
115. [36.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
116. [44.15 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
117. [21.54 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
118. [18.3 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
119. [48.37 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
120. [18.99 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
121. [36.96 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
122. [11.64 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')
123. [25.81 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1323')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances