ZFDebug v1.5

©2008-2009 Joakim Nygård & Andreas Pankratz

The project is hosted at http://zfdebug.googlecode.com and released under the BSD License
Includes images from the Silk Icon set by Mark James

$_COOKIE

Request

View vars

HTML Information

Database queries

Adapter 0

1. [0.42 ms] connect
2. [0.75 ms] SELECT `users`.* FROM `users` WHERE (login='laserieonline')
3. [0.47 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
4. [0.31 ms] SELECT `user_types`.* FROM `user_types` WHERE (type_id=(SELECT `users`.`user_type_id` FROM `users` WHERE (user_id='1741')))
5. [0.2 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='207')
6. [0.9 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 = '1741')
7. [13.09 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 = '1741')
8. [25.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='1741') 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='1741') AND (f.status = 2) ORDER BY `dt_approved` DESC
9. [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=-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. [15.66 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='1741') 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='1741') AND (f.status = 2) ORDER BY `dt_approved` DESC
11. [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_rejected_video = 0 AND v.owner_id = '1741') ORDER BY `v`.`dt_published_video` DESC
12. [1.05 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 = '1741')
13. [11.99 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 = '1741') AND (is_deleted_photo =0) AND (is_published_photo =1) AND (is_deleted_gallery = 0) ORDER BY `dt_created_photo` DESC
14. [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_rejected_video = 0 AND v.owner_id = '1741') ORDER BY `v`.`dt_published_video` DESC LIMIT 3
15. [6.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='1741') 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='1741') AND (f.status = 2) ORDER BY `dt_approved` DESC, `dt_approved` DESC LIMIT 12
16. [0.31 ms] SELECT `c`.* FROM `countries` AS `c`
17. [0.41 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 = '1741') ORDER BY `dt_subscriber` DESC LIMIT 12
18. [0.3 ms] SELECT `c`.* FROM `countries` AS `c`
19. [0.22 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
20. [0.2 ms] SELECT `friends`.* FROM `friends` WHERE (recepient_id= 1741 and sender_id = -1) OR (sender_id = 1741 and recepient_id = -1)
21. [0.17 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 = '1741')
22. [0.15 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
23. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
24. [1.81 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 = '1741') 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 = '1741')
27. [0.13 ms] SELECT `stage_groups`.* FROM `stage_groups`
28. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
29. [6.65 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 = '1741') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20
30. [0.16 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1741')
31. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
32. [1.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='1741') AND (f.status = 2) AND (f.dt_approved = '2012-07-02 04:18:11') UNION SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.recepient_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.sender_id='1741') AND (f.status = 2) AND (f.dt_approved = '2012-07-02 04:18:11') ORDER BY `dt_approved` DESC
33. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='178')
34. [1.22 ms] SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.sender_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.recepient_id='1741') AND (f.status = 2) AND (f.dt_approved = '2012-05-09 03:34: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='1741') AND (f.status = 2) AND (f.dt_approved = '2012-05-09 03:34:48') ORDER BY `dt_approved` DESC
35. [0.13 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
36. [1.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='1741') AND (f.status = 2) AND (f.dt_approved = '2012-04-22 01:42:47') 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='1741') AND (f.status = 2) AND (f.dt_approved = '2012-04-22 01:42:47') ORDER BY `dt_approved` DESC
37. [0.13 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
38. [1.27 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='1741') AND (f.status = 2) AND (f.dt_approved = '2012-01-05 15:58: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='1741') AND (f.status = 2) AND (f.dt_approved = '2012-01-05 15:58:48') ORDER BY `dt_approved` DESC
39. [0.13 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='233')
40. [12.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='1741') AND (f.status = 2) AND (f.dt_approved = '2011-12-12 20:15: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='1741') AND (f.status = 2) AND (f.dt_approved = '2011-12-12 20:15:34') ORDER BY `dt_approved` DESC
41. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
42. [1.2 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='1741') AND (f.status = 2) AND (f.dt_approved = '2011-11-08 15:39: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='1741') AND (f.status = 2) AND (f.dt_approved = '2011-11-08 15:39:48') ORDER BY `dt_approved` DESC
43. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='231')
44. [0.58 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1741' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2011-11-04 03:50:23') ORDER BY `pc`.`dt_posted_p_comment` DESC
45. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='2315')
46. [1.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='1741') AND (f.status = 2) AND (f.dt_approved = '2011-06-26 02:46:23') UNION SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.recepient_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.sender_id='1741') AND (f.status = 2) AND (f.dt_approved = '2011-06-26 02:46:23') ORDER BY `dt_approved` DESC
47. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
48. [37.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='1741') AND (f.status = 2) AND (f.dt_approved = '2011-05-07 23:54: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='1741') AND (f.status = 2) AND (f.dt_approved = '2011-05-07 23:54:00') ORDER BY `dt_approved` DESC
49. [0.15 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='226')
50. [0.22 ms] SELECT `pc`.* FROM `profile_comments` AS `pc` WHERE (1 AND pc.owner_id = '1741' AND pc.is_deleted_p_comment = 0 AND pc.dt_posted_p_comment = '2010-11-04 01:29:52') ORDER BY `pc`.`dt_posted_p_comment` DESC
51. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='2328')
52. [1.26 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-10-25 16:54: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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-10-25 16:54:09') ORDER BY `dt_approved` DESC
53. [0.13 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='75')
54. [0.21 ms] SELECT `c`.* FROM `channels` AS `c` WHERE (c.owner_id='1741') AND (c.dt_published_channel='2010-09-22 17:26:16')
55. [3.31 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
56. [0.42 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 = '164')
57. [0.19 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='5')
58. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
59. [0.78 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 = '164') ORDER BY `v`.`dt_published_video` DESC
60. [1.41 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-09-11 06:00: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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-09-11 06:00:13') ORDER BY `dt_approved` DESC
61. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
62. [0.44 ms] SELECT `vr`.* FROM `video_likes` AS `vr` WHERE (dt_rate = '2010-09-09 09:31:09') AND (voter_id = '1741')
63. [0.22 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
64. [0.18 ms] SELECT `v`.* FROM `videos` AS `v` WHERE (video_id = '3575')
65. [0.23 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
66. [0.29 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 = '3575')
67. [0.2 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
68. [0.95 ms] SELECT `vp`.*, `p`.* FROM `video__playlists` AS `vp` INNER JOIN `playlists` AS `p` ON p.playlist_id = vp.playlist_id WHERE (p.owner_id = '1741') AND (vp.dt_video_added = '2010-09-09 09:31:00')
69. [0.18 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 = '3575')
70. [0.21 ms] SELECT `v`.* FROM `videos` AS `v` WHERE (video_id = '3575')
71. [0.13 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
72. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
73. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
74. [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 = '1741' AND v.dt_published_video = '2010-09-08 23:17:39')
75. [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 = '3575')
76. [0.13 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='5')
77. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
78. [29.95 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-08-23 16:10:58') ORDER BY `ut`.`dt_created_twitt` ASC
79. [0.3 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
80. [1.39 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-08-19 00:07:23') UNION SELECT `f`.*, `u`.* FROM `friends` AS `f` LEFT JOIN `users` AS `u` ON f.recepient_id = u.user_id WHERE (u.is_deleted_user = 0) AND (f.sender_id='1741') AND (f.status = 2) AND (f.dt_approved = '2010-08-19 00:07:23') ORDER BY `dt_approved` DESC
81. [0.29 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-08-16 17:58:57') ORDER BY `ut`.`dt_created_twitt` ASC
82. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
83. [0.28 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-08-11 11:42:16') ORDER BY `ut`.`dt_created_twitt` ASC
84. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
85. [9.74 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 = '1741')
86. [0.2 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
87. [1.08 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 = '1741') ORDER BY `st`.`dt_created_stage` DESC LIMIT 20 OFFSET 20
88. [0.19 ms] SELECT `user_settings`.* FROM `user_settings` WHERE (user_id = '1741')
89. [0.22 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
90. [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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-08-08 18:35:15') 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-08-08 18:35:15') ORDER BY `dt_approved` DESC
91. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='234')
92. [0.3 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-08-05 10:58:07') ORDER BY `ut`.`dt_created_twitt` ASC
93. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
94. [1.33 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-08-04 12:07:46') 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-08-04 12:07:46') ORDER BY `dt_approved` DESC
95. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='168')
96. [1.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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-08-01 10:36:51') 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-08-01 10:36:51') ORDER BY `dt_approved` DESC
97. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='233')
98. [0.26 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-07-26 15:40:41') ORDER BY `ut`.`dt_created_twitt` ASC
99. [15.7 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
100. [20.69 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-07-22 14:09:48') ORDER BY `ut`.`dt_created_twitt` ASC
101. [0.24 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
102. [0.37 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-07-17 17:58:19') ORDER BY `ut`.`dt_created_twitt` ASC
103. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
104. [0.43 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-07-16 15:36:06') ORDER BY `ut`.`dt_created_twitt` ASC
105. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
106. [1.41 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-07-11 19:12:14') 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-07-11 19:12:14') ORDER BY `dt_approved` DESC
107. [0.14 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='233')
108. [15.21 ms] SELECT `c`.* FROM `video_comments` AS `c` WHERE (1 AND c.level <> 0 AND c.dt_posted_comment = '2010-07-11 09:49:27' AND c.user_id = '1741' AND c.is_deleted_comment = 0) ORDER BY `left_id` ASC
109. [0.2 ms] SELECT `v`.* FROM `videos` AS `v` WHERE (video_id = '2796')
110. [0.22 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
111. [0.3 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 = '2796')
112. [0.14 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='10')
113. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
114. [37.62 ms] SELECT `uf`.* FROM `user_photos` AS `uf` WHERE (uf.dt_created_photo = '2010-07-11 09:46:58') AND (uf.is_published_photo = 1) AND (uf.is_deleted_photo = 0) AND (uf.is_hidden_photo = 0) LIMIT 1
115. [13.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') = '20100711' AND ug.object_id = '1741' AND uf.photo_gallery_id = '320') ORDER BY `uf`.`dt_created_photo` DESC
116. [0.81 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
117. [0.75 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-07-05 22:32:33') ORDER BY `ut`.`dt_created_twitt` ASC
118. [0.73 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
119. [13.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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-07-01 22:42: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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-07-01 22:42:37') ORDER BY `dt_approved` DESC
120. [1.52 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='233')
121. [0.63 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-06-27 11:39:19') ORDER BY `ut`.`dt_created_twitt` ASC
122. [15.84 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
123. [0.25 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-06-27 11:39:00') ORDER BY `ut`.`dt_created_twitt` ASC
124. [0.21 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
125. [0.23 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-06-27 10:57:25') ORDER BY `ut`.`dt_created_twitt` ASC
126. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
127. [0.23 ms] SELECT `ut`.* FROM `user_twitts` AS `ut` WHERE (1 AND ut.twitt_owner_id = '1741' AND ut.dt_created_twitt = '2010-06-27 10:04:42') ORDER BY `ut`.`dt_created_twitt` ASC
128. [0.18 ms] SELECT `users`.* FROM `users` WHERE (user_id='1741')
129. [1.57 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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-06-15 06:50: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='1741') AND (f.status = 2) AND (f.dt_approved = '2010-06-15 06:50:35') ORDER BY `dt_approved` DESC
130. [0.16 ms] SELECT `countries`.* FROM `countries` WHERE (country_id='14')
131. [0.24 ms] SELECT `po`.* FROM `privacy_options` AS `po` WHERE (po.is_active = 1) ORDER BY `po`.`option_order` ASC
132. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
133. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
134. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
135. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
136. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
137. [0.54 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
138. [0.14 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
139. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
140. [13.32 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
141. [0.13 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
142. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
143. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
144. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
145. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
146. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
147. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
148. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')
149. [0.12 ms] SELECT `us`.`privacy_settings` FROM `user_settings` AS `us` WHERE (user_id = '1741')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances