IMG_0590
IMG_0590
- Catégorie: Non catégorisé
- Durée: 00:41
- Date: Il y a 7 ans
Chargement
IMG_0590
Array ( [0] => Array ( [q] => SELECT * FROM v4_config [timetook] => 0.00023603439331055 [memBefore] => 0.51633453369141 [memAfter] => 0.54121398925781 [memUsed] => 0.024879455566406 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/functions_db.php(10): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/my_queries.class.php(32): db_select() #5 /var/www/upload/includes/common.php(98): myquery->Get_Website_Details() #6 /var/www/upload/includes/config.inc.php(9): require_once() #7 /var/www/upload/watch_video.php(4): require() ) [1] => Array ( [q] => SELECT * FROM v4_languages WHERE language_default='yes' [timetook] => 0.00014185905456543 [memBefore] => 0.54121398925781 [memAfter] => 0.72055053710938 [memUsed] => 0.17933654785156 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(310): Clipbucket_db->select() #5 /var/www/upload/includes/classes/lang.class.php(66): Language->getDefaultLanguage() #6 /var/www/upload/includes/common.php(148): Language->init() #7 /var/www/upload/includes/config.inc.php(9): require_once() #8 /var/www/upload/watch_video.php(4): require() ) [2] => Array ( [q] => SELECT language_key, translation FROM v4_languages_keys AS LK LEFT JOIN v4_languages_translations AS LT ON LK.id_language_key = LT.id_language_key AND LT.language_id = 13 ORDER BY CASE WHEN LT.translation IS NULL THEN concat('aaaaaaaaaaaaaaaaaaaa',language_key) ELSE LK.language_key END [timetook] => 0.00072598457336426 [memBefore] => 0.72055053710938 [memAfter] => 0.79294586181641 [memUsed] => 0.072395324707031 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(147): Clipbucket_db->select() #5 /var/www/upload/includes/classes/lang.class.php(208): Language->getAllTranslations() #6 /var/www/upload/includes/classes/lang.class.php(75): Language->loadTranslations() #7 /var/www/upload/includes/common.php(148): Language->init() #8 /var/www/upload/includes/config.inc.php(9): require_once() #9 /var/www/upload/watch_video.php(4): require() ) [3] => Array ( [q] => SELECT * FROM v4_sessions WHERE session ='46eia88cbgt25f0dmtr21seovk' [timetook] => 0.00043106079101562 [memBefore] => 0.79294586181641 [memAfter] => 0.91496276855469 [memUsed] => 0.12201690673828 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/session.class.php(99): Clipbucket_db->select() #5 /var/www/upload/includes/classes/user.class.php(5273): Session->get_sessions() #6 /var/www/upload/includes/classes/user.class.php(874): userquery->get_sessions() #7 /var/www/upload/includes/common.php(156): userquery->init() #8 /var/www/upload/includes/config.inc.php(9): require_once() #9 /var/www/upload/watch_video.php(4): require() ) [4] => Array ( [q] => SELECT * FROM v4_sessions WHERE session_string='guest' AND session ='46eia88cbgt25f0dmtr21seovk' [timetook] => 0.00025296211242676 [memBefore] => 0.90382385253906 [memAfter] => 0.92017364501953 [memUsed] => 0.016349792480469 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/session.class.php(88): Clipbucket_db->select() #5 /var/www/upload/includes/classes/session.class.php(44): Session->get_user_session() #6 /var/www/upload/includes/classes/user.class.php(5280): Session->add_session() #7 /var/www/upload/includes/classes/user.class.php(874): userquery->get_sessions() #8 /var/www/upload/includes/common.php(156): userquery->init() #9 /var/www/upload/includes/config.inc.php(9): require_once() #10 /var/www/upload/watch_video.php(4): require() ) [5] => Array ( [q] => SELECT version.id, version.version, version.revision FROM v4_version AS version [timetook] => 0.00014591217041016 [memBefore] => 0.92017364501953 [memAfter] => 0.92137908935547 [memUsed] => 0.0012054443359375 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/update.class.php(60): Clipbucket_db->select() #5 /var/www/upload/includes/classes/update.class.php(785): Update->getDBVersion() #6 /var/www/upload/includes/classes/user_level.class.php(38): Update->IsCurrentDBVersionIsHigherOrEqualTo() #7 /var/www/upload/includes/classes/user.class.php(2267): UserLevel->getPermissions() #8 /var/www/upload/includes/classes/user.class.php(912): userquery->get_user_level() #9 /var/www/upload/includes/common.php(156): userquery->init() #10 /var/www/upload/includes/config.inc.php(9): require_once() #11 /var/www/upload/watch_video.php(4): require() ) [6] => Array ( [q] => SELECT * FROM v4_user_levels,v4_user_levels_permissions WHERE v4_user_levels_permissions.user_level_id='4' AND v4_user_levels_permissions.user_level_id = v4_user_levels.user_level_id [timetook] => 0.00030994415283203 [memBefore] => 0.92137908935547 [memAfter] => 0.92379760742188 [memUsed] => 0.0024185180664062 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/user_level.class.php(44): Clipbucket_db->select() #5 /var/www/upload/includes/classes/user.class.php(2267): UserLevel->getPermissions() #6 /var/www/upload/includes/classes/user.class.php(912): userquery->get_user_level() #7 /var/www/upload/includes/common.php(156): userquery->init() #8 /var/www/upload/includes/config.inc.php(9): require_once() #9 /var/www/upload/watch_video.php(4): require() ) [7] => Array ( [q] => SELECT * FROM v4_languages_translations AS LT INNER JOIN v4_languages_keys AS LK ON LK.id_language_key = LT.id_language_key WHERE LK.language_key = 'collections' AND LT.language_id = '1' [timetook] => 0.00013995170593262 [memBefore] => 0.92379760742188 [memAfter] => 0.93462371826172 [memUsed] => 0.010826110839844 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(95): Clipbucket_db->select() #5 /var/www/upload/includes/functions.php(1210): Language->getTranslationByKey() #6 /var/www/upload/includes/classes/collections.class.php(886): lang() #7 /var/www/upload/includes/classes/collections.class.php(839): Collections->setting_up_collections() #8 /var/www/upload/includes/common.php(219): Collections->__construct() #9 /var/www/upload/includes/config.inc.php(9): require_once() #10 /var/www/upload/watch_video.php(4): require() ) [8] => Array ( [q] => SELECT * FROM v4_languages_translations AS LT INNER JOIN v4_languages_keys AS LK ON LK.id_language_key = LT.id_language_key WHERE LK.language_key = 'manage_favorite_collections' AND LT.language_id = '1' [timetook] => 0.00013208389282227 [memBefore] => 0.93462371826172 [memAfter] => 0.93614959716797 [memUsed] => 0.00152587890625 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(95): Clipbucket_db->select() #5 /var/www/upload/includes/functions.php(1210): Language->getTranslationByKey() #6 /var/www/upload/includes/classes/collections.class.php(886): lang() #7 /var/www/upload/includes/classes/collections.class.php(839): Collections->setting_up_collections() #8 /var/www/upload/includes/common.php(219): Collections->__construct() #9 /var/www/upload/includes/config.inc.php(9): require_once() #10 /var/www/upload/watch_video.php(4): require() ) [9] => Array ( [q] => SELECT * FROM v4_languages_translations AS LT INNER JOIN v4_languages_keys AS LK ON LK.id_language_key = LT.id_language_key WHERE LK.language_key = 'collections' AND LT.language_id = '1' [timetook] => 0.00012993812561035 [memBefore] => 0.93614959716797 [memAfter] => 0.94724273681641 [memUsed] => 0.011093139648438 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(95): Clipbucket_db->select() #5 /var/www/upload/includes/functions.php(1210): Language->getTranslationByKey() #6 /var/www/upload/includes/classes/collections.class.php(886): lang() #7 /var/www/upload/includes/classes/collections.class.php(839): Collections->setting_up_collections() #8 /var/www/upload/includes/classes/video.class.php(1097): Collections->__construct() #9 /var/www/upload/includes/classes/video.class.php(950): CBvideo->init_collections() #10 /var/www/upload/includes/common.php(278): CBvideo->init() #11 /var/www/upload/includes/config.inc.php(9): require_once() #12 /var/www/upload/watch_video.php(4): require() ) [10] => Array ( [q] => SELECT * FROM v4_languages_translations AS LT INNER JOIN v4_languages_keys AS LK ON LK.id_language_key = LT.id_language_key WHERE LK.language_key = 'manage_favorite_collections' AND LT.language_id = '1' [timetook] => 0.00013017654418945 [memBefore] => 0.94724273681641 [memAfter] => 0.94889068603516 [memUsed] => 0.00164794921875 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(95): Clipbucket_db->select() #5 /var/www/upload/includes/functions.php(1210): Language->getTranslationByKey() #6 /var/www/upload/includes/classes/collections.class.php(886): lang() #7 /var/www/upload/includes/classes/collections.class.php(839): Collections->setting_up_collections() #8 /var/www/upload/includes/classes/video.class.php(1097): Collections->__construct() #9 /var/www/upload/includes/classes/video.class.php(950): CBvideo->init_collections() #10 /var/www/upload/includes/common.php(278): CBvideo->init() #11 /var/www/upload/includes/config.inc.php(9): require_once() #12 /var/www/upload/watch_video.php(4): require() ) [11] => Array ( [q] => SELECT * FROM v4_languages_translations AS LT INNER JOIN v4_languages_keys AS LK ON LK.id_language_key = LT.id_language_key WHERE LK.language_key = 'collections' AND LT.language_id = '1' [timetook] => 0.00012803077697754 [memBefore] => 0.94889068603516 [memAfter] => 0.95883941650391 [memUsed] => 0.00994873046875 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(95): Clipbucket_db->select() #5 /var/www/upload/includes/functions.php(1210): Language->getTranslationByKey() #6 /var/www/upload/includes/classes/collections.class.php(886): lang() #7 /var/www/upload/includes/classes/collections.class.php(839): Collections->setting_up_collections() #8 /var/www/upload/includes/classes/photos.class.php(782): Collections->__construct() #9 /var/www/upload/includes/classes/photos.class.php(739): CBPhotos->init_collections() #10 /var/www/upload/includes/common.php(279): CBPhotos->init_photos() #11 /var/www/upload/includes/config.inc.php(9): require_once() #12 /var/www/upload/watch_video.php(4): require() ) [12] => Array ( [q] => SELECT * FROM v4_languages_translations AS LT INNER JOIN v4_languages_keys AS LK ON LK.id_language_key = LT.id_language_key WHERE LK.language_key = 'manage_favorite_collections' AND LT.language_id = '1' [timetook] => 0.00013399124145508 [memBefore] => 0.95883941650391 [memAfter] => 0.96048736572266 [memUsed] => 0.00164794921875 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(95): Clipbucket_db->select() #5 /var/www/upload/includes/functions.php(1210): Language->getTranslationByKey() #6 /var/www/upload/includes/classes/collections.class.php(886): lang() #7 /var/www/upload/includes/classes/collections.class.php(839): Collections->setting_up_collections() #8 /var/www/upload/includes/classes/photos.class.php(782): Collections->__construct() #9 /var/www/upload/includes/classes/photos.class.php(739): CBPhotos->init_collections() #10 /var/www/upload/includes/common.php(279): CBPhotos->init_photos() #11 /var/www/upload/includes/config.inc.php(9): require_once() #12 /var/www/upload/watch_video.php(4): require() ) [13] => Array ( [q] => SELECT tools.id_tool, language_key_label, language_key_description, elements_total, elements_done, COALESCE(NULLIF(language_key_title, ''), 'ready') as language_key_title, function_name, code, CASE WHEN elements_total IS NULL OR elements_total = 0 THEN 0 ELSE elements_done * 100 / elements_total END AS pourcentage_progress, tools_histo.id_histo ,tools.is_automatable, tools.is_disabled, tools.frequency FROM v4_tools AS tools LEFT JOIN ( SELECT id_tool, MAX(date_start) AS max_date FROM v4_tools_histo GROUP BY id_tool ) tools_histo_max_date ON tools.id_tool = tools_histo_max_date.id_tool LEFT JOIN v4_tools_histo AS tools_histo ON tools.id_tool = tools_histo.id_tool AND tools_histo.date_start = tools_histo_max_date.max_date left JOIN v4_tools_histo_status AS tools_histo_status ON tools_histo_status.id_tools_histo_status = tools_histo.id_tools_histo_status WHERE (tools_histo.id_tool IS NOT NULL OR tools_histo_max_date.id_tool IS NULL) AND tools.code = 'automate' ORDER BY tools.id_tool; [timetook] => 0.00015902519226074 [memBefore] => 0.96048736572266 [memAfter] => 0.99829864501953 [memUsed] => 0.037811279296875 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/admin_tool.class.php(106): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/admin_tool.class.php(234): AdminTool->getTools() #5 /var/www/upload/includes/classes/admin_tool.class.php(63): AdminTool->getToolByCode() #6 /var/www/upload/includes/common.php(414): AdminTool->initByCode() #7 /var/www/upload/includes/config.inc.php(9): require_once() #8 /var/www/upload/watch_video.php(4): require() ) [14] => Array ( [q] => SELECT tools_histo.date_start FROM v4_tools_histo AS tools_histo WHERE tools_histo.id_tool = 23 ORDER BY tools_histo.date_start DESC LIMIT 1 [timetook] => 0.00014281272888184 [memBefore] => 0.99829864501953 [memAfter] => 1.0000839233398 [memUsed] => 0.0017852783203125 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/admin_tool.class.php(1016): Clipbucket_db->_select() #4 /var/www/upload/includes/common.php(414): AdminTool->getLastStart() #5 /var/www/upload/includes/config.inc.php(9): require_once() #6 /var/www/upload/watch_video.php(4): require() ) [15] => Array ( [q] => SELECT * FROM v4_plugins WHERE plugin_active='yes' [timetook] => 0.00016307830810547 [memBefore] => 1.0000839233398 [memAfter] => 0.99884033203125 [memUsed] => -0.0012435913085938 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/plugin.class.php(216): Clipbucket_db->select() #5 /var/www/upload/includes/plugins.php(3): CBPlugin->getInstalledPlugins() #6 /var/www/upload/includes/config.inc.php(10): require_once() #7 /var/www/upload/watch_video.php(4): require() ) [16] => Array ( [q] => SELECT * FROM v4_languages WHERE language_default='yes' [timetook] => 0.00013208389282227 [memBefore] => 0.99884033203125 [memAfter] => 1.0067367553711 [memUsed] => 0.0078964233398438 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/lang.class.php(310): Clipbucket_db->select() #5 /var/www/upload/includes/functions.php(1257): Language->getDefaultLanguage() #6 /var/www/upload/player/CB_video_js/cb_video_js.php(24): get_current_language() #7 /var/www/upload/player/CB_video_js/cb_video_js.php(135): CB_video_js->load_dependancies() #8 /var/www/upload/player/CB_video_js/cb_video_js.php(140): CB_video_js->__construct() #9 /var/www/upload/includes/plugins.php(35): include_once() #10 /var/www/upload/includes/config.inc.php(10): require_once() #11 /var/www/upload/watch_video.php(4): require() ) [17] => Array ( [q] => SELECT * FROM v4_tags_type WHERE name IN ('video','actors','producer','executive_producer','director','crew','genre') [timetook] => 0.00013303756713867 [memBefore] => 1.0067367553711 [memAfter] => 1.0267639160156 [memUsed] => 0.020027160644531 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/tags.class.php(329): Clipbucket_db->select() #5 /var/www/upload/includes/classes/tags.class.php(337): Tags->getTagTypes() #6 /var/www/upload/includes/classes/video.class.php(397): Tags->getVideoTypes() #7 /var/www/upload/includes/classes/video.class.php(179): Video->getAll() #8 /var/www/upload/watch_video.php(23): Video->getOne() ) [18] => Array ( [q] => SELECT video.videoid, video.videokey, video.video_password, video.video_users, video.username, video.userid, video.title, video.file_name, video.file_type, video.file_directory, video.description, video.broadcast, video.location, video.datecreated, video.country, video.allow_embedding, video.rating, video.rated_by, video.voter_ids, video.allow_comments, video.comment_voting, video.comments_count, video.last_commented, video.featured, video.featured_date, video.allow_rating, video.active, video.favourite_count, video.playlist_count, video.views, video.last_viewed, video.date_added, video.flagged, video.duration, video.status, video.default_thumb, video.embed_code, video.downloads, video.uploader_ip, video.video_files, video.file_server_path, video.video_version, video.thumbs_version, video.re_conv_status, video.subscription_email, video.is_castable, video.bits_color, video.age_restriction, video.default_poster, video.default_backdrop, users.username AS user_username, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 6 THEN tags.name END) SEPARATOR ',') AS tags_actors, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 10 THEN tags.name END) SEPARATOR ',') AS tags_crew, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 9 THEN tags.name END) SEPARATOR ',') AS tags_director, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 8 THEN tags.name END) SEPARATOR ',') AS tags_executive_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 11 THEN tags.name END) SEPARATOR ',') AS tags_genre, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 7 THEN tags.name END) SEPARATOR ',') AS tags_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 1 THEN tags.name END) SEPARATOR ',') AS tags_video, GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category, GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ', ') AS category_names, user_profile.disabled_channel FROM v4_video AS video LEFT JOIN v4_users AS users ON video.userid = users.userid LEFT JOIN v4_video_tags AS video_tags ON video.videoid = video_tags.id_video LEFT JOIN v4_tags AS tags ON video_tags.id_tag = tags.id_tag LEFT JOIN v4_videos_categories AS videos_categories ON video.videoid = videos_categories.id_video LEFT JOIN v4_categories AS categories ON videos_categories.id_category = categories.category_id LEFT JOIN v4_user_profile AS user_profile ON user_profile.userid = users.userid WHERE video.videoid = '2108' AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) GROUP BY video.videoid,video.videokey,video.video_password,video.video_users,video.username,video.userid,video.title,video.file_name,video.file_type,video.file_directory,video.description,video.broadcast,video.location,video.datecreated,video.country,video.allow_embedding,video.rating,video.rated_by,video.voter_ids,video.allow_comments,video.comment_voting,video.comments_count,video.last_commented,video.featured,video.featured_date,video.allow_rating,video.active,video.favourite_count,video.playlist_count,video.views,video.last_viewed,video.date_added,video.flagged,video.duration,video.status,video.default_thumb,video.embed_code,video.downloads,video.uploader_ip,video.video_files,video.file_server_path,video.video_version,video.thumbs_version,video.re_conv_status,video.subscription_email,video.is_castable,video.bits_color,video.age_restriction,video.default_poster,video.default_backdrop,users.username,video.videoid,video.videoid,user_profile.disabled_channel [timetook] => 0.0012741088867188 [memBefore] => 1.0267639160156 [memAfter] => 1.0360488891602 [memUsed] => 0.0092849731445312 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/video.class.php(478): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/video.class.php(179): Video->getAll() #5 /var/www/upload/watch_video.php(23): Video->getOne() ) [19] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.0052559375762939 [memBefore] => 1.0360488891602 [memAfter] => 1.0370254516602 [memUsed] => 0.0009765625 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [20] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 21 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.0010390281677246 [memBefore] => 1.0370254516602 [memAfter] => 1.0663833618164 [memUsed] => 0.02935791015625 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [21] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 23 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00093889236450195 [memBefore] => 1.0663833618164 [memAfter] => 1.0697555541992 [memUsed] => 0.0033721923828125 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [22] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 24 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00094008445739746 [memBefore] => 1.0697555541992 [memAfter] => 1.0730438232422 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [23] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 35 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00092506408691406 [memBefore] => 1.0730438232422 [memAfter] => 1.0763320922852 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [24] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 36 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00083804130554199 [memBefore] => 1.0763320922852 [memAfter] => 1.0796203613281 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [25] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 37 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00082087516784668 [memBefore] => 1.0796203613281 [memAfter] => 1.0829086303711 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [26] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 46 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00086212158203125 [memBefore] => 1.0829086303711 [memAfter] => 1.0861968994141 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [27] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 48 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00083279609680176 [memBefore] => 1.0861968994141 [memAfter] => 1.089485168457 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [28] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 55 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00081396102905273 [memBefore] => 1.089485168457 [memAfter] => 1.0930786132812 [memUsed] => 0.0035934448242188 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [29] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 58 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00094509124755859 [memBefore] => 1.0930786132812 [memAfter] => 1.0963668823242 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [30] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 59 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00090408325195312 [memBefore] => 1.0963668823242 [memAfter] => 1.0996551513672 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [31] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 60 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00082588195800781 [memBefore] => 1.0996551513672 [memAfter] => 1.1029434204102 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [32] => Array ( [q] => SELECT collections.collection_id , collections.collection_name , collections.collection_description , collections.userid , collections.date_added , collections.featured , collections.broadcast , collections.allow_comments , collections.allow_rating , collections.total_comments , collections.last_commented , collections.rating , collections.rated_by , collections.voters , collections.active , collections.public_upload , collections.type , collections.collection_id_parent , collections.thumb_objectid , users.username AS user_username, users.email, users.dob , COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects , GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags , GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names FROM v4_collections AS collections LEFT JOIN v4_users AS users ON collections.userid = users.userid LEFT JOIN v4_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id LEFT JOIN v4_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = '')))) LEFT JOIN v4_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) LEFT JOIN v4_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN v4_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN v4_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN v4_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.type = 'videos' AND collections.collection_id_parent = 62 AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) > 0 [timetook] => 0.00082612037658691 [memBefore] => 1.1029434204102 [memAfter] => 1.1062316894531 [memUsed] => 0.0032882690429688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/collections.class.php(418): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/collections.class.php(767): Collection->getAll() #5 /var/www/upload/includes/classes/collections.class.php(772): Collection->getAllIndent() #6 /var/www/upload/watch_video.php(54): Collection->getAllIndent() ) [33] => Array ( [q] => SELECT * FROM v4_tags_type WHERE name IN ('video','actors','producer','executive_producer','director','crew','genre') [timetook] => 0.00013613700866699 [memBefore] => 1.1062316894531 [memAfter] => 1.1132659912109 [memUsed] => 0.0070343017578125 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/tags.class.php(329): Clipbucket_db->select() #5 /var/www/upload/includes/classes/tags.class.php(337): Tags->getTagTypes() #6 /var/www/upload/includes/classes/video.class.php(397): Tags->getVideoTypes() #7 /var/www/upload/watch_video.php(61): Video->getAll() ) [34] => Array ( [q] => SELECT video.videoid, video.videokey, video.video_password, video.video_users, video.username, video.userid, video.title, video.file_name, video.file_type, video.file_directory, video.description, video.broadcast, video.location, video.datecreated, video.country, video.allow_embedding, video.rating, video.rated_by, video.voter_ids, video.allow_comments, video.comment_voting, video.comments_count, video.last_commented, video.featured, video.featured_date, video.allow_rating, video.active, video.favourite_count, video.playlist_count, video.views, video.last_viewed, video.date_added, video.flagged, video.duration, video.status, video.default_thumb, video.embed_code, video.downloads, video.uploader_ip, video.video_files, video.file_server_path, video.video_version, video.thumbs_version, video.re_conv_status, video.subscription_email, video.is_castable, video.bits_color, video.age_restriction, video.default_poster, video.default_backdrop, users.username AS user_username, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 6 THEN tags.name END) SEPARATOR ',') AS tags_actors, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 10 THEN tags.name END) SEPARATOR ',') AS tags_crew, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 9 THEN tags.name END) SEPARATOR ',') AS tags_director, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 8 THEN tags.name END) SEPARATOR ',') AS tags_executive_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 11 THEN tags.name END) SEPARATOR ',') AS tags_genre, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 7 THEN tags.name END) SEPARATOR ',') AS tags_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 1 THEN tags.name END) SEPARATOR ',') AS tags_video, GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category, GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ', ') AS category_names, user_profile.disabled_channel FROM v4_video AS video LEFT JOIN v4_users AS users ON video.userid = users.userid LEFT JOIN v4_video_tags AS video_tags ON video.videoid = video_tags.id_video LEFT JOIN v4_tags AS tags ON video_tags.id_tag = tags.id_tag LEFT JOIN v4_videos_categories AS videos_categories ON video.videoid = videos_categories.id_video LEFT JOIN v4_categories AS categories ON videos_categories.id_category = categories.category_id LEFT JOIN v4_user_profile AS user_profile ON user_profile.userid = users.userid WHERE MATCH(video.title) AGAINST ('IMG_0590' IN NATURAL LANGUAGE MODE) OR LOWER(video.title) LIKE '%IMG_0590%' AND ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public'))) GROUP BY video.videoid,video.videokey,video.video_password,video.video_users,video.username,video.userid,video.title,video.file_name,video.file_type,video.file_directory,video.description,video.broadcast,video.location,video.datecreated,video.country,video.allow_embedding,video.rating,video.rated_by,video.voter_ids,video.allow_comments,video.comment_voting,video.comments_count,video.last_commented,video.featured,video.featured_date,video.allow_rating,video.active,video.favourite_count,video.playlist_count,video.views,video.last_viewed,video.date_added,video.flagged,video.duration,video.status,video.default_thumb,video.embed_code,video.downloads,video.uploader_ip,video.video_files,video.file_server_path,video.video_version,video.thumbs_version,video.re_conv_status,video.subscription_email,video.is_castable,video.bits_color,video.age_restriction,video.default_poster,video.default_backdrop,users.username,video.videoid,video.videoid,user_profile.disabled_channel ORDER BY RAND() LIMIT 12 [timetook] => 0.017549991607666 [memBefore] => 1.1132659912109 [memAfter] => 1.1226348876953 [memUsed] => 0.009368896484375 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/video.class.php(478): Clipbucket_db->_select() #4 /var/www/upload/watch_video.php(61): Video->getAll() ) [35] => Array ( [q] => SELECT * FROM v4_tags_type WHERE name IN ('video','actors','producer','executive_producer','director','crew','genre') [timetook] => 0.00035595893859863 [memBefore] => 1.1226348876953 [memAfter] => 1.1184997558594 [memUsed] => -0.0041351318359375 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/tags.class.php(329): Clipbucket_db->select() #5 /var/www/upload/includes/classes/tags.class.php(337): Tags->getTagTypes() #6 /var/www/upload/includes/classes/video.class.php(397): Tags->getVideoTypes() #7 /var/www/upload/watch_video.php(70): Video->getAll() ) [36] => Array ( [q] => SELECT video.videoid, video.videokey, video.video_password, video.video_users, video.username, video.userid, video.title, video.file_name, video.file_type, video.file_directory, video.description, video.broadcast, video.location, video.datecreated, video.country, video.allow_embedding, video.rating, video.rated_by, video.voter_ids, video.allow_comments, video.comment_voting, video.comments_count, video.last_commented, video.featured, video.featured_date, video.allow_rating, video.active, video.favourite_count, video.playlist_count, video.views, video.last_viewed, video.date_added, video.flagged, video.duration, video.status, video.default_thumb, video.embed_code, video.downloads, video.uploader_ip, video.video_files, video.file_server_path, video.video_version, video.thumbs_version, video.re_conv_status, video.subscription_email, video.is_castable, video.bits_color, video.age_restriction, video.default_poster, video.default_backdrop, users.username AS user_username, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 6 THEN tags.name END) SEPARATOR ',') AS tags_actors, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 10 THEN tags.name END) SEPARATOR ',') AS tags_crew, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 9 THEN tags.name END) SEPARATOR ',') AS tags_director, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 8 THEN tags.name END) SEPARATOR ',') AS tags_executive_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 11 THEN tags.name END) SEPARATOR ',') AS tags_genre, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 7 THEN tags.name END) SEPARATOR ',') AS tags_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 1 THEN tags.name END) SEPARATOR ',') AS tags_video, GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category, GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ', ') AS category_names, user_profile.disabled_channel FROM v4_video AS video LEFT JOIN v4_users AS users ON video.userid = users.userid LEFT JOIN v4_video_tags AS video_tags ON video.videoid = video_tags.id_video LEFT JOIN v4_tags AS tags ON video_tags.id_tag = tags.id_tag LEFT JOIN v4_videos_categories AS videos_categories ON video.videoid = videos_categories.id_video LEFT JOIN v4_categories AS categories ON videos_categories.id_category = categories.category_id LEFT JOIN v4_user_profile AS user_profile ON user_profile.userid = users.userid WHERE ( (video.active = 'yes' AND video.status = 'Successful' AND (video.broadcast = 'public'))) GROUP BY video.videoid,video.videokey,video.video_password,video.video_users,video.username,video.userid,video.title,video.file_name,video.file_type,video.file_directory,video.description,video.broadcast,video.location,video.datecreated,video.country,video.allow_embedding,video.rating,video.rated_by,video.voter_ids,video.allow_comments,video.comment_voting,video.comments_count,video.last_commented,video.featured,video.featured_date,video.allow_rating,video.active,video.favourite_count,video.playlist_count,video.views,video.last_viewed,video.date_added,video.flagged,video.duration,video.status,video.default_thumb,video.embed_code,video.downloads,video.uploader_ip,video.video_files,video.file_server_path,video.video_version,video.thumbs_version,video.re_conv_status,video.subscription_email,video.is_castable,video.bits_color,video.age_restriction,video.default_poster,video.default_backdrop,users.username,video.videoid,video.videoid,user_profile.disabled_channel,date_added ORDER BY date_added DESC LIMIT 12 [timetook] => 0.34346389770508 [memBefore] => 1.1184997558594 [memAfter] => 1.1437072753906 [memUsed] => 0.02520751953125 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/video.class.php(478): Clipbucket_db->_select() #4 /var/www/upload/watch_video.php(70): Video->getAll() ) [37] => Array ( [q] => SELECT * FROM v4_tags_type WHERE name IN ('video','actors','producer','executive_producer','director','crew','genre') [timetook] => 0.00014996528625488 [memBefore] => 1.1437072753906 [memAfter] => 1.1638946533203 [memUsed] => 0.020187377929688 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/tags.class.php(329): Clipbucket_db->select() #5 /var/www/upload/includes/classes/tags.class.php(337): Tags->getTagTypes() #6 /var/www/upload/includes/classes/video.class.php(1153): Tags->getVideoTypes() #7 /var/www/upload/includes/functions_video.php(536): CBvideo->get_video() #8 /var/www/upload/includes/functions.php(1644): get_video_details() #9 /var/www/upload/includes/functions_video.php(896): increment_views_new() #10 /var/www/upload/watch_video.php(82): call_watch_video_function() ) [38] => Array ( [q] => SELECT video.videoid, video.videokey, video.video_password, video.video_users, video.username, video.userid, video.title, video.file_name, video.file_type, video.file_directory, video.description, video.broadcast, video.location, video.datecreated, video.country, video.allow_embedding, video.rating, video.rated_by, video.voter_ids, video.allow_comments, video.comment_voting, video.comments_count, video.last_commented, video.featured, video.featured_date, video.allow_rating, video.active, video.favourite_count, video.playlist_count, video.views, video.last_viewed, video.date_added, video.flagged, video.duration, video.status, video.default_thumb, video.embed_code, video.downloads, video.uploader_ip, video.video_files, video.file_server_path, video.video_version, video.thumbs_version, video.re_conv_status, video.subscription_email, video.is_castable, video.bits_color, video.age_restriction, users.userid, users.username, users.email, users.avatar, users.sex, users.avatar_url, users.dob, users.level, users.usr_status, users.user_session_key, users.featured, users.ban_status, users.total_photos, users.profile_hits, users.total_videos, users.subscribers, users.total_subscriptions , GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 6 THEN tags.name ELSE '' END) SEPARATOR ',') AS tags_actors, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 10 THEN tags.name ELSE '' END) SEPARATOR ',') AS tags_crew, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 9 THEN tags.name ELSE '' END) SEPARATOR ',') AS tags_director, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 8 THEN tags.name ELSE '' END) SEPARATOR ',') AS tags_executive_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 11 THEN tags.name ELSE '' END) SEPARATOR ',') AS tags_genre, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 7 THEN tags.name ELSE '' END) SEPARATOR ',') AS tags_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 1 THEN tags.name ELSE '' END) SEPARATOR ',') AS tags_video , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ', ') AS category FROM v4_video AS video LEFT JOIN v4_users AS users ON video.userid = users.userid LEFT JOIN v4_video_tags AS video_tags ON video.videoid = video_tags.id_video LEFT JOIN v4_tags AS tags ON video_tags.id_tag = tags.id_tag LEFT JOIN v4_videos_categories AS videos_categories ON video.videoid = videos_categories.id_video LEFT JOIN v4_categories AS categories ON videos_categories.id_category = categories.category_id WHERE video.videokey = '9RDSN64XWH4R' GROUP BY video.videoid , video.videoid LIMIT 1 [timetook] => 0.010251998901367 [memBefore] => 1.1638946533203 [memAfter] => 1.1877746582031 [memUsed] => 0.023880004882812 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/functions_db.php(106): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/video.class.php(1186): select() #5 /var/www/upload/includes/functions_video.php(536): CBvideo->get_video() #6 /var/www/upload/includes/functions.php(1644): get_video_details() #7 /var/www/upload/includes/functions_video.php(896): increment_views_new() #8 /var/www/upload/watch_video.php(82): call_watch_video_function() ) [39] => Array ( [q] => SELECT userid FROM v4_users WHERE username='anonymous' AND email='anonymous@website' LIMIT 1 [timetook] => 0.00014305114746094 [memBefore] => 1.1579666137695 [memAfter] => 1.1655120849609 [memUsed] => 0.0075454711914062 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(120): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(169): Clipbucket_db->_select() #4 /var/www/upload/includes/classes/user.class.php(4337): Clipbucket_db->select() #5 /var/www/upload/watch_video.php(87): userquery->get_anonymous_user() ) )
Array ( [0] => Array ( [q] => UPDATE v4_sessions SET last_active='2024-12-27 02:12:10',current_page='https://acamedia.ac-nice.fr/img0590_v2108' WHERE session='46eia88cbgt25f0dmtr21seovk' [timetook] => 0.00023293495178223 [memBefore] => 0.91496276855469 [memAfter] => 0.90382385253906 [memUsed] => -0.011138916015625 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(326): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/session.class.php(105): Clipbucket_db->update() #4 /var/www/upload/includes/classes/user.class.php(5273): Session->get_sessions() #5 /var/www/upload/includes/classes/user.class.php(874): userquery->get_sessions() #6 /var/www/upload/includes/common.php(156): userquery->init() #7 /var/www/upload/includes/config.inc.php(9): require_once() #8 /var/www/upload/watch_video.php(4): require() ) [1] => Array ( [q] => UPDATE v4_video SET views=views+1,last_viewed=NOW() WHERE videokey='9RDSN64XWH4R' [timetook] => 0.012465953826904 [memBefore] => 1.1877746582031 [memAfter] => 1.1579666137695 [memUsed] => -0.029808044433594 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(326): Clipbucket_db->execute() #3 /var/www/upload/includes/functions.php(1647): Clipbucket_db->update() #4 /var/www/upload/includes/functions_video.php(896): increment_views_new() #5 /var/www/upload/watch_video.php(82): call_watch_video_function() ) )
Sorry Ninja, nothing to show here
Sorry Ninja, nothing to show here
Array ( [0] => Array ( [q] => SET NAMES "utf8mb4" [timetook] => 0.00016093254089355 [memBefore] => 0 [memAfter] => 0.42087554931641 [memUsed] => 0.42087554931641 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(78): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(25): Clipbucket_db->connect() #4 /var/www/upload/includes/config.php(17): Clipbucket_db->__construct() #5 /var/www/upload/includes/common.php(71): require_once() #6 /var/www/upload/includes/config.inc.php(9): require_once() #7 /var/www/upload/watch_video.php(4): require() ) [1] => Array ( [q] => SET NAMES "utf8mb4" [timetook] => 0.00015687942504883 [memBefore] => 0.42087554931641 [memAfter] => 0.42335510253906 [memUsed] => 0.0024795532226562 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(78): Clipbucket_db->execute() #3 /var/www/upload/includes/config.php(19): Clipbucket_db->connect() #4 /var/www/upload/includes/common.php(71): require_once() #5 /var/www/upload/includes/config.inc.php(9): require_once() #6 /var/www/upload/watch_video.php(4): require() ) [2] => Array ( [q] => SET NAMES "utf8mb4" [timetook] => 0.00016307830810547 [memBefore] => 0.42335510253906 [memAfter] => 0.51633453369141 [memUsed] => 0.092979431152344 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(78): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(25): Clipbucket_db->connect() #4 /var/www/upload/includes/classes/db.class.php(18): Clipbucket_db->__construct() #5 /var/www/upload/includes/functions_db.php(10): Clipbucket_db->getInstance() #6 /var/www/upload/includes/classes/my_queries.class.php(32): db_select() #7 /var/www/upload/includes/common.php(98): myquery->Get_Website_Details() #8 /var/www/upload/includes/config.inc.php(9): require_once() #9 /var/www/upload/watch_video.php(4): require() ) )
Array ( [q] => SET NAMES "utf8mb4" [timetook] => 0.00016093254089355 [memBefore] => 0 [memAfter] => 0.42087554931641 [memUsed] => 0.42087554931641 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(78): Clipbucket_db->execute() #3 /var/www/upload/includes/classes/db.class.php(25): Clipbucket_db->connect() #4 /var/www/upload/includes/config.php(17): Clipbucket_db->__construct() #5 /var/www/upload/includes/common.php(71): require_once() #6 /var/www/upload/includes/config.inc.php(9): require_once() #7 /var/www/upload/watch_video.php(4): require() )
Array ( [q] => UPDATE v4_video SET views=views+1,last_viewed=NOW() WHERE videokey='9RDSN64XWH4R' [timetook] => 0.012465953826904 [memBefore] => 1.1877746582031 [memAfter] => 1.1579666137695 [memUsed] => -0.029808044433594 [use_cache] => no [backtrace] => #1 /var/www/upload/includes/classes/db.class.php(236): devWitch() #2 /var/www/upload/includes/classes/db.class.php(326): Clipbucket_db->execute() #3 /var/www/upload/includes/functions.php(1647): Clipbucket_db->update() #4 /var/www/upload/includes/functions_video.php(896): increment_views_new() #5 /var/www/upload/watch_video.php(82): call_watch_video_function() )