Quicklists (0)

logo

  • Videos
  • Photos
  • Channels
  • Collections
  • Channels
  • Collections
  • Photos
  • Videos
  • Login


Loading

Most Recent
  • Most Recent
  • Most Old
  • Most items
  • Most Comments
  • Top Rated
  • Featured
  • Alpbabetical
  • Reverse alpbabetical
All Time
  • All Time
  • Today
  • Yesterday
  • This Week
  • Last Week
  • This Month
  • Last Month
  • This Year
  • Last Year
No results found
  • About Us
  • Terms of service
  • Help
  • English
  • Français
  • Deutsche
  • Portuguesa
  • Español
©ClipBucket, maintained by Oxygenz
close

Select Queries (15)

Array
(
    [0] => Array
        (
            [q] => SELECT * FROM cb_config
            [timetook] => 0.0017728805541992
            [memBefore] => 0.5189208984375
            [memAfter] => 0.56118011474609
            [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/collections.php(5): require()

        )

    [1] => Array
        (
            [q] => SELECT * FROM cb_sessions WHERE session ='puuuma09e3m2pthelnd08vpu4h'  
            [timetook] => 0.00097393989562988
            [memBefore] => 0.56118011474609
            [memAfter] => 0.83879852294922
            [memUsed] => 0.27761840820312
            [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(5322): 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(503): 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/collections.php(5): require()

        )

    [2] => Array
        (
            [q] => SELECT * FROM cb_sessions WHERE  session_string='guest' AND  session ='puuuma09e3m2pthelnd08vpu4h'  
            [timetook] => 0.00060486793518066
            [memBefore] => 0.82781982421875
            [memAfter] => 0.84450531005859
            [memUsed] => 0.016685485839844
            [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(5329): 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(503): 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/collections.php(5): require()

        )

    [3] => Array
        (
            [q] => SELECT version.id, version.version, version.revision FROM cb_version AS version 
            [timetook] => 0.00058102607727051
            [memBefore] => 0.84450531005859
            [memAfter] => 0.83221435546875
            [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(503): 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/collections.php(5): require()

        )

    [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.0010738372802734
            [memBefore] => 0.83221435546875
            [memAfter] => 0.85649871826172
            [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(503): 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/collections.php(5): require()

        )

    [5] => Array
        (
            [q] => SELECT * FROM cb_languages WHERE language_default='yes'  
            [timetook] => 0.00045394897460938
            [memBefore] => 0.85649871826172
            [memAfter] => 0.94446563720703
            [memUsed] => 0.087966918945312
            [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(1096): Language->getInstance()
#7 /var/www/html/clipbucket-v5/upload/includes/classes/collections.class.php(903): lang()
#8 /var/www/html/clipbucket-v5/upload/includes/classes/photos.class.php(842): Collections->__construct()
#9 /var/www/html/clipbucket-v5/upload/includes/classes/photos.class.php(798): CBPhotos->init_collections()
#10 /var/www/html/clipbucket-v5/upload/includes/common.php(248): CBPhotos->init_photos()
#11 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#12 /var/www/html/clipbucket-v5/upload/collections.php(5): require()

        )

    [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.006242036819458
            [memBefore] => 0.94446563720703
            [memAfter] => 1.7385025024414
            [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(1096): Language->getInstance()
#8 /var/www/html/clipbucket-v5/upload/includes/classes/collections.class.php(903): lang()
#9 /var/www/html/clipbucket-v5/upload/includes/classes/photos.class.php(842): Collections->__construct()
#10 /var/www/html/clipbucket-v5/upload/includes/classes/photos.class.php(798): CBPhotos->init_collections()
#11 /var/www/html/clipbucket-v5/upload/includes/common.php(248): CBPhotos->init_photos()
#12 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#13 /var/www/html/clipbucket-v5/upload/collections.php(5): require()

        )

    [7] => Array
        (
            [q] => SELECT * FROM cb_plugins WHERE plugin_active='yes' 
            [timetook] => 0.00048112869262695
            [memBefore] => 1.7385025024414
            [memAfter] => 1.334587097168
            [memUsed] => -0.40391540527344
            [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/collections.php(5): require()

        )

    [8] => Array
        (
            [q] => SELECT * FROM cb_languages WHERE language_default='yes'  
            [timetook] => 0.00044608116149902
            [memBefore] => 1.334587097168
            [memAfter] => 1.3652114868164
            [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(1149): 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/collections.php(5): require()

        )

    [9] => Array
        (
            [q] => SELECT id_category_type, name FROM cb_categories_type AS categories_type
            [timetook] => 0.00061297416687012
            [memBefore] => 1.3652114868164
            [memAfter] => 1.3865966796875
            [memUsed] => 0.021385192871094
            [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/category.class.php(169): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/category.class.php(37): Category->getAllCategoryTypes()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/category.class.php(43): Category->__construct()
#6 /var/www/html/clipbucket-v5/upload/collections.php(13): Category->getInstance()

        )

    [10] => Array
        (
            [q] => SELECT categories.category_id, categories.parent_id, categories.id_category_type, categories.category_name, categories.category_order, categories.category_desc, categories.date_added, categories.category_thumb, categories.is_default
                FROM cb_categories AS categories  WHERE parent_id = 1 ORDER BY category_order ASC 
            [timetook] => 0.00074005126953125
            [memBefore] => 1.3865966796875
            [memAfter] => 1.3900985717773
            [memUsed] => 0.0035018920898438
            [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/category.class.php(132): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/category.class.php(430): Category->getAll()
#5 /var/www/html/clipbucket-v5/upload/collections.php(13): Category->getChildren()

        )

    [11] => Array
        (
            [q] => SELECT collections.collection_id
, collections.collection_name
, collections.collection_description
, collections.userid
, collections.date_added
, collections.featured
, collections.broadcast
, collections.allow_comments
, collections.allow_rating
, collections.total_comments
, collections.last_commented
, collections.rating
, collections.rated_by
, collections.voters
, collections.active
, collections.public_upload
, collections.type
, collections.collection_id_parent
, collections.thumb_objectid
, collections.sort_type
, users.username AS user_username, users.email, users.dob
, collection_parent.collection_name AS collection_name_parent
, COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) + COUNT(DISTINCT(collections_enfant.collection_id)) AS total_objects
,  sorts.label as sort_type_label 
,  sorts.id as sort_type 
, GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags
, GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category
, GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names
                FROM cb_collections AS collections
                LEFT JOIN cb_users AS users ON collections.userid = users.userid
                LEFT JOIN cb_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
                LEFT JOIN cb_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND video.age_restriction IS NULL AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = ''))))
                LEFT JOIN cb_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND photos.age_restriction IS NULL AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL )  LEFT JOIN cb_collections collection_parent ON collections.collection_id_parent = collection_parent.collection_id
LEFT JOIN cb_sorts AS sorts ON sorts.id = collections.sort_type
LEFT JOIN cb_collections AS collections_enfant ON collections.collection_id = collections_enfant.collection_id_parent
LEFT JOIN cb_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection
LEFT JOIN cb_tags AS tags ON collection_tags.id_tag = tags.id_tag
LEFT JOIN cb_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection
LEFT JOIN cb_categories AS categories ON collections_categories.id_category = categories.category_id WHERE ( collections.date_added IS NOT NULL )
 AND collections.collection_id_parent IS NULL
 AND ((collections.active = 'yes' AND collections.broadcast = 'public'))
 AND categories.category_id IN (1)
 GROUP BY collections.collection_id ORDER BY collections.date_added DESC LIMIT 0,30
            [timetook] => 0.004971981048584
            [memBefore] => 1.3900985717773
            [memAfter] => 1.4023895263672
            [memUsed] => 0.012290954589844
            [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/collections.class.php(459): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/collections.php(29): Collection->getAll()

        )

    [12] => Array
        (
            [q] => SELECT collections.collection_id
, collections.collection_name
, collections.collection_description
, collections.userid
, collections.date_added
, collections.featured
, collections.broadcast
, collections.allow_comments
, collections.allow_rating
, collections.total_comments
, collections.last_commented
, collections.rating
, collections.rated_by
, collections.voters
, collections.active
, collections.public_upload
, collections.type
, collections.collection_id_parent
, collections.thumb_objectid
, collections.sort_type
, users.username AS user_username, users.email, users.dob
, collection_parent.collection_name AS collection_name_parent
, COUNT( DISTINCT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END)) + COUNT(DISTINCT(collections_enfant.collection_id)) AS total_objects
,  sorts.label as sort_type_label 
,  sorts.id as sort_type 
, GROUP_CONCAT( DISTINCT(tags.name) SEPARATOR ',') AS tags
, GROUP_CONCAT( DISTINCT(categories.category_id) SEPARATOR ',') AS category
, GROUP_CONCAT( DISTINCT(categories.category_name) SEPARATOR ',') AS category_names
                FROM cb_collections AS collections
                LEFT JOIN cb_users AS users ON collections.userid = users.userid
                LEFT JOIN cb_collection_items AS collection_items ON collections.collection_id = collection_items.collection_id
                LEFT JOIN cb_video AS video ON collections.type = 'videos' AND collection_items.object_id = video.videoid AND ( (video.active = 'yes' AND video.status = 'Successful' AND video.age_restriction IS NULL AND (video.broadcast = 'public' OR (video.broadcast = 'unlisted' AND video.video_password = ''))))
                LEFT JOIN cb_photos AS photos ON collections.type = 'photos' AND collection_items.object_id = photos.photo_id AND (((photos.active = 'yes' AND photos.age_restriction IS NULL AND (photos.broadcast = 'public' OR (photos.broadcast = 'unlisted')))) AND collection_items.collection_id IS NOT NULL )  LEFT JOIN cb_collections collection_parent ON collections.collection_id_parent = collection_parent.collection_id
LEFT JOIN cb_sorts AS sorts ON sorts.id = collections.sort_type
LEFT JOIN cb_collections AS collections_enfant ON collections.collection_id = collections_enfant.collection_id_parent
LEFT JOIN cb_collection_tags AS collection_tags ON collections.collection_id = collection_tags.id_collection
LEFT JOIN cb_tags AS tags ON collection_tags.id_tag = tags.id_tag
LEFT JOIN cb_collections_categories AS collections_categories ON collections.collection_id = collections_categories.id_collection
LEFT JOIN cb_categories AS categories ON collections_categories.id_category = categories.category_id WHERE collections.collection_id_parent IS NULL
 AND ((collections.active = 'yes' AND collections.broadcast = 'public'))
 GROUP BY collections.collection_id ORDER BY COUNT(CASE WHEN collections.type = 'videos' THEN video.videoid ELSE photos.photo_id END) DESC LIMIT 4
            [timetook] => 0.0042850971221924
            [memBefore] => 1.4023895263672
            [memAfter] => 1.4060134887695
            [memUsed] => 0.0036239624023438
            [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/collections.class.php(459): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/collections.php(37): Collection->getAll()

        )

    [13] => Array
        (
            [q] => SELECT id, label, type, is_default FROM cb_sorts WHERE type = 'collections'
            [timetook] => 0.00093984603881836
            [memBefore] => 1.4060134887695
            [memAfter] => 1.4020385742188
            [memUsed] => -0.0039749145507812
            [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/sort_type.class.php(16): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/collections.class.php(202): SortType->getSortTypes()
#5 /var/www/html/clipbucket-v5/upload/collections.php(40): Collection->getSortList()

        )

    [14] => Array
        (
            [q] => SELECT id, label, type, is_default FROM cb_sorts WHERE is_default = TRUE AND type = 'collections'
            [timetook] => 0.00073599815368652
            [memBefore] => 1.4020385742188
            [memAfter] => 1.4031524658203
            [memUsed] => 0.0011138916015625
            [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/sort_type.class.php(42): Clipbucket_db->_select()
#4 /var/www/html/clipbucket-v5/upload/collections.php(41): SortType->getDefaultByType()

        )

)

Update Queries (1)

Array
(
    [0] => Array
        (
            [q] => UPDATE cb_sessions SET last_active='2025-05-11 17:34:45',current_page='http://yourtop.news/collections.php?cat=1&time=all_time' WHERE  session='puuuma09e3m2pthelnd08vpu4h'  
            [timetook] => 0.00059008598327637
            [memBefore] => 0.83879852294922
            [memAfter] => 0.82781982421875
            [memUsed] => -0.010978698730469
            [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(336): Clipbucket_db->execute()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/session.class.php(105): Clipbucket_db->update()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(5322): Session->get_sessions()
#5 /var/www/html/clipbucket-v5/upload/includes/classes/user.class.php(986): userquery->get_sessions()
#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(503): 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/collections.php(5): require()

        )

)

Delete Queries(0)

Sorry Ninja, nothing to show here

Insert Queries(0)

Sorry Ninja, nothing to show here

Execute Query(1)

Array
(
    [0] => Array
        (
            [q] => SET NAMES "utf8mb4"
            [timetook] => 0.00044083595275879
            [memBefore] => 0
            [memAfter] => 0.5189208984375
            [memUsed] => 0.5189208984375
            [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(82): Clipbucket_db->execute()
#3 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(29): Clipbucket_db->connect()
#4 /var/www/html/clipbucket-v5/upload/includes/classes/db.class.php(19): Clipbucket_db->__construct()
#5 /var/www/html/clipbucket-v5/upload/includes/functions_db.php(10): Clipbucket_db->getInstance()
#6 /var/www/html/clipbucket-v5/upload/includes/classes/my_queries.class.php(36): db_select()
#7 /var/www/html/clipbucket-v5/upload/includes/common.php(101): myquery->Get_Website_Details()
#8 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#9 /var/www/html/clipbucket-v5/upload/collections.php(5): require()

        )

)

Expensive Queries(0.79403686523438)

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.006242036819458
    [memBefore] => 0.94446563720703
    [memAfter] => 1.7385025024414
    [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(1096): Language->getInstance()
#8 /var/www/html/clipbucket-v5/upload/includes/classes/collections.class.php(903): lang()
#9 /var/www/html/clipbucket-v5/upload/includes/classes/photos.class.php(842): Collections->__construct()
#10 /var/www/html/clipbucket-v5/upload/includes/classes/photos.class.php(798): CBPhotos->init_collections()
#11 /var/www/html/clipbucket-v5/upload/includes/common.php(248): CBPhotos->init_photos()
#12 /var/www/html/clipbucket-v5/upload/includes/config.inc.php(9): require_once()
#13 /var/www/html/clipbucket-v5/upload/collections.php(5): require()

)

Cheapest Queries(-0.40391540527344)

Array
(
    [q] => SELECT * FROM cb_plugins WHERE plugin_active='yes' 
    [timetook] => 0.00048112869262695
    [memBefore] => 1.7385025024414
    [memAfter] => 1.334587097168
    [memUsed] => -0.40391540527344
    [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/collections.php(5): require()

)

Overall Stats

  • Queries (12)
    • Insert : 0
    • Select : 15
    • Update : 1
    • Delete : 0
    • Count : 0
    • Execute : 1
  • Total DB Queries : 12
  • Total cache Queries : 5
  • Total Execution Time : 0.025946617126465
  • Total Memory Used : 1.4031524658203
  • Base directory : /var/www/html/clipbucket-v5/upload/