Select Queries (13)

Array
(
    [0] => Array
        (
            [q] => SELECT * FROM cb_config
            [timetook] => 0.0010590553283691
            [memBefore] => 0.42488861083984
            [memAfter] => 0.45096588134766
            [memUsed] => 0.026077270507812
            [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/watch_video.php(4): require()

        )

    [1] => Array
        (
            [q] => SELECT * FROM cb_languages WHERE language_default='yes'  
            [timetook] => 0.00051212310791016
            [memBefore] => 0.45096588134766
            [memAfter] => 0.60946655273438
            [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/watch_video.php(4): 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.026618003845215
            [memBefore] => 0.60946655273438
            [memAfter] => 0.67745971679688
            [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/watch_video.php(4): require()

        )

    [3] => Array
        (
            [q] => SELECT * FROM cb_sessions WHERE session ='t4qshdcc8ephm1q78h31vj0kti'  
            [timetook] => 0.00058412551879883
            [memBefore] => 0.67745971679688
            [memAfter] => 0.80032348632812
            [memUsed] => 0.12286376953125
            [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/watch_video.php(4): require()

        )

    [4] => Array
        (
            [q] => SELECT * FROM cb_sessions WHERE  session_string='guest' AND  session ='t4qshdcc8ephm1q78h31vj0kti'  
            [timetook] => 0.00033807754516602
            [memBefore] => 0.78728485107422
            [memAfter] => 0.80368041992188
            [memUsed] => 0.016395568847656
            [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/watch_video.php(4): 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.00079703330993652
            [memBefore] => 0.80368041992188
            [memAfter] => 0.80574035644531
            [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/watch_video.php(4): require()

        )

    [6] => Array
        (
            [q] => SELECT version.id, version.version, version.revision FROM cb_version AS version 
            [timetook] => 0.00021100044250488
            [memBefore] => 0.80574035644531
            [memAfter] => 0.81069183349609
            [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/watch_video.php(4): require()

        )

    [7] => Array
        (
            [q] => SELECT * FROM cb_plugins WHERE plugin_active='yes' 
            [timetook] => 0.00033283233642578
            [memBefore] => 0.81069183349609
            [memAfter] => 0.86447906494141
            [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/watch_video.php(4): require()

        )

    [8] => Array
        (
            [q] => SELECT * FROM cb_languages WHERE language_default='yes'  
            [timetook] => 0.00037002563476562
            [memBefore] => 0.86447906494141
            [memAfter] => 0.87348937988281
            [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/watch_video.php(4): require()

        )

    [9] => Array
        (
            [q] => SELECT * FROM cb_tags_type WHERE name IN ('video','actors','producer','executive_producer','director','crew','genre') 
            [timetook] => 0.00027799606323242
            [memBefore] => 0.87348937988281
            [memAfter] => 0.88224029541016
            [memUsed] => 0.0087509155273438
            [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/tags.class.php(327): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/classes/tags.class.php(335): Tags->getTagTypes()
#6 /var/www/yurtube550/includes/classes/video.class.php(791): Tags->getVideoTypes()
#7 /var/www/yurtube550/watch_video.php(12): CBvideo->get_video()

        )

    [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.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.subscription_email, video.is_castable, video.bits_color, 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( CASE WHEN tags.id_tag_type = 6 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_actors, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 10 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_crew, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 9 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_director, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 8 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_executive_producer, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 11 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_genre, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 7 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_producer, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 1 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_video , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ', ') AS category FROM cb_video AS video LEFT JOIN cb_users AS users ON video.userid = users.userid LEFT JOIN cb_video_tags AS video_tags ON video.videoid = video_tags.id_video 
                    LEFT JOIN cb_tags AS tags ON video_tags.id_tag = tags.id_tag LEFT JOIN cb_videos_categories AS videos_categories ON video.videoid = videos_categories.id_video LEFT JOIN cb_categories AS categories ON videos_categories.id_category = categories.category_id WHERE video.videokey = '' GROUP BY  video.videoid , video.videoid  LIMIT 1
            [timetook] => 0.0011970996856689
            [memBefore] => 0.88224029541016
            [memAfter] => 0.90509796142578
            [memUsed] => 0.022857666015625
            [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/video.class.php(824): select()
#5 /var/www/yurtube550/watch_video.php(12): CBvideo->get_video()

        )

    [11] => Array
        (
            [q] => SELECT * FROM cb_tags_type WHERE name IN ('video','actors','producer','executive_producer','director','crew','genre') 
            [timetook] => 0.00028896331787109
            [memBefore] => 0.90509796142578
            [memAfter] => 0.88661956787109
            [memUsed] => -0.018478393554688
            [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/tags.class.php(327): Clipbucket_db->select()
#5 /var/www/yurtube550/includes/classes/tags.class.php(335): Tags->getTagTypes()
#6 /var/www/yurtube550/includes/classes/video.class.php(791): Tags->getVideoTypes()
#7 /var/www/yurtube550/includes/functions_video.php(27): CBvideo->get_video()
#8 /var/www/yurtube550/watch_video.php(14): video_playable()

        )

    [12] => 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.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.subscription_email, video.is_castable, video.bits_color, 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( CASE WHEN tags.id_tag_type = 6 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_actors, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 10 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_crew, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 9 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_director, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 8 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_executive_producer, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 11 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_genre, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 7 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_producer, GROUP_CONCAT( CASE WHEN tags.id_tag_type = 1 THEN tags.name ELSE '' END SEPARATOR ',') AS tags_video , GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ', ') AS category FROM cb_video AS video LEFT JOIN cb_users AS users ON video.userid = users.userid LEFT JOIN cb_video_tags AS video_tags ON video.videoid = video_tags.id_video 
                    LEFT JOIN cb_tags AS tags ON video_tags.id_tag = tags.id_tag LEFT JOIN cb_videos_categories AS videos_categories ON video.videoid = videos_categories.id_video LEFT JOIN cb_categories AS categories ON videos_categories.id_category = categories.category_id WHERE video.videokey = '' GROUP BY  video.videoid , video.videoid  LIMIT 1
            [timetook] => 0.00098896026611328
            [memBefore] => 0.88661956787109
            [memAfter] => 0.90959930419922
            [memUsed] => 0.022979736328125
            [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/video.class.php(824): select()
#5 /var/www/yurtube550/includes/functions_video.php(27): CBvideo->get_video()
#6 /var/www/yurtube550/watch_video.php(14): video_playable()

        )

)