Select Queries (15)
Array
(
[0] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_config
[timetook] => 0.0021669864654541
[memBefore] => 0.45773315429688
[memAfter] => 0.48040008544922
[memUsed] => 0.022666931152344
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/functions_db.php(11): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/my_queries.class.php(33): db_select()
#5 /home/videos.goe.ac/includes/common.php(79): myquery->Get_Website_Details()
#6 /home/videos.goe.ac/includes/config.inc.php(9): require_once()
#7 /home/videos.goe.ac/view_collection.php(5): require()
)
[1] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_languages WHERE language_default='yes'
[timetook] => 0.00111985206604
[memBefore] => 0.48040008544922
[memAfter] => 0.61250305175781
[memUsed] => 0.13210296630859
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/db.class.php(155): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/lang.class.php(308): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/classes/lang.class.php(61): Language->getDefaultLanguage()
#6 /home/videos.goe.ac/includes/common.php(119): Language->init()
#7 /home/videos.goe.ac/includes/config.inc.php(9): require_once()
#8 /home/videos.goe.ac/view_collection.php(5): require()
)
[2] => Array
(
[q] => SELECT language_key, translation FROM `clipbucket`.cb_languages_keys AS LK
LEFT JOIN `clipbucket`.cb_languages_translations AS LT ON LK.id_language_key = LT.id_language_key AND LT.language_id = 1 ORDER BY CASE WHEN LT.translation IS NULL THEN concat('aaaaaaaaaaaaaaaaaaaa',language_key) ELSE LK.language_key END
[timetook] => 0.023669958114624
[memBefore] => 0.61250305175781
[memAfter] => 0.68048095703125
[memUsed] => 0.067977905273438
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/db.class.php(155): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/lang.class.php(143): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/classes/lang.class.php(206): Language->getAllTranslations()
#6 /home/videos.goe.ac/includes/common.php(120): Language->loadTranslations()
#7 /home/videos.goe.ac/includes/config.inc.php(9): require_once()
#8 /home/videos.goe.ac/view_collection.php(5): require()
)
[3] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_sessions WHERE session ='dtdorut9hmqdfmo9u12m1p82ni'
[timetook] => 0.00063300132751465
[memBefore] => 0.68048095703125
[memAfter] => 0.79537200927734
[memUsed] => 0.11489105224609
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/db.class.php(155): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/session.class.php(100): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/classes/user.class.php(5237): Session->get_sessions()
#6 /home/videos.goe.ac/includes/classes/user.class.php(318): userquery->get_sessions()
#7 /home/videos.goe.ac/includes/common.php(148): userquery->init()
#8 /home/videos.goe.ac/includes/config.inc.php(9): require_once()
#9 /home/videos.goe.ac/view_collection.php(5): require()
)
[4] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_sessions WHERE session_string='guest' AND session ='dtdorut9hmqdfmo9u12m1p82ni'
[timetook] => 0.0002748966217041
[memBefore] => 0.78256225585938
[memAfter] => 0.79894256591797
[memUsed] => 0.016380310058594
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/db.class.php(155): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/session.class.php(88): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/classes/session.class.php(41): Session->get_user_session()
#6 /home/videos.goe.ac/includes/classes/user.class.php(5244): Session->add_session()
#7 /home/videos.goe.ac/includes/classes/user.class.php(318): userquery->get_sessions()
#8 /home/videos.goe.ac/includes/common.php(148): userquery->init()
#9 /home/videos.goe.ac/includes/config.inc.php(9): require_once()
#10 /home/videos.goe.ac/view_collection.php(5): require()
)
[5] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_user_levels,`clipbucket`.cb_user_levels_permissions WHERE `clipbucket`.cb_user_levels_permissions.user_level_id='4'
AND `clipbucket`.cb_user_levels_permissions.user_level_id = `clipbucket`.cb_user_levels.user_level_id
[timetook] => 0.00070905685424805
[memBefore] => 0.79894256591797
[memAfter] => 0.80120086669922
[memUsed] => 0.00225830078125
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/db.class.php(155): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/user.class.php(1853): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/classes/user.class.php(355): userquery->get_user_level()
#6 /home/videos.goe.ac/includes/common.php(148): userquery->init()
#7 /home/videos.goe.ac/includes/config.inc.php(9): require_once()
#8 /home/videos.goe.ac/view_collection.php(5): require()
)
[6] => Array
(
[q] => SELECT plugins.plugin_id, plugins.plugin_file, plugins.plugin_folder, plugins.plugin_version, plugins.plugin_active
FROM `clipbucket`.cb_plugins AS plugins
[timetook] => 0.00068092346191406
[memBefore] => 0.80120086669922
[memAfter] => 0.80712127685547
[memUsed] => 0.00592041015625
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/plugin.class.php(100): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/update.class.php(420): Plugin->getAll()
#5 /home/videos.goe.ac/includes/common.php(156): Update->isVersionSystemInstalled()
#6 /home/videos.goe.ac/includes/config.inc.php(9): require_once()
#7 /home/videos.goe.ac/view_collection.php(5): require()
)
[7] => Array
(
[q] => SELECT version.id, version.version, version.revision FROM `clipbucket`.cb_version AS version
[timetook] => 0.00026297569274902
[memBefore] => 0.80712127685547
[memAfter] => 0.82054138183594
[memUsed] => 0.013420104980469
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/db.class.php(155): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/update.class.php(55): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/classes/photos.class.php(412): Update->getDBVersion()
#6 /home/videos.goe.ac/includes/classes/photos.class.php(360): CBPhotos->basic_fields_setup()
#7 /home/videos.goe.ac/includes/common.php(209): CBPhotos->__construct()
#8 /home/videos.goe.ac/includes/config.inc.php(9): require_once()
#9 /home/videos.goe.ac/view_collection.php(5): require()
)
[8] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_plugins WHERE plugin_active='yes'
[timetook] => 0.00026798248291016
[memBefore] => 0.82054138183594
[memAfter] => 0.87254333496094
[memUsed] => 0.052001953125
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/db.class.php(155): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/plugin.class.php(218): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/plugins.php(5): CBPlugin->getInstalledPlugins()
#6 /home/videos.goe.ac/includes/config.inc.php(10): require_once()
#7 /home/videos.goe.ac/view_collection.php(5): require()
)
[9] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_languages WHERE language_default='yes'
[timetook] => 0.00025200843811035
[memBefore] => 0.87254333496094
[memAfter] => 0.87474822998047
[memUsed] => 0.0022048950195312
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/db.class.php(155): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/lang.class.php(308): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/functions.php(1428): Language->getDefaultLanguage()
#6 /home/videos.goe.ac/player/CB_video_js/cb_video_js.php(28): get_current_language()
#7 /home/videos.goe.ac/player/CB_video_js/cb_video_js.php(138): CB_video_js->load_dependancies()
#8 /home/videos.goe.ac/player/CB_video_js/cb_video_js.php(143): CB_video_js->__construct()
#9 /home/videos.goe.ac/includes/plugins.php(39): include_once()
#10 /home/videos.goe.ac/includes/config.inc.php(10): require_once()
#11 /home/videos.goe.ac/view_collection.php(5): require()
)
[10] => Array
(
[q] => SELECT collections.collection_id, collections.collection_id_parent, collections.collection_name, collections.collection_description, collections.category, collections.userid, collections.views, 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, users.username AS user_username, COUNT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END) AS total_objects, GROUP_CONCAT(tags.name SEPARATOR ',') AS tags
FROM `clipbucket`.cb_collections AS collections
LEFT JOIN `clipbucket`.cb_users AS users ON collections.userid = users.userid
LEFT JOIN `clipbucket`.cb_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
LEFT JOIN `clipbucket`.cb_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND video.age_restriction IS NULL AND (video.broadcast = 'public')))
LEFT JOIN `clipbucket`.cb_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND ((photos.active = 'yes' AND photos.age_restriction IS NULL AND photos.broadcast = 'public')) LEFT JOIN `clipbucket`.cb_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN `clipbucket`.cb_tags AS tags ON collection_tags.id_tag = tags.id_tag WHERE collections.collection_id = '1' AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT collection_items.ci_id > 0 )
[timetook] => 0.0021810531616211
[memBefore] => 0.87474822998047
[memAfter] => 0.89167785644531
[memUsed] => 0.016929626464844
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/collections.class.php(221): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/collections.class.php(624): Collection->getAll()
#5 /home/videos.goe.ac/view_collection.php(18): Collections->is_viewable()
)
[11] => Array
(
[q] => SELECT collections.collection_id, collections.collection_id_parent, collections.collection_name, collections.collection_description, collections.category, collections.userid, collections.views, 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, users.username AS user_username, COUNT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END) AS total_objects, GROUP_CONCAT(tags.name SEPARATOR ',') AS tags
FROM `clipbucket`.cb_collections AS collections
LEFT JOIN `clipbucket`.cb_users AS users ON collections.userid = users.userid
LEFT JOIN `clipbucket`.cb_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
LEFT JOIN `clipbucket`.cb_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND video.age_restriction IS NULL AND (video.broadcast = 'public')))
LEFT JOIN `clipbucket`.cb_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND ((photos.active = 'yes' AND photos.age_restriction IS NULL AND photos.broadcast = 'public')) LEFT JOIN `clipbucket`.cb_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN `clipbucket`.cb_tags AS tags ON collection_tags.id_tag = tags.id_tag WHERE collections.collection_id = '1' AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT collection_items.ci_id > 0 )
[timetook] => 0.00074481964111328
[memBefore] => 0.89167785644531
[memAfter] => 0.89441680908203
[memUsed] => 0.0027389526367188
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/collections.class.php(221): Clipbucket_db->_select()
#4 /home/videos.goe.ac/view_collection.php(22): Collection->getAll()
)
[12] => Array
(
[q] => SELECT collections.collection_id, collections.collection_id_parent, collections.collection_name, collections.collection_description, collections.category, collections.userid, collections.views, 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, users.username AS user_username, COUNT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END) AS total_objects, GROUP_CONCAT(tags.name SEPARATOR ',') AS tags
FROM `clipbucket`.cb_collections AS collections
LEFT JOIN `clipbucket`.cb_users AS users ON collections.userid = users.userid
LEFT JOIN `clipbucket`.cb_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
LEFT JOIN `clipbucket`.cb_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND video.age_restriction IS NULL AND (video.broadcast = 'public')))
LEFT JOIN `clipbucket`.cb_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND ((photos.active = 'yes' AND photos.age_restriction IS NULL AND photos.broadcast = 'public')) LEFT JOIN `clipbucket`.cb_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN `clipbucket`.cb_tags AS tags ON collection_tags.id_tag = tags.id_tag WHERE collections.collection_id_parent = '1' AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT collection_items.ci_id > 0 ) LIMIT 0,20
[timetook] => 0.0054059028625488
[memBefore] => 0.89441680908203
[memAfter] => 0.89886474609375
[memUsed] => 0.0044479370117188
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/collections.class.php(221): Clipbucket_db->_select()
#4 /home/videos.goe.ac/view_collection.php(36): Collection->getAll()
)
[13] => Array
(
[q] => SELECT collections.collection_id, collections.collection_id_parent, collections.collection_name, collections.collection_description, collections.category, collections.userid, collections.views, 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, users.username AS user_username, COUNT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END) AS total_objects, GROUP_CONCAT(tags.name SEPARATOR ',') AS tags
FROM `clipbucket`.cb_collections AS collections
LEFT JOIN `clipbucket`.cb_users AS users ON collections.userid = users.userid
LEFT JOIN `clipbucket`.cb_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
LEFT JOIN `clipbucket`.cb_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND video.age_restriction IS NULL AND (video.broadcast = 'public')))
LEFT JOIN `clipbucket`.cb_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND ((photos.active = 'yes' AND photos.age_restriction IS NULL AND photos.broadcast = 'public')) LEFT JOIN `clipbucket`.cb_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN `clipbucket`.cb_tags AS tags ON collection_tags.id_tag = tags.id_tag WHERE collections.collection_id = '1' AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id HAVING COUNT( DISTINCT collection_items.ci_id > 0 ) LIMIT 0,20
[timetook] => 0.00093793869018555
[memBefore] => 0.89886474609375
[memAfter] => 0.90198516845703
[memUsed] => 0.0031204223632812
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/collections.class.php(221): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/collections.class.php(277): Collection->getAll()
#5 /home/videos.goe.ac/view_collection.php(44): Collection->getItems()
)
[14] => Array
(
[q] => SELECT photos.photo_id, photos.photo_key, photos.photo_title, photos.photo_description, photos.userid, photos.collection_id, photos.date_added, photos.last_viewed, photos.views, photos.allow_comments, photos.allow_embedding, photos.allow_tagging, photos.featured, photos.reported, photos.allow_rating, photos.broadcast, photos.active, photos.total_comments, photos.last_commented, photos.total_favorites, photos.rating, photos.rated_by, photos.voters, photos.filename, photos.file_directory, photos.ext, photos.downloaded, photos.server_url, photos.owner_ip, photos.photo_details, photos.age_restriction, users.username, GROUP_CONCAT(tags.name SEPARATOR ',') AS tags
FROM `clipbucket`.cb_photos AS photos
LEFT JOIN `clipbucket`.cb_users AS users ON photos.userid = users.userid LEFT JOIN `clipbucket`.cb_photo_tags AS photo_tags ON photos.photo_id = photo_tags.id_photo LEFT JOIN `clipbucket`.cb_tags AS tags ON photo_tags.id_tag = tags.id_tag INNER JOIN `clipbucket`.cb_collection_items AS collection_items ON collection_items.collection_id = 1 AND photos.photo_id = collection_items.object_id WHERE ((photos.active = 'yes' AND photos.age_restriction IS NULL AND photos.broadcast = 'public')) GROUP BY photos.photo_id ORDER BY collection_items.date_added ASC
[timetook] => 0.0015969276428223
[memBefore] => 0.90198516845703
[memAfter] => 0.91194915771484
[memUsed] => 0.0099639892578125
[use_cache] => no
[backtrace] => #1 /home/videos.goe.ac/includes/classes/db.class.php(222): devWitch()
#2 /home/videos.goe.ac/includes/classes/db.class.php(106): Clipbucket_db->execute()
#3 /home/videos.goe.ac/includes/classes/photos.class.php(208): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/collections.class.php(233): Photo->getAll()
#5 /home/videos.goe.ac/includes/classes/collections.class.php(277): Collection->getAll()
#6 /home/videos.goe.ac/view_collection.php(44): Collection->getItems()
)
)
Comment (0)