Select Queries (12)
Array
(
[0] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_config
[timetook] => 0.0013999938964844
[memBefore] => 0.45632171630859
[memAfter] => 0.47868347167969
[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.00047707557678223
[memBefore] => 0.47868347167969
[memAfter] => 0.61078643798828
[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.010193109512329
[memBefore] => 0.61078643798828
[memAfter] => 0.67876434326172
[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 ='n7bbl7uls6hk7lpr76ohu81g2k'
[timetook] => 0.00030803680419922
[memBefore] => 0.67876434326172
[memAfter] => 0.79353332519531
[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 ='n7bbl7uls6hk7lpr76ohu81g2k'
[timetook] => 0.00015497207641602
[memBefore] => 0.78310394287109
[memAfter] => 0.79953002929688
[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.00035810470581055
[memBefore] => 0.79953002929688
[memAfter] => 0.80182647705078
[memUsed] => 0.0022964477539062
[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.00015807151794434
[memBefore] => 0.80182647705078
[memAfter] => 0.80773162841797
[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.00013399124145508
[memBefore] => 0.80773162841797
[memAfter] => 0.82115173339844
[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.00013303756713867
[memBefore] => 0.82115173339844
[memAfter] => 0.87315368652344
[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.00013899803161621
[memBefore] => 0.87315368652344
[memAfter] => 0.87535858154297
[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.0012660026550293
[memBefore] => 0.87535858154297
[memAfter] => 0.8905029296875
[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.00037002563476562
[memBefore] => 0.8905029296875
[memAfter] => 0.89956665039062
[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()
)
)
