Select Queries (13)
Array
(
[0] => Array
(
[q] => SELECT * FROM cb_config
[timetook] => 0.0010151863098145
[memBefore] => 0.42450714111328
[memAfter] => 0.45088958740234
[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.00063014030456543
[memBefore] => 0.45088958740234
[memAfter] => 0.60939025878906
[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.028088092803955
[memBefore] => 0.60939025878906
[memAfter] => 0.67738342285156
[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 ='1iofmg5tjkjqasc3l7fvn54dl6'
[timetook] => 0.00060606002807617
[memBefore] => 0.67738342285156
[memAfter] => 0.80055236816406
[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 ='1iofmg5tjkjqasc3l7fvn54dl6'
[timetook] => 0.00027990341186523
[memBefore] => 0.78765106201172
[memAfter] => 0.80393981933594
[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.00049090385437012
[memBefore] => 0.80393981933594
[memAfter] => 0.80599975585938
[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.00030517578125
[memBefore] => 0.80599975585938
[memAfter] => 0.81095123291016
[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.0004270076751709
[memBefore] => 0.81095123291016
[memAfter] => 0.86473846435547
[memUsed] => 0.053787231445312
[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.00040006637573242
[memBefore] => 0.86473846435547
[memAfter] => 0.87374877929688
[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.00074005126953125
[memBefore] => 0.87374877929688
[memAfter] => 0.87995910644531
[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.017194986343384
[memBefore] => 0.86907958984375
[memAfter] => 0.89204406738281
[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.00058603286743164
[memBefore] => 0.89204406738281
[memAfter] => 0.89147186279297
[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.00064182281494141
[memBefore] => 0.89147186279297
[memAfter] => 0.89456176757812
[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()
)
)
00:47
00:08
00:55
10:16
10:06
01:05
07:00
01:23