Select Queries (20)
Array
(
[0] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_config
[timetook] => 0.00073695182800293
[memBefore] => 0.45802307128906
[memAfter] => 0.48069000244141
[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_item.php(5): require()
)
[1] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_languages WHERE language_default='yes'
[timetook] => 0.00020098686218262
[memBefore] => 0.48069000244141
[memAfter] => 0.61279296875
[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_item.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.01931619644165
[memBefore] => 0.61279296875
[memAfter] => 0.68077087402344
[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_item.php(5): require()
)
[3] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_sessions WHERE session ='rdd3oajm4acbvfp7mdge6vrl54'
[timetook] => 0.00061178207397461
[memBefore] => 0.68077087402344
[memAfter] => 0.79553985595703
[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/view_item.php(5): require()
)
[4] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_sessions WHERE session_string='guest' AND session ='rdd3oajm4acbvfp7mdge6vrl54'
[timetook] => 0.00023102760314941
[memBefore] => 0.78524780273438
[memAfter] => 0.80156707763672
[memUsed] => 0.016319274902344
[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_item.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.00031399726867676
[memBefore] => 0.80156707763672
[memAfter] => 0.80398559570312
[memUsed] => 0.0024185180664062
[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_item.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.00018692016601562
[memBefore] => 0.80398559570312
[memAfter] => 0.80992126464844
[memUsed] => 0.0059356689453125
[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_item.php(5): require()
)
[7] => Array
(
[q] => SELECT version.id, version.version, version.revision FROM `clipbucket`.cb_version AS version
[timetook] => 0.00013089179992676
[memBefore] => 0.80992126464844
[memAfter] => 0.82334136962891
[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_item.php(5): require()
)
[8] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_plugins WHERE plugin_active='yes'
[timetook] => 0.00053787231445312
[memBefore] => 0.82334136962891
[memAfter] => 0.87534332275391
[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_item.php(5): require()
)
[9] => Array
(
[q] => SELECT * FROM `clipbucket`.cb_languages WHERE language_default='yes'
[timetook] => 0.00015807151794434
[memBefore] => 0.87534332275391
[memAfter] => 0.87754821777344
[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_item.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.0008389949798584
[memBefore] => 0.87754821777344
[memAfter] => 0.89422607421875
[memUsed] => 0.016677856445312
[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_item.php(17): Collections->is_viewable()
)
[11] => Array
(
[q] => SELECT collections.*, users.username, CPARENT.collection_name AS collection_name_parent, COUNT( DISTINCT
CASE WHEN collections.type = 'photos' THEN photos.photo_id ELSE video.videoid END
) AS total_objects, GROUP_CONCAT(T.name SEPARATOR ',') AS collection_tags FROM `clipbucket`.cb_collections AS collections INNER JOIN `clipbucket`.cb_users AS users ON collections.userid = users.userid
LEFT JOIN `clipbucket`.cb_collections CPARENT ON collections.collection_id_parent = CPARENT.collection_id
LEFT JOIN `clipbucket`.cb_collection_items citem ON collections.collection_id = citem.collection_id
LEFT JOIN `clipbucket`.cb_video AS video ON collections.type = 'videos' AND citem.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 citem.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 CT ON collections.collection_id = CT.id_collection
LEFT JOIN `clipbucket`.cb_tags AS T ON CT.id_tag = T.id_tag WHERE collections.type = 'photos' AND collections.collection_id = '1' AND (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id
[timetook] => 0.00061798095703125
[memBefore] => 0.89422607421875
[memAfter] => 0.89502716064453
[memUsed] => 0.00080108642578125
[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/collections.class.php(857): Clipbucket_db->select()
#5 /home/videos.goe.ac/view_item.php(21): Collections->get_collections()
)
[12] => Array
(
[q] => SELECT C.* ,U.userid,U.username, COUNT(DISTINCT citem.ci_id) AS total_objects FROM `clipbucket`.cb_collections C
INNER JOIN `clipbucket`.cb_users U ON C.userid = U.userid
LEFT JOIN `clipbucket`.cb_collection_items citem ON C.collection_id = citem.collection_id
LEFT JOIN `clipbucket`.cb_photos obj ON obj.photo_id = citem.object_id WHERE C.collection_id_parent = 1 GROUP BY C.collection_id
[timetook] => 0.00084090232849121
[memBefore] => 0.89502716064453
[memAfter] => 0.89867401123047
[memUsed] => 0.0036468505859375
[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/collections.class.php(591): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/classes/collections.class.php(604): Collections->get_collection_childs()
#6 /home/videos.goe.ac/includes/classes/collections.class.php(861): Collections->get_total_object_sub_collection()
#7 /home/videos.goe.ac/view_item.php(21): Collections->get_collections()
)
[13] => Array
(
[q] => SELECT P.* , GROUP_CONCAT(T.name SEPARATOR ',') as photo_tags
FROM `clipbucket`.cb_photos AS P
LEFT JOIN `clipbucket`.cb_photo_tags AS PT ON P.photo_id = PT.id_photo
LEFT JOIN `clipbucket`.cb_tags AS T ON PT.id_tag = T.id_tag
WHERE P.photo_key = 'X5AS38SGBA52'
GROUP BY P.photo_id
[timetook] => 0.0003058910369873
[memBefore] => 0.89867401123047
[memAfter] => 0.89765930175781
[memUsed] => -0.0010147094726562
[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(695): Clipbucket_db->_select()
#4 /home/videos.goe.ac/view_item.php(24): CBPhotos->get_photo()
)
[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 WHERE photos.photo_id = '1' AND ((photos.active = 'yes' AND photos.age_restriction IS NULL AND photos.broadcast = 'public')) GROUP BY photos.photo_id
[timetook] => 0.00038480758666992
[memBefore] => 0.89765930175781
[memAfter] => 0.90706634521484
[memUsed] => 0.0094070434570312
[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/photos.class.php(99): Photo->getAll()
#5 /home/videos.goe.ac/includes/classes/photos.class.php(282): Photo->getOne()
#6 /home/videos.goe.ac/view_item.php(26): Photo->isCurrentUserRestricted()
)
[15] => Array
(
[q] => SELECT ci_id FROM `clipbucket`.cb_collection_items WHERE object_id = 1 AND collection_id = 1
[timetook] => 0.00018095970153809
[memBefore] => 0.90706634521484
[memAfter] => 0.90257263183594
[memUsed] => -0.0044937133789062
[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/collections.class.php(1003): Clipbucket_db->select()
#5 /home/videos.goe.ac/view_item.php(27): Collections->get_collection_item_fields()
)
[16] => Array
(
[q] => SELECT users.* FROM `clipbucket`.cb_users AS users WHERE users.userid = '2'
[timetook] => 0.00029420852661133
[memBefore] => 0.89204406738281
[memAfter] => 0.90792846679688
[memUsed] => 0.015884399414062
[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/user.class.php(890): select()
#5 /home/videos.goe.ac/view_item.php(56): userquery->get_user_details()
)
[17] => Array
(
[q] => SELECT collections.*, users.username, CPARENT.collection_name AS collection_name_parent, COUNT( DISTINCT
CASE WHEN collections.type = 'photos' THEN photos.photo_id ELSE video.videoid END
) AS total_objects, GROUP_CONCAT(T.name SEPARATOR ',') AS collection_tags FROM `clipbucket`.cb_collections AS collections INNER JOIN `clipbucket`.cb_users AS users ON collections.userid = users.userid
LEFT JOIN `clipbucket`.cb_collections CPARENT ON collections.collection_id_parent = CPARENT.collection_id
LEFT JOIN `clipbucket`.cb_collection_items citem ON collections.collection_id = citem.collection_id
LEFT JOIN `clipbucket`.cb_video AS video ON collections.type = 'videos' AND citem.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 citem.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 CT ON collections.collection_id = CT.id_collection
LEFT JOIN `clipbucket`.cb_tags AS T ON CT.id_tag = T.id_tag WHERE (collections.active = 'yes' AND collections.broadcast = 'public') GROUP BY collections.collection_id LIMIT 0,12
[timetook] => 0.0013501644134521
[memBefore] => 0.90792846679688
[memAfter] => 0.91730499267578
[memUsed] => 0.0093765258789062
[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/collections.class.php(857): Clipbucket_db->select()
#5 /home/videos.goe.ac/view_item.php(79): Collections->get_collections()
)
[18] => Array
(
[q] => SELECT C.* ,U.userid,U.username, COUNT(DISTINCT citem.ci_id) AS total_objects FROM `clipbucket`.cb_collections C
INNER JOIN `clipbucket`.cb_users U ON C.userid = U.userid
LEFT JOIN `clipbucket`.cb_collection_items citem ON C.collection_id = citem.collection_id
LEFT JOIN `clipbucket`.cb_photos obj ON obj.photo_id = citem.object_id WHERE C.collection_id_parent = 1 GROUP BY C.collection_id
[timetook] => 0.00070905685424805
[memBefore] => 0.91730499267578
[memAfter] => 0.92101287841797
[memUsed] => 0.0037078857421875
[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/collections.class.php(591): Clipbucket_db->select()
#5 /home/videos.goe.ac/includes/classes/collections.class.php(604): Collections->get_collection_childs()
#6 /home/videos.goe.ac/includes/classes/collections.class.php(861): Collections->get_total_object_sub_collection()
#7 /home/videos.goe.ac/view_item.php(79): Collections->get_collections()
)
[19] => 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.photo_id = '1' ) AND photos.collection_id <> '0' GROUP BY photos.photo_id
[timetook] => 0.00058794021606445
[memBefore] => 0.92101287841797
[memAfter] => 0.92684936523438
[memUsed] => 0.0058364868164062
[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/view_item.php(85): get_photos()
)
)
Comment (0)