Select Queries (12)
Array
(
[0] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_config
[timetook] => 0.0007328987121582
[memBefore] => 0.45649719238281
[memAfter] => 0.47885894775391
[memUsed] => 0.022361755371094
[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/photos.php(5): require()
)
[1] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_languages WHERE language_default='yes'
[timetook] => 0.00031900405883789
[memBefore] => 0.47885894775391
[memAfter] => 0.6109619140625
[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/photos.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.010043144226074
[memBefore] => 0.6109619140625
[memAfter] => 0.67893981933594
[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/photos.php(5): require()
)
[3] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_sessions WHERE session ='j3j8038ifftue5hov9d7pcpkas'
[timetook] => 0.00038003921508789
[memBefore] => 0.67893981933594
[memAfter] => 0.79370880126953
[memUsed] => 0.11476898193359
[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/photos.php(5): require()
)
[4] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_sessions WHERE session_string='guest' AND session ='j3j8038ifftue5hov9d7pcpkas'
[timetook] => 0.00024008750915527
[memBefore] => 0.78082275390625
[memAfter] => 0.79724884033203
[memUsed] => 0.016426086425781
[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/photos.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.00037312507629395
[memBefore] => 0.79724884033203
[memAfter] => 0.79950714111328
[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/photos.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.00022482872009277
[memBefore] => 0.79950714111328
[memAfter] => 0.80541229248047
[memUsed] => 0.0059051513671875
[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/photos.php(5): require()
)
[7] => Array
(
[q] => SELECT version.id, version.version, version.revision FROM `clipbucket`.cb_version AS version
[timetook] => 0.0001368522644043
[memBefore] => 0.80541229248047
[memAfter] => 0.81883239746094
[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/photos.php(5): require()
)
[8] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_plugins WHERE plugin_active='yes'
[timetook] => 0.00017595291137695
[memBefore] => 0.81883239746094
[memAfter] => 0.87083435058594
[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/photos.php(5): require()
)
[9] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_languages WHERE language_default='yes'
[timetook] => 0.00018596649169922
[memBefore] => 0.87083435058594
[memAfter] => 0.87303924560547
[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/photos.php(5): require()
)
[10] => Array
(
[q] => SELECT photos.photo_id, photos.photo_key, photos.userid, photos.photo_title, photos.photo_description, photos.collection_id, photos.photo_details, photos.date_added, photos.filename, photos.ext, photos.active, photos.broadcast, photos.file_directory, photos.views, photos.last_commented, photos.total_comments, photos.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, collections.collection_name, collections.type, collections.category, collections.views as collection_views, collections.date_added as collection_added , GROUP_CONCAT(T.name SEPARATOR ',') as photo_tags FROM `clipbucket`.cb_photos AS photos LEFT JOIN `clipbucket`.cb_collections AS collections ON photos.collection_id = collections.collection_id LEFT JOIN `clipbucket`.cb_users AS users ON collections.userid = users.userid LEFT JOIN `clipbucket`.cb_photo_tags AS PT ON photos.photo_id = PT.id_photo
LEFT JOIN `clipbucket`.cb_tags AS T ON PT.id_tag = T.id_tag WHERE ((photos.active = 'yes' AND photos.age_restriction IS NULL AND photos.broadcast = 'public')) AND photos.date_added IS NOT NULL AND photos.collection_id <> '0' GROUP BY photos.photo_id ORDER BY date_added DESC LIMIT 0,10
[timetook] => 0.0041561126708984
[memBefore] => 0.87303924560547
[memAfter] => 0.88818359375
[memUsed] => 0.015144348144531
[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(109): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/classes/photos.class.php(880): select()
#5 /home/videos.goe.ac/includes/functions_photo.php(15): CBPhotos->get_photos()
#6 /home/videos.goe.ac/photos.php(25): get_photos()
)
[11] => Array
(
[q] => SELECT COUNT(*) AS total FROM (SELECT photo_id FROM`clipbucket`.cb_photos AS photos LEFT JOIN `clipbucket`.cb_photo_tags AS PT ON photos.photo_id = PT.id_photo
LEFT JOIN `clipbucket`.cb_tags AS T ON PT.id_tag = T.id_tag WHERE ((photos.active = 'yes' AND photos.age_restriction IS NULL AND photos.broadcast = 'public')) AND photos.date_added IS NOT NULL AND photos.collection_id <> '0' GROUP BY photos.photo_id ) T
[timetook] => 0.0020229816436768
[memBefore] => 0.88818359375
[memAfter] => 0.89724731445312
[memUsed] => 0.009063720703125
[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(982): Clipbucket_db->_select()
#4 /home/videos.goe.ac/includes/functions_photo.php(15): CBPhotos->get_photos()
#5 /home/videos.goe.ac/photos.php(30): get_photos()
)
)
