Select Queries (13)
Array
(
[0] => Array
(
[q] => SELECT * FROM cb_config
[timetook] => 0.00084900856018066
[memBefore] => 0.43370056152344
[memAfter] => 0.4600830078125
[memUsed] => 0.026382446289062
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/functions_db.php(11): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/my_queries.class.php(33): db_select()
#5 /var/www/yurtube550/includes/common.php(81): myquery->Get_Website_Details()
#6 /var/www/yurtube550/includes/config.inc.php(9): require_once()
#7 /var/www/yurtube550/view_channel.php(5): require()
)
[1] => Array
(
[q] => SELECT * FROM cb_languages WHERE language_default='yes'
[timetook] => 0.00030803680419922
[memBefore] => 0.4600830078125
[memAfter] => 0.61858367919922
[memUsed] => 0.15850067138672
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/lang.class.php(313): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/classes/lang.class.php(61): Language->getDefaultLanguage()
#6 /var/www/yurtube550/includes/common.php(121): Language->init()
#7 /var/www/yurtube550/includes/config.inc.php(9): require_once()
#8 /var/www/yurtube550/view_channel.php(5): require()
)
[2] => Array
(
[q] => SELECT language_key, translation FROM cb_languages_keys AS LK
LEFT JOIN 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.020147085189819
[memBefore] => 0.61858367919922
[memAfter] => 0.68657684326172
[memUsed] => 0.0679931640625
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/lang.class.php(143): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/classes/lang.class.php(206): Language->getAllTranslations()
#6 /var/www/yurtube550/includes/common.php(122): Language->loadTranslations()
#7 /var/www/yurtube550/includes/config.inc.php(9): require_once()
#8 /var/www/yurtube550/view_channel.php(5): require()
)
[3] => Array
(
[q] => SELECT * FROM cb_sessions WHERE session ='3k7sv6memgn9gtvsns7qkna1k7'
[timetook] => 0.00052499771118164
[memBefore] => 0.68657684326172
[memAfter] => 0.80974578857422
[memUsed] => 0.1231689453125
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/session.class.php(98): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/classes/user.class.php(5226): Session->get_sessions()
#6 /var/www/yurtube550/includes/classes/user.class.php(325): userquery->get_sessions()
#7 /var/www/yurtube550/includes/common.php(132): userquery->init()
#8 /var/www/yurtube550/includes/config.inc.php(9): require_once()
#9 /var/www/yurtube550/view_channel.php(5): require()
)
[4] => Array
(
[q] => SELECT * FROM cb_sessions WHERE session_string='guest' AND session ='3k7sv6memgn9gtvsns7qkna1k7'
[timetook] => 0.00030994415283203
[memBefore] => 0.79684448242188
[memAfter] => 0.81313323974609
[memUsed] => 0.016288757324219
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/session.class.php(86): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/classes/session.class.php(41): Session->get_user_session()
#6 /var/www/yurtube550/includes/classes/user.class.php(5233): Session->add_session()
#7 /var/www/yurtube550/includes/classes/user.class.php(325): userquery->get_sessions()
#8 /var/www/yurtube550/includes/common.php(132): userquery->init()
#9 /var/www/yurtube550/includes/config.inc.php(9): require_once()
#10 /var/www/yurtube550/view_channel.php(5): require()
)
[5] => Array
(
[q] => SELECT * FROM cb_user_levels,cb_user_levels_permissions WHERE cb_user_levels_permissions.user_level_id='4'
AND cb_user_levels_permissions.user_level_id = cb_user_levels.user_level_id
[timetook] => 0.00058102607727051
[memBefore] => 0.81313323974609
[memAfter] => 0.81519317626953
[memUsed] => 0.0020599365234375
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/user.class.php(1877): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/classes/user.class.php(362): userquery->get_user_level()
#6 /var/www/yurtube550/includes/common.php(132): userquery->init()
#7 /var/www/yurtube550/includes/config.inc.php(9): require_once()
#8 /var/www/yurtube550/view_channel.php(5): require()
)
[6] => Array
(
[q] => SELECT version.id, version.version, version.revision FROM cb_version AS version
[timetook] => 0.00023508071899414
[memBefore] => 0.81519317626953
[memAfter] => 0.82014465332031
[memUsed] => 0.0049514770507812
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/update.class.php(57): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/classes/update.class.php(430): Update->getDBVersion()
#6 /var/www/yurtube550/includes/common.php(138): Update->isVersionSystemInstalled()
#7 /var/www/yurtube550/includes/config.inc.php(9): require_once()
#8 /var/www/yurtube550/view_channel.php(5): require()
)
[7] => Array
(
[q] => SELECT * FROM cb_plugins WHERE plugin_active='yes'
[timetook] => 0.00031089782714844
[memBefore] => 0.82014465332031
[memAfter] => 0.87362670898438
[memUsed] => 0.053482055664062
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/plugin.class.php(218): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/plugins.php(5): CBPlugin->getInstalledPlugins()
#6 /var/www/yurtube550/includes/config.inc.php(10): require_once()
#7 /var/www/yurtube550/view_channel.php(5): require()
)
[8] => Array
(
[q] => SELECT * FROM cb_languages WHERE language_default='yes'
[timetook] => 0.0003209114074707
[memBefore] => 0.87362670898438
[memAfter] => 0.88263702392578
[memUsed] => 0.0090103149414062
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/db.class.php(158): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/lang.class.php(313): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/functions.php(1393): Language->getDefaultLanguage()
#6 /var/www/yurtube550/player/CB_video_js/cb_video_js.php(28): get_current_language()
#7 /var/www/yurtube550/player/CB_video_js/cb_video_js.php(138): CB_video_js->load_dependancies()
#8 /var/www/yurtube550/player/CB_video_js/cb_video_js.php(143): CB_video_js->__construct()
#9 /var/www/yurtube550/includes/plugins.php(39): include_once()
#10 /var/www/yurtube550/includes/config.inc.php(10): require_once()
#11 /var/www/yurtube550/view_channel.php(5): require()
)
[9] => Array
(
[q] => SELECT users.*, users_categories.id_category FROM cb_users AS users LEFT JOIN cb_users_categories AS users_categories ON users.userid = users_categories.id_user WHERE users.username = 'Sphynkx'
[timetook] => 0.00047612190246582
[memBefore] => 0.88263702392578
[memAfter] => 0.88884735107422
[memUsed] => 0.0062103271484375
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/functions_db.php(108): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/user.class.php(916): select()
#5 /var/www/yurtube550/view_channel.php(20): userquery->get_user_details()
)
[10] => Array
(
[q] => SELECT UP.userid, UP.show_my_collections, UP.profile_title, UP.profile_desc, UP.featured_video, UP.first_name, UP.last_name, UP.avatar, UP.show_dob, UP.postal_code, UP.time_zone, UP.web_url, UP.fb_url, UP.twitter_url, UP.insta_url, UP.hometown, UP.city, UP.online_status, UP.show_profile, UP.allow_comments, UP.allow_ratings, UP.allow_subscription, UP.content_filter, UP.icon_id, UP.browse_criteria, UP.about_me, UP.education, UP.schools, UP.occupation, UP.companies, UP.relation_status, UP.hobbies, UP.fav_movies, UP.fav_music, UP.fav_books, UP.background, UP.profile_video, UP.profile_item, UP.rating, UP.voters, UP.rated_by, UP.show_my_videos, UP.show_my_photos, UP.show_my_subscriptions, UP.show_my_subscribers, UP.show_my_friends, GROUP_CONCAT(T.name SEPARATOR ',') as profile_tags
FROM cb_user_profile UP
LEFT JOIN cb_user_tags UT ON UP.userid = UT.id_user
LEFT JOIN cb_tags T ON T.id_tag = UT.id_tag
WHERE UP.userid = 1
GROUP BY UP.userid, UP.show_my_collections, UP.profile_title, UP.profile_desc, UP.featured_video, UP.first_name, UP.last_name, UP.avatar, UP.show_dob, UP.postal_code, UP.time_zone, UP.web_url, UP.fb_url, UP.twitter_url, UP.insta_url, UP.hometown, UP.city, UP.online_status, UP.show_profile, UP.allow_comments, UP.allow_ratings, UP.allow_subscription, UP.content_filter, UP.icon_id, UP.browse_criteria, UP.about_me, UP.education, UP.schools, UP.occupation, UP.companies, UP.relation_status, UP.hobbies, UP.fav_movies, UP.fav_music, UP.fav_books, UP.background, UP.profile_video, UP.profile_item, UP.rating, UP.voters, UP.rated_by, UP.show_my_videos, UP.show_my_photos, UP.show_my_subscriptions, UP.show_my_subscribers, UP.show_my_friends
[timetook] => 0.0011961460113525
[memBefore] => 0.87796783447266
[memAfter] => 0.90093231201172
[memUsed] => 0.022964477539062
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/classes/user.class.php(2284): Clipbucket_db->_select()
#4 /var/www/yurtube550/view_channel.php(65): userquery->get_user_profile()
)
[11] => Array
(
[q] => SELECT users.*, users_categories.id_category FROM cb_users AS users LEFT JOIN cb_users_categories AS users_categories ON users.userid = users_categories.id_user WHERE users.userid = '1'
[timetook] => 0.00051999092102051
[memBefore] => 0.90093231201172
[memAfter] => 0.90036010742188
[memUsed] => -0.00057220458984375
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/functions_db.php(108): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/user.class.php(916): select()
#5 /var/www/yurtube550/includes/classes/user.class.php(2739): userquery->get_user_details()
#6 /var/www/yurtube550/view_channel.php(67): userquery->getBackground()
)
[12] => Array
(
[q] => SELECT 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, users.last_active, users.total_collections, profile.rating, profile.rated_by, profile.voters, profile.first_name, profile.last_name, profile.profile_title, profile.profile_desc, profile.city, profile.hometown FROM cb_users AS users LEFT JOIN cb_user_profile AS profile ON users.userid = profile.userid WHERE users.usr_status='Ok' AND users.ban_status ='no' ORDER BY profile_hits DESC limit 6
[timetook] => 0.00053715705871582
[memBefore] => 0.90036010742188
[memAfter] => 0.90345001220703
[memUsed] => 0.0030899047851562
[use_cache] => no
[backtrace] => #1 /var/www/yurtube550/includes/classes/db.class.php(225): devWitch()
#2 /var/www/yurtube550/includes/classes/db.class.php(109): Clipbucket_db->execute()
#3 /var/www/yurtube550/includes/functions_db.php(108): Clipbucket_db->_select()
#4 /var/www/yurtube550/includes/classes/user.class.php(3823): select()
#5 /var/www/yurtube550/includes/functions.php(2254): userquery->get_users()
#6 /var/www/yurtube550/view_channel.php(72): get_users()
)
)