Page Time: 0.0149s

Memory: 1.6846 MB (Peak: 5.8028 MB)

Queries (8, time: 0.0051s, 34.2%)

  1. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
    Run Time: 0.000290
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryALLPRIMARY   35Using where
  2. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000091
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  3. SELECT *
    FROM xf_search
    WHERE search_id = ?
    Params: 10109946
    Run Time: 0.000228
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table
  4. SELECT category_id
    FROM xengallery_category_map
    WHERE view_user_group_id IN (1)
    Run Time: 0.000057
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExengallery_category_mapindex PRIMARY8 13Using where; Using index
  5. SELECT media.*
    	,
    		album.*, albumviewperm.*,
    		category.*,
    		user.*, user_profile.*, IF(user.username IS NULL, media.username, user.username) AS username,
                        attachment.attachment_id, attachment.data_id, attachment.attach_date,data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
    FROM xengallery_media AS media
    	
    		LEFT JOIN xengallery_album AS album ON
    			(album.album_id = media.album_id)
    		LEFT JOIN xengallery_album_permission as albumviewperm ON
    			(album.album_id = albumviewperm.album_id AND albumviewperm.permission = 'view')
    		
    		LEFT JOIN xengallery_category AS category ON
    			(category.category_id = media.category_id)
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = media.user_id)
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = media.user_id)
                        LEFT JOIN xf_attachment AS attachment ON
                            (attachment.content_type = 'xengallery_media' AND attachment.attachment_id = media.attachment_id)
                        LEFT JOIN xf_attachment_data AS data ON
                            (data.data_id = attachment.data_id)
    	WHERE (
    			
    			media.media_privacy = 'public'
    			OR IF(media.category_id > 0, media.category_id IN (1), NULL)) AND (media.media_state IN ('visible')) AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
    	ORDER BY media.media_date DESC, media.media_id DESC			
     LIMIT 200
    Run Time: 0.002142
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEmediaALL    17Using where; Using temporary; Using filesort
    SIMPLEalbumALLPRIMARY   2Using where; Using join buffer (Block Nested Loop)
    SIMPLEalbumviewpermeq_refPRIMARYPRIMARY5film_xf.album.album_id,const1 
    SIMPLEcategoryALLPRIMARY   2Using where; Using join buffer (Block Nested Loop)
    SIMPLEusereq_refPRIMARYPRIMARY4film_xf.media.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4film_xf.media.user_id1 
    SIMPLEattachmenteq_refPRIMARY,content_type_id_datePRIMARY4film_xf.media.attachment_id1Using where
    SIMPLEdataeq_refPRIMARYPRIMARY4film_xf.attachment.data_id1 
  6. SELECT media.*
    	,
    		album.*, albumviewperm.*,
    		category.*,
    		user.*, user_profile.*, IF(user.username IS NULL, media.username, user.username) AS username,
                        attachment.attachment_id, attachment.data_id, attachment.attach_date,data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
    FROM xengallery_media AS media
    	
    		LEFT JOIN xengallery_album AS album ON
    			(album.album_id = media.album_id)
    		LEFT JOIN xengallery_album_permission as albumviewperm ON
    			(album.album_id = albumviewperm.album_id AND albumviewperm.permission = 'view')
    		
    		LEFT JOIN xengallery_category AS category ON
    			(category.category_id = media.category_id)
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = media.user_id)
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = media.user_id)
                        LEFT JOIN xf_attachment AS attachment ON
                            (attachment.content_type = 'xengallery_media' AND attachment.attachment_id = media.attachment_id)
                        LEFT JOIN xf_attachment_data AS data ON
                            (data.data_id = attachment.data_id)
    	WHERE (media.media_id IN (17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
    Run Time: 0.001529
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEmediarangePRIMARYPRIMARY4 16Using where
    SIMPLEalbumALLPRIMARY   2Using where; Using join buffer (Block Nested Loop)
    SIMPLEalbumviewpermeq_refPRIMARYPRIMARY5film_xf.album.album_id,const1 
    SIMPLEcategoryALLPRIMARY   2Using where; Using join buffer (Block Nested Loop)
    SIMPLEusereq_refPRIMARYPRIMARY4film_xf.media.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4film_xf.media.user_id1 
    SIMPLEattachmenteq_refPRIMARY,content_type_id_datePRIMARY4film_xf.media.attachment_id1Using where
    SIMPLEdataeq_refPRIMARYPRIMARY4film_xf.attachment.data_id1 
  7. INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    Params: [["xengallery_media",17],["xengallery_media",16],["xengallery_media",15],["xengallery_media",14],["xengallery_media",13],["xengallery_media",12],["xengallery_media",11],["xengallery_media",10],["xengallery_media",9],["xengallery_media",8],["xengallery_media",7],["xengallery_media",6],["xengallery_media",5],["xengallery_media",4],["xengallery_media",3],["xengallery_media",2]], 16, xengallery_media, , ["findNew"], date, 0, , [], 0, 1563554397, 36479db84cc074f46b51a4d21e63f89a
    Run Time: 0.000294
  8. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: 6e66adb5064ee853bf3544a208404b85, , 1563557997
    Run Time: 0.000477

Included Files (70, XenForo Classes: 39)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Db.php
  19. library/Zend/Db/Adapter/Mysqli.php
  20. library/Zend/Db/Adapter/Abstract.php
  21. library/Zend/Db/Select.php
  22. library/Zend/Db/Expr.php
  23. library/Zend/Db/Profiler.php
  24. library/Zend/Db/Statement/Mysqli.php
  25. library/Zend/Db/Statement.php
  26. library/Zend/Db/Statement/Interface.php
  27. library/Zend/Db/Profiler/Query.php
  28. library/XenForo/CodeEvent.php
  29. library/XenForo/Options.php
  30. library/XenForo/Link.php
  31. library/XenForo/Template/Helper/Core.php
  32. library/CTA/FeaturedThreads/Listener.php
  33. library/XenGallery/Listener.php
  34. library/XenForo/Router.php
  35. library/XenForo/Route/Filter.php
  36. library/XenForo/Route/Interface.php
  37. library/XenForo/Route/ResponseSuffix.php
  38. library/XenForo/Route/Prefix.php
  39. library/XenForo/Route/Prefix/FindNew.php
  40. library/XenForo/RouteMatch.php
  41. library/XenForo/ControllerPublic/FindNew.php
  42. library/XenForo/ControllerPublic/Abstract.php
  43. library/XenForo/Controller.php
  44. library/XI/Tag/CodeEvent/Listener.php
  45. library/SocialConnect/Listener.php
  46. library/CTA/FeaturedThreads/ControllerPublic/FindNew.php
  47. library/XenGallery/ControllerPublic/FindNew.php
  48. library/XenForo/Input.php
  49. library/XenForo/Session.php
  50. library/XenForo/Helper/Ip.php
  51. library/XenForo/Visitor.php
  52. library/XenForo/Model/User.php
  53. library/FS/Events/CodeEvent/Listener.php
  54. library/FS/Events/Model/User.php
  55. library/XenGallery/Model/User.php
  56. library/XenForo/Permission.php
  57. library/XenForo/Phrase.php
  58. library/XenForo/Locale.php
  59. library/XenGallery/Model/Media.php
  60. library/XenForo/Model/Search.php
  61. library/XenGallery/Model/Category.php
  62. library/XenForo/Model/Attachment.php
  63. library/XenForo/ControllerResponse/Redirect.php
  64. library/XenForo/ControllerResponse/Abstract.php
  65. library/XenForo/Helper/Cookie.php
  66. library/XenForo/ViewRenderer/HtmlPublic.php
  67. library/XenForo/ViewRenderer/Abstract.php
  68. library/XenForo/Template/Public.php
  69. library/XenForo/Template/Abstract.php
  70. library/XenForo/Debug.php