Bammy awards

BAM TV
bammy1820 » 5am - Oct 8, 2014
3iTalk: Taylor Mali at the 2014 Bammy Awards
Rating: 2.3 (362 Votes)

Profile Information

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.021 seconds, 6.48 MB
Application afterRoute: 0.029 seconds, 8.76 MB
Application afterDispatch: 0.099 seconds, 16.46 MB
Application afterRender: 0.117 seconds, 17.69 MB

Memory Usage

18665088

117 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '9fe01d0c2e6a64b40e80887c2f51e331'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1493591243' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '9fe01d0c2e6a64b40e80887c2f51e331'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '9fe01d0c2e6a64b40e80887c2f51e331','1493598443','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT setting,VALUE
      FROM jos_jfbconnect_config
  8. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  9. SELECT COUNT(*)
      FROM jos_menu
      WHERE id = 172
      AND link = "index.php?option=com_hwdvideoshare&task=viewvideo"
      AND published = 1
  10. SELECT id
      FROM jos_menu
      WHERE link = "index.php?option=com_hwdvideoshare&task=viewvideo"
      AND published = 1
      LIMIT 0, 1
  11. SELECT id
      FROM jos_menu
      WHERE link = "index.php?option=com_hwdvideoshare&task=frontpage"
      AND published = 1
  12. SELECT id
      FROM jos_menu
      WHERE id = 172
      AND link LIKE "%com_hwdvideoshare%"
      AND published = 1
  13. SELECT id ,parent,category_name, access_u, access_lev_u, access_u_r
      FROM jos_hwdvidscategories

      WHERE published = 1

      ORDER BY category_name
  14. SELECT g1.id AS group_id, g1.name
     
      FROM jos_core_acl_aro_groups g1
     
      LEFT JOIN jos_core_acl_aro_groups g2
      ON g2.lft <= g1.lft
     
      WHERE g2.id =24
     
      ORDER BY g1.name
  15. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  16. SELECT g1.id AS group_id, g1.name
     
      FROM jos_core_acl_aro_groups g1
     
      LEFT JOIN jos_core_acl_aro_groups g2
      ON g2.lft <= g1.lft
     
      WHERE g2.id =25
     
      ORDER BY g1.name
  17. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  18. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  19. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  20. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  21. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  22. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  23. SELECT id
      FROM jos_core_acl_aro_groups
      WHERE  VALUE='Registered'
  24. SELECT video.*, u.name, u.username
      FROM jos_hwdvidsvideos AS video
      LEFT JOIN jos_users AS u
      ON u.id = video.user_id
      WHERE video.id = 95
      ORDER BY video.date_uploaded DESC
  25. INSERT INTO `jos_hwdvidslogs_views` ( `videoid`,`userid`,`date` )
      VALUES ( '95','0','2017-04-30 18:27:23' )
  26. SELECT COUNT(*)
      FROM jos_hwdvidslogs_views
      WHERE videoid = 95
  27. SELECT views
      FROM jos_hwdvidslogs_archive
      WHERE videoid = 95
  28. UPDATE jos_hwdvidsvideos
      SET number_of_views = 3892
      WHERE id = 95
  29. UPDATE jos_hwdvidsvideos
      SET number_of_views = 3892
      WHERE id = 95
  30. SELECT video.*, u.name, u.username
      FROM jos_hwdvidsvideos AS video
      LEFT JOIN jos_users AS u
      ON u.id = video.user_id
      WHERE video.user_id = 62
      AND video.published = 1
      AND video.approved = "yes"
      AND video.id <> 95
      ORDER BY video.date_uploaded DESC
      LIMIT 0, 10
  31. SELECT video.*, u.name, u.username
      FROM jos_hwdvidsvideos AS video
      LEFT JOIN jos_users AS u
      ON u.id = video.user_id
      WHERE MATCH (title,description,tags) AGAINST ('3iTalk: Taylor Mali <p>3iTalk: Taylor Mali at the 2014 Bammy Awards</p> Taylor Mali Author  bammyawards  keynotes  speakers  education  3iTalks  TED  TEDTalks')
      AND video.published = 1
      AND video.approved = 'yes'
      AND video.published = 1
      AND video.approved = "yes"
      AND video.id <> 95
      LIMIT 0, 10
  32. SELECT video.*, u.name, u.username
      FROM jos_hwdvidsvideos AS video
      LEFT JOIN jos_users AS u
      ON u.id = video.user_id
      LEFT JOIN jos_hwdvidsvideo_category AS cmap
      ON cmap.videoid = video.id
      WHERE cmap.categoryid = 95
      AND video.published = 1
      AND video.approved = "yes"
      AND video.id <> 95
      ORDER BY video.ordering ASC
      LIMIT 0, 10
  33. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 95
  34. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 95
  35. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 95
  36. SELECT COUNT(*)
      FROM jos_hwdvidsfavorites AS a
      WHERE a.userid = 0
      AND a.videoid = 95
  37. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 95
  38. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 95
  39. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  40. SELECT id, category_name
      FROM jos_hwdvidscategories
  41. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 95
  42. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 172)
      ORDER BY menuid DESC
      LIMIT 0, 1
  43. SELECT COUNT(*)
      FROM jos_hwdvidsfavorites AS a
      WHERE a.userid = 0
      AND a.videoid = 95
  44. SELECT COUNT(*)
      FROM jos_hwdvidsplaylists
      WHERE user_id = 0
  45. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 31
  46. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 31
  47. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 15
  48. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 31
  49. SELECT g1.id AS group_id, g1.name
     
      FROM jos_core_acl_aro_groups g1
     
      LEFT JOIN jos_core_acl_aro_groups g2
      ON g2.lft <= g1.lft
     
      WHERE g2.id =21
     
      ORDER BY g1.name
  50. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 112
  51. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 112
  52. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  53. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 112
  54. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 100
  55. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 100
  56. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  57. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 100
  58. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 102
  59. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 102
  60. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  61. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 102
  62. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 107
  63. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 107
  64. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  65. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 107
  66. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 127
  67. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 127
  68. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  69. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 127
  70. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 109
  71. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 109
  72. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  73. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 109
  74. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 127
  75. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 127
  76. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  77. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 127
  78. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 126
  79. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 126
  80. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  81. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 126
  82. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 125
  83. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 125
  84. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  85. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 125
  86. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 123
  87. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 123
  88. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  89. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 123
  90. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 122
  91. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 122
  92. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  93. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 122
  94. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 121
  95. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 121
  96. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  97. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 121
  98. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 120
  99. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 120
  100. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  101. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 120
  102. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 119
  103. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 119
  104. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  105. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 119
  106. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 118
  107. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 118
  108. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  109. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 118
  110. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 117
  111. SELECT *
      FROM jos_hwdvidsvideo_category
      WHERE videoid = 117
  112. SELECT c.category_name
      FROM jos_hwdvidscategories AS c
      WHERE c.id = 19
  113. SELECT v.title, c.category_name
      FROM jos_hwdvidsvideos AS v
      LEFT JOIN jos_hwdvidscategories AS c
      ON c.id = v.category_id
      WHERE v.id = 117
  114. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  115. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 172 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  116. SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='topmenu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
  117. SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None