Select Queries (10)
Array
(
[0] => Array
(
[q] => SELECT * FROM cbv5kz_config
[timetook] => 0.00069618225097656
[memBefore] => 0.43418884277344
[memAfter] => 0.46041870117188
[memUsed] => 0.026229858398438
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/functions_db.php(11): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/my_queries.class.php(33): db_select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(87): myquery->Get_Website_Details()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[1] => Array
(
[q] => SELECT * FROM cbv5kz_languages WHERE language_default='yes'
[timetook] => 0.00015592575073242
[memBefore] => 0.46041870117188
[memAfter] => 0.62445831298828
[memUsed] => 0.16403961181641
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/lang.class.php(310): Clipbucket_db->select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/lang.class.php(66): Language->getDefaultLanguage()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(127): Language->init()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[2] => Array
(
[q] => SELECT language_key, translation FROM cbv5kz_languages_keys AS LK
LEFT JOIN cbv5kz_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.0038719177246094
[memBefore] => 0.62445831298828
[memAfter] => 0.69326782226562
[memUsed] => 0.068809509277344
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/lang.class.php(147): Clipbucket_db->select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/lang.class.php(208): Language->getAllTranslations()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/lang.class.php(75): Language->loadTranslations()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(127): Language->init()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#9 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[3] => Array
(
[q] => SELECT * FROM cbv5kz_sessions WHERE session ='6cb05e084af3dee5d92157a3b7e2867c'
[timetook] => 0.00013017654418945
[memBefore] => 0.69326782226562
[memAfter] => 0.81931304931641
[memUsed] => 0.12604522705078
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/session.class.php(99): Clipbucket_db->select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(5194): Session->get_sessions()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(552): userquery->get_sessions()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(137): userquery->init()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#9 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[4] => Array
(
[q] => SELECT * FROM cbv5kz_sessions WHERE session_string='guest' AND session ='6cb05e084af3dee5d92157a3b7e2867c'
[timetook] => 0.00011706352233887
[memBefore] => 0.80861663818359
[memAfter] => 0.82542419433594
[memUsed] => 0.016807556152344
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/session.class.php(88): Clipbucket_db->select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/session.class.php(44): Session->get_user_session()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(5201): Session->add_session()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(552): userquery->get_sessions()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(137): userquery->init()
#9 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#10 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[5] => Array
(
[q] => SELECT * FROM cbv5kz_user_levels,cbv5kz_user_levels_permissions WHERE cbv5kz_user_levels_permissions.user_level_id='4'
AND cbv5kz_user_levels_permissions.user_level_id = cbv5kz_user_levels.user_level_id
[timetook] => 0.00019407272338867
[memBefore] => 0.82542419433594
[memAfter] => 0.82808685302734
[memUsed] => 0.0026626586914062
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(2099): Clipbucket_db->select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(589): userquery->get_user_level()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(137): userquery->init()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[6] => Array
(
[q] => SELECT version.id, version.version, version.revision FROM cbv5kz_version AS version
[timetook] => 8.392333984375E-5
[memBefore] => 0.82808685302734
[memAfter] => 0.83338165283203
[memUsed] => 0.0052947998046875
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/update.class.php(60): Clipbucket_db->select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/update.class.php(422): Update->getDBVersion()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(143): Update->isVersionSystemInstalled()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[7] => Array
(
[q] => SELECT * FROM cbv5kz_plugins WHERE plugin_active='yes'
[timetook] => 0.00012516975402832
[memBefore] => 0.83338165283203
[memAfter] => 0.88388061523438
[memUsed] => 0.050498962402344
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/plugin.class.php(218): Clipbucket_db->select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/plugins.php(5): CBPlugin->getInstalledPlugins()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(10): require_once()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[8] => Array
(
[q] => SELECT * FROM cbv5kz_languages WHERE language_default='yes'
[timetook] => 0.00010585784912109
[memBefore] => 0.88388061523438
[memAfter] => 0.88606262207031
[memUsed] => 0.0021820068359375
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/lang.class.php(310): Clipbucket_db->select()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/functions.php(1274): Language->getDefaultLanguage()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/player/CB_video_js/cb_video_js.php(24): get_current_language()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/player/CB_video_js/cb_video_js.php(135): CB_video_js->load_dependancies()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/player/CB_video_js/cb_video_js.php(140): CB_video_js->__construct()
#9 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/plugins.php(39): include_once()
#10 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(10): require_once()
#11 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
[9] => Array
(
[q] => SELECT collections.collection_id, collections.collection_name, collections.collection_description, 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, collections.collection_id_parent, users.username AS user_username, COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) AS total_objects, 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 cbv5kz_collections AS collections
LEFT JOIN cbv5kz_users AS users ON collections.userid = users.userid
LEFT JOIN cbv5kz_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
LEFT JOIN cbv5kz_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' OR (video.broadcast = 'unlisted' AND video.video_password = ''))))
LEFT JOIN cbv5kz_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' OR (photos.broadcast = 'unlisted')))) LEFT JOIN cbv5kz_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection LEFT JOIN cbv5kz_tags AS tags ON collection_tags.id_tag = tags.id_tag LEFT JOIN cbv5kz_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection LEFT JOIN cbv5kz_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)) > 0 ORDER BY COUNT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END) DESC LIMIT 4
[timetook] => 0.00059008598327637
[memBefore] => 0.88606262207031
[memAfter] => 0.90471649169922
[memUsed] => 0.018653869628906
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/collections.class.php(326): Clipbucket_db->_select()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(19): Collection->getAll()
)
)
Update Queries (1)
Array
(
[0] => Array
(
[q] => UPDATE cbv5kz_sessions SET last_active='2024-07-27 02:34:53',current_page='https://cvtv.creativeveins.com/' WHERE session='6cb05e084af3dee5d92157a3b7e2867c'
[timetook] => 0.00011110305786133
[memBefore] => 0.81931304931641
[memAfter] => 0.80861663818359
[memUsed] => -0.010696411132812
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(315): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/session.class.php(105): Clipbucket_db->update()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(5194): Session->get_sessions()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(552): userquery->get_sessions()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(137): userquery->init()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
)
Execute Query(1)
Array
(
[0] => Array
(
[q] => SET NAMES "utf8mb4"
[timetook] => 5.1975250244141E-5
[memBefore] => 0
[memAfter] => 0.43418884277344
[memUsed] => 0.43418884277344
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(70): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.php(18): Clipbucket_db->connect()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(65): require_once()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
)
Expensive Queries(0.43418884277344)
Array
(
[q] => SET NAMES "utf8mb4"
[timetook] => 5.1975250244141E-5
[memBefore] => 0
[memAfter] => 0.43418884277344
[memUsed] => 0.43418884277344
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(70): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.php(18): Clipbucket_db->connect()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(65): require_once()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)
Cheapest Queries(-0.010696411132812)
Array
(
[q] => UPDATE cbv5kz_sessions SET last_active='2024-07-27 02:34:53',current_page='https://cvtv.creativeveins.com/' WHERE session='6cb05e084af3dee5d92157a3b7e2867c'
[timetook] => 0.00011110305786133
[memBefore] => 0.81931304931641
[memAfter] => 0.80861663818359
[memUsed] => -0.010696411132812
[use_cache] => no
[backtrace] => #1 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(225): devWitch()
#2 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/db.class.php(315): Clipbucket_db->execute()
#3 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/session.class.php(105): Clipbucket_db->update()
#4 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(5194): Session->get_sessions()
#5 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/classes/user.class.php(552): userquery->get_sessions()
#6 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/common.php(137): userquery->init()
#7 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#8 /home/cvadmin/domains/cvtv.creativeveins.com/clipbucket-v5/upload/index.php(6): require()
)