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. [20.31 ms] connect
2. [0.97 ms] SELECT `ch`.* FROM `channels` AS `ch` LEFT JOIN `channel__channel_genres` AS `cg` ON cg.channel_id = ch.channel_id WHERE (1 AND ch.channel_alias = 'VFSMakeupDesignforFilmAndTelevision')
3. [0.66 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='3')
4. [1.13 ms] SELECT `ccg`.*, `cg`.* FROM `channel__channel_genres` AS `ccg` LEFT JOIN `channel_genres` AS `cg` ON cg.genre_id = ccg.genre_id WHERE (ccg.channel_id = '91')
5. [2.87 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 cv.channel_id = '91') ORDER BY `v`.`dt_published_video` DESC
6. [9.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 = '4778')
7. [0.31 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
8. [0.95 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
9. [9.48 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 = '4776')
10. [31.52 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
11. [16.07 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
12. [9.85 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 = '3659')
13. [0.43 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
14. [0.38 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
15. [32.13 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 = '3591')
16. [15.92 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
17. [16 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
18. [8.88 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 = '3391')
19. [3.52 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='11')
20. [10.99 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
21. [12.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 = '3390')
22. [0.25 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='11')
23. [0.35 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
24. [0.5 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 = '3389')
25. [0.31 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
26. [0.29 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
27. [8.27 ms] SELECT `vvg`.*, `vg`.* FROM `video__video_genres` AS `vvg` LEFT JOIN `video_genres` AS `vg` ON vg.genre_id = vvg.genre_id WHERE (vvg.video_id = '2896')
28. [0.3 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='10')
29. [0.47 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
30. [0.38 ms] SELECT `vvg`.*, `vg`.* FROM `video__video_genres` AS `vvg` LEFT JOIN `video_genres` AS `vg` ON vg.genre_id = vvg.genre_id WHERE (vvg.video_id = '2231')
31. [0.23 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='11')
32. [0.3 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
33. [2.87 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 = '1805')
34. [0.59 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
35. [24.51 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
36. [23.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 = '1012')
37. [9.34 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='11')
38. [0.32 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
39. [0.7 ms] SELECT DISTINCT `ch`.* FROM `channels` AS `ch` WHERE (1 AND ch.is_published_channel = 1 AND ch.is_deleted_channel = 0 AND ch.is_hidden_channel = 0 AND ch.owner_id = '497') ORDER BY `ch`.`channel_name` ASC
40. [93.69 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '81')
41. [15.86 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
42. [469.58 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 cv.channel_id = '81')
43. [0.42 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '85')
44. [0.18 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='3')
45. [84.89 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 cv.channel_id = '85')
46. [9.29 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '95')
47. [0.13 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
48. [1.5 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 cv.channel_id = '95')
49. [0.14 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '86')
50. [0.11 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
51. [14.92 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 cv.channel_id = '86')
52. [0.15 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '87')
53. [0.11 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
54. [2.68 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 cv.channel_id = '87')
55. [13.73 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '88')
56. [0.12 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
57. [3.15 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 cv.channel_id = '88')
58. [0.15 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '89')
59. [0.11 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
60. [29.26 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 cv.channel_id = '89')
61. [3.64 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '90')
62. [0.12 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='3')
63. [1.03 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 cv.channel_id = '90')
64. [0.29 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '92')
65. [0.12 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
66. [31.67 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 cv.channel_id = '92')
67. [0.16 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '93')
68. [0.12 ms] SELECT `channel_categories`.* FROM `channel_categories` WHERE (category_id ='2')
69. [2.7 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 cv.channel_id = '93')
70. [0.99 ms] SELECT SQL_CALC_FOUND_ROWS 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 cv.channel_id = '91') ORDER BY `v`.`dt_published_video` DESC LIMIT 12
71. [0.07 ms] SELECT FOUND_ROWS() AS zend_paginator_row_count
72. [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 = '4778')
73. [0.19 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
74. [0.29 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
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 = '4776')
76. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
77. [14.26 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
78. [0.21 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 = '3659')
79. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
80. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
81. [0.2 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 = '3591')
82. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
83. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
84. [0.2 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 = '3391')
85. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='11')
86. [0.26 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
87. [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 = '3390')
88. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='11')
89. [2.91 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
90. [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 = '3389')
91. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
92. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
93. [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 = '2896')
94. [0.12 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='10')
95. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
96. [0.2 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 = '2231')
97. [12.98 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='11')
98. [0.2 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
99. [0.2 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 = '1805')
100. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='2')
101. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
102. [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 = '1012')
103. [0.11 ms] SELECT `video_categories`.* FROM `video_categories` WHERE (category_id ='11')
104. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
105. [0.15 ms] SELECT `cs`.* FROM `channel_subscribers` AS `cs` WHERE (user_id = -1) AND (channel_id = '91')
106. [0.19 ms] SELECT `users`.* FROM `users` WHERE (user_id='497')
107. [1.03 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 cv.channel_id = '91') ORDER BY `v`.`dt_published_video` DESC
108. [0.41 ms] SELECT `vt`.* FROM `video_types` AS `vt` LEFT JOIN `videos` AS `v` ON vt.type_id = v.video_type_id LEFT JOIN `channel__videos` AS `cv` ON v.video_id = cv.video_id WHERE (cv.channel_id = '91') AND (is_published_video = 1) AND (is_deleted_video = 0) AND (is_hidden_video = 0) GROUP BY `type_name`
109. [0.27 ms] SELECT `vc`.* FROM `video_categories` AS `vc` LEFT JOIN `videos` AS `v` ON vc.category_id = v.video_category_id LEFT JOIN `channel__videos` AS `cv` ON v.video_id = cv.video_id WHERE (cv.channel_id = '91') AND (v.is_published_video = 1) AND (v.is_deleted_video = 0) AND (v.is_hidden_video = 0) GROUP BY `category_name` ORDER BY `priority` ASC
110. [0.33 ms] SELECT `vg`.* FROM `video_genres` AS `vg` LEFT JOIN `video__video_genres` AS `vvg` ON vg.genre_id = vvg.genre_id LEFT JOIN `channel__videos` AS `cv` ON vvg.video_id = cv.video_id LEFT JOIN `videos` AS `v` ON cv.video_id = v.video_id WHERE (cv.channel_id = '91') AND (v.is_published_video = 1) AND (v.is_deleted_video = 0) AND (v.is_hidden_video = 0) GROUP BY `genre_name`
111. [1.13 ms] SELECT DISTINCT `ch`.* FROM `channels` AS `ch` WHERE (1 AND ch.is_published_channel = 1 AND ch.is_deleted_channel = 0 AND ch.is_hidden_channel = 0 AND ch.owner_id = '497')
112. [6.93 ms] SELECT `graphic_themes`.* FROM `graphic_themes` WHERE (theme_id = '1')

File Information

Application Files

Zend Library Files

ZFDebug Library Files

Memory Usage

Custom Timers

Overall Timers

Registered Instances