Searching 'publishes' in videos

Select Queries (12)

Array
(
    [0] => Array
        (
            [q] => SELECT * FROM cb_config
            [timetook] => 0.0017631053924561
            [memBefore] => 0.51890563964844
            [memAfter] => 0.56116485595703
            [memUsed] => 0.042259216308594
            [use_cache] => no
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(246): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/html/clipbucket-v5/upload/includes/functions_db.php(10): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/my_queries.class.php(36): db_select()
#5 /var/www/html/clipbucket-v5/upload/includes/common.php(101): myquery->Get_Website_Details()
#6 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#7 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [1] => Array
        (
            [q] => SELECT * FROM cb_sessions WHERE session ='7r9t5cp1ea7dsp4s6daqguejpd'  
            [timetook] => 0.0010840892791748
            [memBefore] => 0.56116485595703
            [memAfter] => 0.83821868896484
            [memUsed] => 0.27705383300781
            [use_cache] => no
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(246): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/session.class.php(99): Clipbucket_db->select()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(5324): Session->get_sessions()
#6 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(986): userquery->get_sessions()
#7 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(927): userquery->init()
#8 /var/www/html/clipbucket-v5/upload/includes/functions.php(504): userquery->getInstance()
#9 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(188): user_id()
#10 /var/www/html/clipbucket-v5/upload/includes/common.php(159): User->getInstance()
#11 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#12 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [2] => Array
        (
            [q] => SELECT * FROM cb_sessions WHERE  session_string='guest' AND  session ='7r9t5cp1ea7dsp4s6daqguejpd'  
            [timetook] => 0.00076699256896973
            [memBefore] => 0.8272705078125
            [memAfter] => 0.84416961669922
            [memUsed] => 0.016899108886719
            [use_cache] => no
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(246): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(179): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/session.class.php(88): Clipbucket_db->select()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/session.class.php(44): Session->get_user_session()
#6 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(5331): Session->add_session()
#7 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(986): userquery->get_sessions()
#8 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(927): userquery->init()
#9 /var/www/html/clipbucket-v5/upload/includes/functions.php(504): userquery->getInstance()
#10 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(188): user_id()
#11 /var/www/html/clipbucket-v5/upload/includes/common.php(159): User->getInstance()
#12 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#13 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [3] => Array
        (
            [q] => SELECT version.id, version.version, version.revision FROM cb_version AS version 
            [timetook] => 0.00066995620727539
            [memBefore] => 0.84416961669922
            [memAfter] => 0.83187866210938
            [memUsed] => -0.012290954589844
            [use_cache] => yes
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(120): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(179): Clipbucket_db->_select()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/update.class.php(60): Clipbucket_db->select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/update.class.php(770): Update->getDBVersion()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/user_level.class.php(39): Update->IsCurrentDBVersionIsHigherOrEqualTo()
#6 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(1024): UserLevel->getPermissions()
#7 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(927): userquery->init()
#8 /var/www/html/clipbucket-v5/upload/includes/functions.php(504): userquery->getInstance()
#9 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(188): user_id()
#10 /var/www/html/clipbucket-v5/upload/includes/common.php(159): User->getInstance()
#11 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#12 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [4] => Array
        (
            [q] => SELECT user_levels_permissions.id_user_levels_permission, user_levels_permissions.id_user_permission_types, user_levels_permissions.permission_name, user_levels_permissions.permission_description, user_levels_permissions_values.user_level_id, user_levels_permissions_values.id_user_levels_permission, user_levels_permissions_values.permission_value
                FROM cb_user_levels_permissions AS user_levels_permissions INNER JOIN cb_user_levels_permissions_values AS user_levels_permissions_values ON user_levels_permissions.id_user_levels_permission = user_levels_permissions_values.id_user_levels_permission WHERE  user_levels_permissions_values.user_level_id = 4
            [timetook] => 0.0010859966278076
            [memBefore] => 0.83187866210938
            [memAfter] => 0.85616302490234
            [memUsed] => 0.024284362792969
            [use_cache] => no
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(246): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/user_level.class.php(139): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/user_level.class.php(40): UserLevel->getAllPermissions()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(1024): UserLevel->getPermissions()
#6 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(927): userquery->init()
#7 /var/www/html/clipbucket-v5/upload/includes/functions.php(504): userquery->getInstance()
#8 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(188): user_id()
#9 /var/www/html/clipbucket-v5/upload/includes/common.php(159): User->getInstance()
#10 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#11 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [5] => Array
        (
            [q] => SELECT * FROM cb_languages WHERE language_default='yes'  
            [timetook] => 0.00044703483581543
            [memBefore] => 0.85616302490234
            [memAfter] => 0.94197082519531
            [memUsed] => 0.085807800292969
            [use_cache] => yes
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(120): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(179): Clipbucket_db->_select()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/lang.class.php(318): Clipbucket_db->select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/lang.class.php(74): Language->getDefaultLanguage()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/lang.class.php(14): Language->init()
#6 /var/www/html/clipbucket-v5/upload/includes/functions.php(1097): Language->getInstance()
#7 /var/www/html/clipbucket-v5/upload/includes/classes/collections.class.php(907): lang()
#8 /var/www/html/clipbucket-v5/upload/includes/classes/video.class.php(1237): Collections->__construct()
#9 /var/www/html/clipbucket-v5/upload/includes/classes/video.class.php(1057): CBvideo->init_collections()
#10 /var/www/html/clipbucket-v5/upload/includes/common.php(248): CBvideo->init()
#11 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#12 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [6] => 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.0049831867218018
            [memBefore] => 0.94197082519531
            [memAfter] => 1.7360076904297
            [memUsed] => 0.79403686523438
            [use_cache] => yes
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(120): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(179): Clipbucket_db->_select()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/lang.class.php(155): Clipbucket_db->select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/lang.class.php(216): Language->getAllTranslations()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/lang.class.php(83): Language->loadTranslations()
#6 /var/www/html/clipbucket-v5/upload/includes/classes/lang.class.php(14): Language->init()
#7 /var/www/html/clipbucket-v5/upload/includes/functions.php(1097): Language->getInstance()
#8 /var/www/html/clipbucket-v5/upload/includes/classes/collections.class.php(907): lang()
#9 /var/www/html/clipbucket-v5/upload/includes/classes/video.class.php(1237): Collections->__construct()
#10 /var/www/html/clipbucket-v5/upload/includes/classes/video.class.php(1057): CBvideo->init_collections()
#11 /var/www/html/clipbucket-v5/upload/includes/common.php(248): CBvideo->init()
#12 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#13 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [7] => Array
        (
            [q] => SELECT * FROM cb_plugins WHERE plugin_active='yes' 
            [timetook] => 0.00057697296142578
            [memBefore] => 1.7360076904297
            [memAfter] => 1.3342514038086
            [memUsed] => -0.40175628662109
            [use_cache] => yes
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(120): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(179): Clipbucket_db->_select()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/plugin.class.php(216): Clipbucket_db->select()
#4 /var/www/html/clipbucket-v5/upload/includes/plugins.php(3): CBPlugin->getInstalledPlugins()
#5 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(21): require_once()
#6 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [8] => Array
        (
            [q] => SELECT * FROM cb_languages WHERE language_default='yes'  
            [timetook] => 0.00045990943908691
            [memBefore] => 1.3342514038086
            [memAfter] => 1.364875793457
            [memUsed] => 0.030624389648438
            [use_cache] => yes
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(120): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(179): Clipbucket_db->_select()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/lang.class.php(318): Clipbucket_db->select()
#4 /var/www/html/clipbucket-v5/upload/includes/functions.php(1150): Language->getDefaultLanguage()
#5 /var/www/html/clipbucket-v5/upload/player/CB_video_js/cb_video_js.php(24): get_current_language()
#6 /var/www/html/clipbucket-v5/upload/player/CB_video_js/cb_video_js.php(124): CB_video_js->load_dependancies()
#7 /var/www/html/clipbucket-v5/upload/player/CB_video_js/cb_video_js.php(129): CB_video_js->__construct()
#8 /var/www/html/clipbucket-v5/upload/includes/plugins.php(35): include_once()
#9 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(21): require_once()
#10 /var/www/html/clipbucket-v5/upload/search_result.php(3): require_once()

        )

    [9] => Array
        (
            [q] => SELECT * FROM cb_tags_type WHERE name IN ('video','actors','producer','executive_producer','director','crew','genre') 
            [timetook] => 0.00040388107299805
            [memBefore] => 1.364875793457
            [memAfter] => 1.3865814208984
            [memUsed] => 0.021705627441406
            [use_cache] => yes
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(120): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(179): Clipbucket_db->_select()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/tags.class.php(329): Clipbucket_db->select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/tags.class.php(337): Tags->getTagTypes()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/video.class.php(435): Tags->getVideoTypes()
#6 /var/www/html/clipbucket-v5/upload/search_result.php(46): Video->getAll()

        )

    [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, video.default_poster, video.default_backdrop, video.fov, video.convert_percent, video.aspect_ratio, video.remote_play_url, users.username AS user_username, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 6 THEN tags.name END) SEPARATOR ',') AS tags_actors, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 10 THEN tags.name END) SEPARATOR ',') AS tags_crew, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 9 THEN tags.name END) SEPARATOR ',') AS tags_director, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 8 THEN tags.name END) SEPARATOR ',') AS tags_executive_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 11 THEN tags.name END) SEPARATOR ',') AS tags_genre, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 7 THEN tags.name END) SEPARATOR ',') AS tags_producer, GROUP_CONCAT( DISTINCT(CASE WHEN tags.id_tag_type = 1 THEN tags.name END) SEPARATOR ',') AS tags_video, GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category, GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ', ') AS category_names
                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 (MATCH(video.title) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) OR MATCH(video.description, video.title) AGAINST ('publishes' IN NATURAL LANGUAGE MODE)  OR LOWER(video.title) LIKE '%publishes%' OR MATCH(tags.name) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) OR LOWER(tags.name) LIKE '%publishes%' OR  lower(users.username) LIKE 'publishes' OR MATCH(categories.category_name) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) OR  LOWER(categories.category_name) LIKE '%publishes%' ) AND ( (video.active = 'yes' AND video.status = 'Successful' AND video.age_restriction IS NULL AND (video.broadcast = 'public'))) GROUP BY 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,video.default_poster,video.default_backdrop,video.fov,video.convert_percent,video.aspect_ratio,video.remote_play_url,users.username,video.videoid,video.videoid,video.title,video.description ORDER BY CASE WHEN LOWER(video.title) LIKE '%publishes%' THEN 100 ELSE MATCH(video.title) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) END DESC, MAX(CASE WHEN LOWER(tags.name) LIKE '%publishes%' THEN 100 ELSE MATCH(tags.name) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) END) DESC , MAX(CASE WHEN  lower(users.username) LIKE 'publishes' THEN 1 ELSE 0 END) DESC , MAX(CASE WHEN LOWER(video.title) LIKE '%publishes%' THEN 100 ELSE MATCH(categories.category_name) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) END) DESC , MATCH(video.description, video.title) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) DESC  LIMIT 0,28
            [timetook] => 0.51319909095764
            [memBefore] => 1.3865814208984
            [memAfter] => 1.4134292602539
            [memUsed] => 0.026847839355469
            [use_cache] => no
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(246): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/video.class.php(526): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/search_result.php(46): Video->getAll()

        )

    [11] => Array
        (
            [q] => SELECT COUNT(DISTINCT video.videoid) AS count
                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 (MATCH(video.title) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) OR MATCH(video.description, video.title) AGAINST ('publishes' IN NATURAL LANGUAGE MODE)  OR LOWER(video.title) LIKE '%publishes%' OR MATCH(tags.name) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) OR LOWER(tags.name) LIKE '%publishes%' OR  lower(users.username) LIKE 'publishes' OR MATCH(categories.category_name) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) OR  LOWER(categories.category_name) LIKE '%publishes%' ) AND ( (video.active = 'yes' AND video.status = 'Successful' AND video.age_restriction IS NULL AND (video.broadcast = 'public'))) ORDER BY CASE WHEN LOWER(video.title) LIKE '%publishes%' THEN 100 ELSE MATCH(video.title) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) END DESC, MAX(CASE WHEN LOWER(tags.name) LIKE '%publishes%' THEN 100 ELSE MATCH(tags.name) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) END) DESC , MAX(CASE WHEN  lower(users.username) LIKE 'publishes' THEN 1 ELSE 0 END) DESC , MAX(CASE WHEN LOWER(video.title) LIKE '%publishes%' THEN 100 ELSE MATCH(categories.category_name) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) END) DESC , MATCH(video.description, video.title) AGAINST ('publishes' IN NATURAL LANGUAGE MODE) DESC 
            [timetook] => 0.41996812820435
            [memBefore] => 1.4134292602539
            [memAfter] => 1.4055938720703
            [memUsed] => -0.0078353881835938
            [use_cache] => no
            [backtrace] => #1 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(246): devWitch()
#2 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(130): Clipbucket_db->execute()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/video.class.php(526): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/search_result.php(50): Video->getAll()

        )

)