Select Queries (12)

Array
(
    [0] => Array
        (
            [q] => SELECT * FROM `clipbucket`.cb_config
            [timetook] => 0.0016980171203613
            [memBefore] => 0.45668792724609
            [memAfter] => 0.47904968261719
            [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/watch_video.php(4): require()

        )

    [1] => Array
        (
            [q] => SELECT * FROM `clipbucket`.cb_languages WHERE language_default='yes'  
            [timetook] => 0.00097513198852539
            [memBefore] => 0.47904968261719
            [memAfter] => 0.61115264892578
            [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/watch_video.php(4): 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.01649808883667
            [memBefore] => 0.61115264892578
            [memAfter] => 0.67913055419922
            [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/watch_video.php(4): require()

        )

    [3] => Array
        (
            [q] => SELECT * FROM `clipbucket`.cb_sessions WHERE session ='i377ceagljdnf82krooiumot6l'  
            [timetook] => 0.0096569061279297
            [memBefore] => 0.67913055419922
            [memAfter] => 0.79389953613281
            [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/watch_video.php(4): require()

        )

    [4] => Array
        (
            [q] => SELECT * FROM `clipbucket`.cb_sessions WHERE  session_string='guest' AND  session ='i377ceagljdnf82krooiumot6l'  
            [timetook] => 0.00020003318786621
            [memBefore] => 0.78104400634766
            [memAfter] => 0.79747009277344
            [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/watch_video.php(4): 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.00025796890258789
            [memBefore] => 0.79747009277344
            [memAfter] => 0.79972839355469
            [memUsed] => 0.00225830078125
            [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/watch_video.php(4): 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.00012016296386719
            [memBefore] => 0.79972839355469
            [memAfter] => 0.80563354492188
            [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/watch_video.php(4): require()

        )

    [7] => Array
        (
            [q] => SELECT version.id, version.version, version.revision FROM `clipbucket`.cb_version AS version 
            [timetook] => 0.0001521110534668
            [memBefore] => 0.80563354492188
            [memAfter] => 0.81905364990234
            [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/watch_video.php(4): require()

        )

    [8] => Array
        (
            [q] => SELECT * FROM `clipbucket`.cb_plugins WHERE plugin_active='yes' 
            [timetook] => 0.00013995170593262
            [memBefore] => 0.81905364990234
            [memAfter] => 0.87105560302734
            [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/watch_video.php(4): require()

        )

    [9] => Array
        (
            [q] => SELECT * FROM `clipbucket`.cb_languages WHERE language_default='yes'  
            [timetook] => 0.00015687942504883
            [memBefore] => 0.87105560302734
            [memAfter] => 0.87326049804688
            [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/watch_video.php(4): require()

        )

    [10] => Array
        (
            [q] => SELECT video.videoid, video.videokey, video.video_password, video.video_users, video.username, video.userid, video.title, video.file_name, video.file_type, video.file_directory, video.description, video.category, video.broadcast, video.location, video.datecreated, video.country, video.allow_embedding, video.rating, video.rated_by, video.voter_ids, video.allow_comments, video.comment_voting, video.comments_count, video.last_commented, video.featured, video.featured_date, video.allow_rating, video.active, video.favourite_count, video.playlist_count, video.views, video.last_viewed, video.date_added, video.flagged, video.duration, video.status, video.default_thumb, video.embed_code, video.downloads, video.uploader_ip, video.video_files, video.file_server_path, video.video_version, video.thumbs_version, video.re_conv_status, video.is_castable, video.bits_color, video.subscription_email, video.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 , GROUP_CONCAT(T.name SEPARATOR ',') AS tags FROM `clipbucket`.cb_video AS video LEFT JOIN `clipbucket`.cb_users AS users ON video.userid = users.userid LEFT JOIN `clipbucket`.cb_video_tags AS VT ON video.videoid = VT.id_video 
                    LEFT JOIN `clipbucket`.cb_tags AS T ON VT.id_tag = T.id_tag WHERE video.videokey = ''  GROUP BY video.videoid  LIMIT 1
            [timetook] => 0.00096988677978516
            [memBefore] => 0.87326049804688
            [memAfter] => 0.90057373046875
            [memUsed] => 0.027313232421875
            [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/video.class.php(714): select()
#5 /home/videos.goe.ac/watch_video.php(12): CBvideo->get_video()

        )

    [11] => Array
        (
            [q] => SELECT video.videoid, video.videokey, video.video_password, video.video_users, video.username, video.userid, video.title, video.file_name, video.file_type, video.file_directory, video.description, video.category, video.broadcast, video.location, video.datecreated, video.country, video.allow_embedding, video.rating, video.rated_by, video.voter_ids, video.allow_comments, video.comment_voting, video.comments_count, video.last_commented, video.featured, video.featured_date, video.allow_rating, video.active, video.favourite_count, video.playlist_count, video.views, video.last_viewed, video.date_added, video.flagged, video.duration, video.status, video.default_thumb, video.embed_code, video.downloads, video.uploader_ip, video.video_files, video.file_server_path, video.video_version, video.thumbs_version, video.re_conv_status, video.is_castable, video.bits_color, video.subscription_email, video.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 , GROUP_CONCAT(T.name SEPARATOR ',') AS tags FROM `clipbucket`.cb_video AS video LEFT JOIN `clipbucket`.cb_users AS users ON video.userid = users.userid LEFT JOIN `clipbucket`.cb_video_tags AS VT ON video.videoid = VT.id_video 
                    LEFT JOIN `clipbucket`.cb_tags AS T ON VT.id_tag = T.id_tag WHERE video.videokey = ''  GROUP BY video.videoid  LIMIT 1
            [timetook] => 0.00038290023803711
            [memBefore] => 0.90057373046875
            [memAfter] => 0.90309906005859
            [memUsed] => 0.0025253295898438
            [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/video.class.php(714): select()
#5 /home/videos.goe.ac/includes/functions_video.php(27): CBvideo->get_video()
#6 /home/videos.goe.ac/watch_video.php(14): video_playable()

        )

)