Aucun résultat disponible
Chargement
Array
(
[0] => Array
(
[q] => SELECT * FROM video_config
[timetook] => 0.00034499168395996
[memBefore] => 0.48808288574219
[memAfter] => 0.51448059082031
[memUsed] => 0.026397705078125
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/functions_db.php(10): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/my_queries.class.php(41): db_select()
#5 /var/www/upload/v2/includes/common.php(96): myquery->Get_Website_Details()
#6 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#7 /var/www/upload/v2/collections.php(5): require()
)
[1] => Array
(
[q] => SELECT * FROM video_sessions WHERE session ='c628f5158c2b93091f6e95a33082bf01'
[timetook] => 0.00014495849609375
[memBefore] => 0.51448059082031
[memAfter] => 0.70924377441406
[memUsed] => 0.19476318359375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/session.class.php(110): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/classes/user.class.php(5542): Session->get_sessions()
#6 /var/www/upload/v2/includes/classes/user.class.php(1331): userquery->get_sessions()
#7 /var/www/upload/v2/includes/classes/user.class.php(1275): userquery->init()
#8 /var/www/upload/v2/includes/functions.php(489): userquery->getInstance()
#9 /var/www/upload/v2/includes/classes/user.class.php(225): user_id()
#10 /var/www/upload/v2/includes/common.php(151): User->getInstance()
#11 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#12 /var/www/upload/v2/collections.php(5): require()
)
[2] => Array
(
[q] => SELECT * FROM video_sessions WHERE session_string='guest' AND session ='c628f5158c2b93091f6e95a33082bf01'
[timetook] => 0.00011205673217773
[memBefore] => 0.69881439208984
[memAfter] => 0.71537780761719
[memUsed] => 0.016563415527344
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/session.class.php(92): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/classes/session.class.php(48): Session->get_user_session()
#6 /var/www/upload/v2/includes/classes/user.class.php(5549): Session->add_session()
#7 /var/www/upload/v2/includes/classes/user.class.php(1331): userquery->get_sessions()
#8 /var/www/upload/v2/includes/classes/user.class.php(1275): userquery->init()
#9 /var/www/upload/v2/includes/functions.php(489): userquery->getInstance()
#10 /var/www/upload/v2/includes/classes/user.class.php(225): user_id()
#11 /var/www/upload/v2/includes/common.php(151): User->getInstance()
#12 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#13 /var/www/upload/v2/collections.php(5): require()
)
[3] => Array
(
[q] => SELECT version.id, version.version, version.revision FROM video_version AS version
[timetook] => 8.2015991210938E-5
[memBefore] => 0.71537780761719
[memAfter] => 0.718994140625
[memUsed] => 0.0036163330078125
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/update.class.php(60): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/classes/update.class.php(789): Update->getDBVersion()
#6 /var/www/upload/v2/includes/classes/user.class.php(83): Update->IsCurrentDBVersionIsHigherOrEqualTo()
#7 /var/www/upload/v2/includes/classes/user.class.php(228): User->__construct()
#8 /var/www/upload/v2/includes/common.php(151): User->getInstance()
#9 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#10 /var/www/upload/v2/collections.php(5): require()
)
[4] => Array
(
[q] => SELECT user_levels_permissions.id_user_levels_permission, user_levels_permissions.id_user_permission_types, user_levels_permissions.permission_name, user_levels_permissions.permission_description, user_levels_permissions_values.user_level_id, user_levels_permissions_values.id_user_levels_permission, user_levels_permissions_values.permission_value
FROM video_user_levels_permissions AS user_levels_permissions INNER JOIN video_user_levels_permissions_values AS user_levels_permissions_values ON user_levels_permissions.id_user_levels_permission = user_levels_permissions_values.id_user_levels_permission WHERE user_levels_permissions_values.user_level_id = 4
[timetook] => 0.00020003318786621
[memBefore] => 0.718994140625
[memAfter] => 0.72609710693359
[memUsed] => 0.0071029663085938
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/user_level.class.php(140): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/user_level.class.php(41): UserLevel->getAllPermissions()
#5 /var/www/upload/v2/includes/classes/user_level.class.php(72): UserLevel->getPermissions()
#6 /var/www/upload/v2/includes/classes/user_level.class.php(86): UserLevel->getPermission()
#7 /var/www/upload/v2/includes/classes/user.class.php(608): UserLevel->hasPermission()
#8 /var/www/upload/v2/includes/classes/user.class.php(642): User->hasPermission()
#9 /var/www/upload/v2/includes/common.php(151): User->hasAdminAccess()
#10 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#11 /var/www/upload/v2/collections.php(5): require()
)
[5] => Array
(
[q] => SELECT * FROM video_languages WHERE language_default='yes'
[timetook] => 0.00010895729064941
[memBefore] => 0.72609710693359
[memAfter] => 0.74949645996094
[memUsed] => 0.023399353027344
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(318): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/classes/lang.class.php(75): Language->getDefaultLanguage()
#6 /var/www/upload/v2/includes/classes/lang.class.php(14): Language->init()
#7 /var/www/upload/v2/includes/functions.php(1082): Language->getInstance()
#8 /var/www/upload/v2/includes/classes/collections.class.php(1062): lang()
#9 /var/www/upload/v2/includes/classes/photos.class.php(853): Collections->__construct()
#10 /var/www/upload/v2/includes/classes/photos.class.php(809): CBPhotos->init_collections()
#11 /var/www/upload/v2/includes/common.php(238): CBPhotos->init_photos()
#12 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#13 /var/www/upload/v2/collections.php(5): require()
)
[6] => Array
(
[q] => SELECT language_key, translation FROM video_languages_keys AS LK
LEFT JOIN video_languages_translations AS LT ON LK.id_language_key = LT.id_language_key AND LT.language_id = 2 ORDER BY CASE WHEN LT.translation IS NULL THEN concat('aaaaaaaaaaaaaaaaaaaa',language_key) ELSE LK.language_key END
[timetook] => 0.0095188617706299
[memBefore] => 0.74949645996094
[memAfter] => 0.85762786865234
[memUsed] => 0.10813140869141
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(156): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/classes/lang.class.php(217): Language->getAllTranslations()
#6 /var/www/upload/v2/includes/classes/lang.class.php(84): Language->loadTranslations()
#7 /var/www/upload/v2/includes/classes/lang.class.php(14): Language->init()
#8 /var/www/upload/v2/includes/functions.php(1082): Language->getInstance()
#9 /var/www/upload/v2/includes/classes/collections.class.php(1062): lang()
#10 /var/www/upload/v2/includes/classes/photos.class.php(853): Collections->__construct()
#11 /var/www/upload/v2/includes/classes/photos.class.php(809): CBPhotos->init_collections()
#12 /var/www/upload/v2/includes/common.php(238): CBPhotos->init_photos()
#13 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#14 /var/www/upload/v2/collections.php(5): require()
)
[7] => Array
(
[q] => SELECT * FROM video_languages_translations AS LT
INNER JOIN video_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.00020289421081543
[memBefore] => 0.85762786865234
[memAfter] => 0.98944091796875
[memUsed] => 0.13181304931641
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(104): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/functions.php(1084): Language->getTranslationByKey()
#6 /var/www/upload/v2/includes/classes/collections.class.php(1116): lang()
#7 /var/www/upload/v2/includes/classes/collections.class.php(1070): Collections->setting_up_collections()
#8 /var/www/upload/v2/includes/classes/photos.class.php(853): Collections->__construct()
#9 /var/www/upload/v2/includes/classes/photos.class.php(809): CBPhotos->init_collections()
#10 /var/www/upload/v2/includes/common.php(238): CBPhotos->init_photos()
#11 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#12 /var/www/upload/v2/collections.php(5): require()
)
[8] => Array
(
[q] => SELECT * FROM video_languages_translations AS LT
INNER JOIN video_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.00013613700866699
[memBefore] => 0.98944091796875
[memAfter] => 0.9910888671875
[memUsed] => 0.00164794921875
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(104): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/functions.php(1084): Language->getTranslationByKey()
#6 /var/www/upload/v2/includes/classes/collections.class.php(1116): lang()
#7 /var/www/upload/v2/includes/classes/collections.class.php(1070): Collections->setting_up_collections()
#8 /var/www/upload/v2/includes/classes/photos.class.php(853): Collections->__construct()
#9 /var/www/upload/v2/includes/classes/photos.class.php(809): CBPhotos->init_collections()
#10 /var/www/upload/v2/includes/common.php(238): CBPhotos->init_photos()
#11 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#12 /var/www/upload/v2/collections.php(5): require()
)
[9] => Array
(
[q] => SELECT * FROM video_languages_translations AS LT
INNER JOIN video_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.00010991096496582
[memBefore] => 0.9910888671875
[memAfter] => 1.0210418701172
[memUsed] => 0.029953002929688
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(104): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/functions.php(1084): Language->getTranslationByKey()
#6 /var/www/upload/v2/includes/classes/collections.class.php(1116): lang()
#7 /var/www/upload/v2/includes/classes/collections.class.php(1070): Collections->setting_up_collections()
#8 /var/www/upload/v2/includes/classes/video.class.php(1499): Collections->__construct()
#9 /var/www/upload/v2/includes/classes/video.class.php(1307): CBvideo->init_collections()
#10 /var/www/upload/v2/includes/classes/video.class.php(1293): CBvideo->__construct()
#11 /var/www/upload/v2/includes/plugin.functions.php(319): CBvideo->getInstance()
#12 /var/www/upload/v2/includes/common.php(316): register_action_remove_video()
#13 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#14 /var/www/upload/v2/collections.php(5): require()
)
[10] => Array
(
[q] => SELECT * FROM video_languages_translations AS LT
INNER JOIN video_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.00010490417480469
[memBefore] => 1.0210418701172
[memAfter] => 1.0229339599609
[memUsed] => 0.00189208984375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(104): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/functions.php(1084): Language->getTranslationByKey()
#6 /var/www/upload/v2/includes/classes/collections.class.php(1116): lang()
#7 /var/www/upload/v2/includes/classes/collections.class.php(1070): Collections->setting_up_collections()
#8 /var/www/upload/v2/includes/classes/video.class.php(1499): Collections->__construct()
#9 /var/www/upload/v2/includes/classes/video.class.php(1307): CBvideo->init_collections()
#10 /var/www/upload/v2/includes/classes/video.class.php(1293): CBvideo->__construct()
#11 /var/www/upload/v2/includes/plugin.functions.php(319): CBvideo->getInstance()
#12 /var/www/upload/v2/includes/common.php(316): register_action_remove_video()
#13 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#14 /var/www/upload/v2/collections.php(5): require()
)
[11] => Array
(
[q] => SELECT * FROM video_plugins WHERE plugin_active='yes'
[timetook] => 9.7990036010742E-5
[memBefore] => 1.0229339599609
[memAfter] => 1.0292663574219
[memUsed] => 0.0063323974609375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/plugin.class.php(216): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/plugins.php(3): CBPlugin->getInstalledPlugins()
#6 /var/www/upload/v2/includes/config.inc.php(21): require_once()
#7 /var/www/upload/v2/collections.php(5): require()
)
[12] => Array
(
[q] => SELECT * FROM video_languages WHERE language_default='yes'
[timetook] => 0.00011610984802246
[memBefore] => 1.0292663574219
[memAfter] => 1.0311584472656
[memUsed] => 0.00189208984375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(318): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/functions.php(1135): Language->getDefaultLanguage()
#6 /var/www/upload/v2/player/CB_video_js/cb_video_js.php(24): get_current_language()
#7 /var/www/upload/v2/player/CB_video_js/cb_video_js.php(130): CB_video_js->load_dependancies()
#8 /var/www/upload/v2/player/CB_video_js/cb_video_js.php(135): CB_video_js->__construct()
#9 /var/www/upload/v2/includes/plugins.php(35): include_once()
#10 /var/www/upload/v2/includes/config.inc.php(21): require_once()
#11 /var/www/upload/v2/collections.php(5): require()
)
[13] => Array
(
[q] => SELECT id, label, type, is_default FROM video_sorts WHERE id = 0
[timetook] => 0.00010204315185547
[memBefore] => 1.0311584472656
[memAfter] => 1.0412216186523
[memUsed] => 0.010063171386719
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/sort_type.class.php(30): Clipbucket_db->_select()
#4 /var/www/upload/v2/collections.php(22): SortType->getSortLabelById()
)
[14] => Array
(
[q] => SELECT * FROM video_languages_translations AS LT
INNER JOIN video_languages_keys AS LK ON LK.id_language_key = LT.id_language_key WHERE LK.language_key = 'collect_borad_pub' AND LT.language_id = '1'
[timetook] => 0.00011491775512695
[memBefore] => 1.0412216186523
[memAfter] => 1.0435409545898
[memUsed] => 0.0023193359375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(104): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/functions.php(1084): Language->getTranslationByKey()
#6 /var/www/upload/v2/includes/classes/collections.class.php(79): lang()
#7 /var/www/upload/v2/includes/classes/collections.class.php(101): Collection->__construct()
#8 /var/www/upload/v2/collections.php(23): Collection->getInstance()
)
[15] => Array
(
[q] => SELECT * FROM video_languages_translations AS LT
INNER JOIN video_languages_keys AS LK ON LK.id_language_key = LT.id_language_key WHERE LK.language_key = 'collect_broad_pri' AND LT.language_id = '1'
[timetook] => 0.00010299682617188
[memBefore] => 1.0435409545898
[memAfter] => 1.045280456543
[memUsed] => 0.001739501953125
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(104): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/functions.php(1084): Language->getTranslationByKey()
#6 /var/www/upload/v2/includes/classes/collections.class.php(80): lang()
#7 /var/www/upload/v2/includes/classes/collections.class.php(101): Collection->__construct()
#8 /var/www/upload/v2/collections.php(23): Collection->getInstance()
)
[16] => 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
, collections.sort_type
, users.username AS user_username, users.email, users.dob
, collection_parent.collection_name AS collection_name_parent
, COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) + COUNT(DISTINCT(collections_enfant.collection_id)) AS total_objects
, sorts.label as sort_type_label
, sorts.id as sort_type
, COUNT(DISTINCT(collections_enfant.collection_id)) as nb_childs
, 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 video_collections AS collections
LEFT JOIN video_users AS users ON collections.userid = users.userid
LEFT JOIN video_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
LEFT JOIN video_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 video_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 video_collections collection_parent ON collections.collection_id_parent = collection_parent.collection_id
LEFT JOIN video_sorts AS sorts ON sorts.id = collections.sort_type
LEFT JOIN video_collections AS collections_enfant ON collections.collection_id = collections_enfant.collection_id_parent
LEFT JOIN video_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection
LEFT JOIN video_tags AS tags ON collection_tags.id_tag = tags.id_tag
LEFT JOIN video_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection
LEFT JOIN video_categories AS categories ON collections_categories.id_category = categories.category_id WHERE ( CONCAT(YEAR(CURDATE()),DAYOFYEAR(CURDATE())-1) = CONCAT(YEAR(collections.date_added),DAYOFYEAR(collections.date_added)) )
AND collections.collection_id_parent IS NULL
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)) + COUNT(DISTINCT(collections_enfant.collection_id)) > 0 ORDER BY collections.date_added DESC LIMIT 0,12
[timetook] => 0.0015549659729004
[memBefore] => 1.045280456543
[memAfter] => 1.0563583374023
[memUsed] => 0.011077880859375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/collections.class.php(507): Clipbucket_db->_select()
#4 /var/www/upload/v2/collections.php(32): Collection->getAll()
)
[17] => 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
, collections.sort_type
, users.username AS user_username, users.email, users.dob
, collection_parent.collection_name AS collection_name_parent
, COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) + COUNT(DISTINCT(collections_enfant.collection_id)) AS total_objects
, sorts.label as sort_type_label
, sorts.id as sort_type
, COUNT(DISTINCT(collections_enfant.collection_id)) as nb_childs
, 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 video_collections AS collections
LEFT JOIN video_users AS users ON collections.userid = users.userid
LEFT JOIN video_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
LEFT JOIN video_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 video_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 video_collections collection_parent ON collections.collection_id_parent = collection_parent.collection_id
LEFT JOIN video_sorts AS sorts ON sorts.id = collections.sort_type
LEFT JOIN video_collections AS collections_enfant ON collections.collection_id = collections_enfant.collection_id_parent
LEFT JOIN video_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection
LEFT JOIN video_tags AS tags ON collection_tags.id_tag = tags.id_tag
LEFT JOIN video_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection
LEFT JOIN video_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.collection_id_parent IS NULL
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)) + COUNT(DISTINCT(collections_enfant.collection_id)) > 0 ORDER BY COUNT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END) DESC LIMIT 4
[timetook] => 0.0013270378112793
[memBefore] => 1.0563583374023
[memAfter] => 1.0610885620117
[memUsed] => 0.004730224609375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/collections.class.php(507): Clipbucket_db->_select()
#4 /var/www/upload/v2/collections.php(43): Collection->getAll()
)
[18] => Array
(
[q] => SELECT id, label, type, is_default FROM video_sorts WHERE id = 10
[timetook] => 0.00010299682617188
[memBefore] => 1.0610885620117
[memAfter] => 1.064338684082
[memUsed] => 0.0032501220703125
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/sort_type.class.php(30): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/collections.class.php(552): SortType->getSortLabelById()
#5 /var/www/upload/v2/collections.php(43): Collection->getAll()
)
[19] => Array
(
[q] => SELECT COUNT(DISTINCT photos.photo_id) AS count
FROM video_photos AS photos
LEFT JOIN video_users AS users ON photos.userid = users.userid LEFT JOIN video_photo_tags AS photo_tags ON photos.photo_id = photo_tags.id_photo LEFT JOIN video_tags AS tags ON photo_tags.id_tag = tags.id_tag LEFT JOIN video_photos_categories AS photos_categories ON photos.photo_id = photos_categories.id_photo LEFT JOIN video_categories AS categories ON photos_categories.id_category = categories.category_id INNER JOIN video_collection_items AS collection_items ON collection_items.collection_id = 1 AND photos.photo_id = collection_items.object_id LEFT JOIN video_collections AS collections ON collection_items.collection_id = collections.collection_id LEFT JOIN video_user_profile AS user_profile ON user_profile.userid = users.userid WHERE (((photos.active = 'yes' AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL ) AND (((collections.active = 'yes' AND collections.broadcast = 'public')) OR collections.collection_id IS NULL )
[timetook] => 0.00031399726867676
[memBefore] => 1.064338684082
[memAfter] => 1.0680923461914
[memUsed] => 0.003753662109375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/photos.class.php(417): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/collections.class.php(566): Photo->getAll()
#5 /var/www/upload/v2/collections.php(43): Collection->getAll()
)
[20] => Array
(
[q] => SELECT id, label, type, is_default FROM video_sorts WHERE type = 'collections'
[timetook] => 0.00015091896057129
[memBefore] => 1.0680923461914
[memAfter] => 1.0622940063477
[memUsed] => -0.00579833984375
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/sort_type.class.php(16): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/collections.class.php(204): SortType->getSortTypes()
#5 /var/www/upload/v2/collections.php(46): Collection->getSortList()
)
[21] => Array
(
[q] => SELECT id, label, type, is_default FROM video_sorts WHERE is_default = TRUE AND type = 'collections'
[timetook] => 0.00012898445129395
[memBefore] => 1.0622940063477
[memAfter] => 1.0637741088867
[memUsed] => 0.0014801025390625
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/sort_type.class.php(42): Clipbucket_db->_select()
#4 /var/www/upload/v2/collections.php(47): SortType->getDefaultByType()
)
[22] => Array
(
[q] => SELECT * FROM video_languages_translations AS LT
INNER JOIN video_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.00012493133544922
[memBefore] => 1.0637741088867
[memAfter] => 1.0664367675781
[memUsed] => 0.0026626586914062
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/upload/v2/includes/classes/lang.class.php(104): Clipbucket_db->select()
#5 /var/www/upload/v2/includes/functions.php(1084): Language->getTranslationByKey()
#6 /var/www/upload/v2/collections.php(71): lang()
)
)
Array
(
[0] => Array
(
[q] => UPDATE video_sessions SET last_active='2026-02-11 10:23:11',current_page='https://acamedia.ac-nice.fr/collections/all/most_recent/yesterday/1' WHERE session='c628f5158c2b93091f6e95a33082bf01'
[timetook] => 9.9897384643555E-5
[memBefore] => 0.70924377441406
[memAfter] => 0.69881439208984
[memUsed] => -0.010429382324219
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(338): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/session.class.php(116): Clipbucket_db->update()
#4 /var/www/upload/v2/includes/classes/user.class.php(5542): Session->get_sessions()
#5 /var/www/upload/v2/includes/classes/user.class.php(1331): userquery->get_sessions()
#6 /var/www/upload/v2/includes/classes/user.class.php(1275): userquery->init()
#7 /var/www/upload/v2/includes/functions.php(489): userquery->getInstance()
#8 /var/www/upload/v2/includes/classes/user.class.php(225): user_id()
#9 /var/www/upload/v2/includes/common.php(151): User->getInstance()
#10 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#11 /var/www/upload/v2/collections.php(5): require()
)
)
Sorry Ninja, nothing to show here
Sorry Ninja, nothing to show here
Array
(
[0] => Array
(
[q] => SET NAMES "utf8mb4"
[timetook] => 5.8889389038086E-5
[memBefore] => 0
[memAfter] => 0.48808288574219
[memUsed] => 0.48808288574219
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(82): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(29): Clipbucket_db->connect()
#4 /var/www/upload/v2/includes/classes/db.class.php(19): Clipbucket_db->__construct()
#5 /var/www/upload/v2/includes/functions_db.php(10): Clipbucket_db->getInstance()
#6 /var/www/upload/v2/includes/classes/my_queries.class.php(41): db_select()
#7 /var/www/upload/v2/includes/common.php(96): myquery->Get_Website_Details()
#8 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#9 /var/www/upload/v2/collections.php(5): require()
)
)
Array
(
[q] => SET NAMES "utf8mb4"
[timetook] => 5.8889389038086E-5
[memBefore] => 0
[memAfter] => 0.48808288574219
[memUsed] => 0.48808288574219
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(82): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/db.class.php(29): Clipbucket_db->connect()
#4 /var/www/upload/v2/includes/classes/db.class.php(19): Clipbucket_db->__construct()
#5 /var/www/upload/v2/includes/functions_db.php(10): Clipbucket_db->getInstance()
#6 /var/www/upload/v2/includes/classes/my_queries.class.php(41): db_select()
#7 /var/www/upload/v2/includes/common.php(96): myquery->Get_Website_Details()
#8 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#9 /var/www/upload/v2/collections.php(5): require()
)
Array
(
[q] => UPDATE video_sessions SET last_active='2026-02-11 10:23:11',current_page='https://acamedia.ac-nice.fr/collections/all/most_recent/yesterday/1' WHERE session='c628f5158c2b93091f6e95a33082bf01'
[timetook] => 9.9897384643555E-5
[memBefore] => 0.70924377441406
[memAfter] => 0.69881439208984
[memUsed] => -0.010429382324219
[use_cache] => no
[backtrace] => #1 /var/www/upload/v2/includes/classes/db.class.php(246): devWitch()
#2 /var/www/upload/v2/includes/classes/db.class.php(338): Clipbucket_db->execute()
#3 /var/www/upload/v2/includes/classes/session.class.php(116): Clipbucket_db->update()
#4 /var/www/upload/v2/includes/classes/user.class.php(5542): Session->get_sessions()
#5 /var/www/upload/v2/includes/classes/user.class.php(1331): userquery->get_sessions()
#6 /var/www/upload/v2/includes/classes/user.class.php(1275): userquery->init()
#7 /var/www/upload/v2/includes/functions.php(489): userquery->getInstance()
#8 /var/www/upload/v2/includes/classes/user.class.php(225): user_id()
#9 /var/www/upload/v2/includes/common.php(151): User->getInstance()
#10 /var/www/upload/v2/includes/config.inc.php(9): require_once()
#11 /var/www/upload/v2/collections.php(5): require()
)