Page Time: 0.0396s

Memory: 3.7589 MB (Peak: 4.8232 MB)

Queries (21, time: 0.0228s, 57.7%)

  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.000873
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY27 26Using where
  2. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000186
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  3. SELECT tag_id
    FROM xf_tag
    WHERE use_count >= ?
    ORDER BY use_count DESC
     LIMIT 100
    Params: 1
    Run Time: 0.000788
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_tagrangeuse_countuse_count4 1280Using where; Using index
  4. SELECT *
    FROM xf_tag
    WHERE tag_id IN (86, 70, 255, 163, 75, 66, 84, 74, 3, 439, 165, 111, 170, 606, 489, 179, 149, 491, 130, 107, 423, 97, 1276, 922, 333, 256, 246, 177, 46, 805, 796, 307, 273, 254, 220, 152, 95, 72, 39, 941, 790, 743, 686, 667, 659, 583, 344, 224, 214, 210, 201, 188, 98, 76, 50, 11, 1904, 1901, 692, 671, 664, 560, 490, 486, 477, 454, 442, 437, 436, 433, 424, 417, 415, 390, 371, 356, 334, 329, 318, 297, 260, 259, 180, 176, 121, 115, 54, 44, 1275, 1090, 1089, 1088, 1087, 995, 869, 809, 799, 778, 728, 685)
    ORDER BY tag
    Run Time: 0.000938
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_tagrangePRIMARYPRIMARY4 100Using where; Using filesort
  5. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: 7c814debcb4629f8014e72f24b158842, , 1627262458
    Run Time: 0.000204
  6. INSERT INTO xf_session_activity
    	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
    VALUES
    	(?, ?, ?, ?, ?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE
    	ip = VALUES(ip),
    	controller_name = VALUES(controller_name),
    	controller_action = VALUES(controller_action),
    	view_state = VALUES(view_state),
    	params = VALUES(params),
    	view_date = VALUES(view_date),
    	robot_key = VALUES(robot_key)
    Params: 0, , , XenForo_ControllerPublic_Tag, Index, valid, , 1627258858,
    Run Time: 0.000175
  7. SELECT data_value
    FROM xf_data_registry
    WHERE data_key = ?
    Params: uix_nodeCache
    Run Time: 0.000179
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  8. SELECT *
    FROM uix_node_layout
    Run Time: 0.000148
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEuix_node_layoutALL    2 
  9. SELECT node.*,
    	node_field.uix_node_icons,
    	node_field.uix_styling,
    	node_field.collapsed,
    	node_field.inheritClass,
    	node_field.inheritStyling
    FROM xf_node AS node
    LEFT JOIN uix_node_fields AS node_field ON (node.node_id = node_field.node_id)
    Run Time: 0.000323
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeALL    22 
    SIMPLEnode_fieldeq_refPRIMARYPRIMARY4degreeinfo_xenforo.node.node_id1 
  10. SELECT advertisement.*
    	,
    		zone.*,
    		zone.name AS zone_name,
    		user.*, IF(user.user_id IS NULL, advertisement.user_id, user.user_id) AS user_id,
    		purchase.*,
    			IF(user.user_id IS NULL, purchase.user_id, user.user_id) AS user_id
    FROM admon_advertisement AS advertisement
    	
    		LEFT JOIN admon_advertisement_zone AS zone ON
    			(zone.zone_id = advertisement.advertisement_zone)
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = advertisement.user_id)
    		LEFT JOIN admon_advertisement_purchase AS purchase ON
    			(purchase.purchase_id = advertisement.purchase_id)
    WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1627258858 AND advertisement.end_date > 1627258858))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
    Run Time: 0.000615
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    17Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52degreeinfo_xenforo.advertisement.advertisement_zone1Using where
    SIMPLEusereq_refPRIMARYPRIMARY4degreeinfo_xenforo.advertisement.user_id1 
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4degreeinfo_xenforo.advertisement.purchase_id1 
  11. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('page_nav', 'tag_search', 'PAGE_CONTAINER')
    	AND style_id = ?
    	AND language_id = ?
    Params: 1, 1
    Run Time: 0.000394
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 3Using where
  12. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('admon_active')
    Params: 1
    Run Time: 0.000142
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 
  13. SELECT advertisement.*
    	
    FROM admon_advertisement AS advertisement
    	
    WHERE advertisement.advertisement_id=?
    Params: quinstreet_banner
    Run Time: 0.000354
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementconstadvertisement_id_2,advertisement_idadvertisement_id_252const1 
  14. begin
    Run Time: 0.000115
  15. UPDATE `admon_advertisement` SET `impressions` = ?, `last_modified` = ? WHERE (advertisement_id = 'quinstreet_banner')
    Params: 67668332, 1627258858
    Run Time: 0.000221
  16. commit
    Run Time: 0.000631
  17. SELECT *
    FROM admon_statistic
    WHERE statistic_date=?
    	AND statistic_type=?
    	AND statistic_data=?
    	AND advertisement_id=?
    Params: 1627257600, impression, , quinstreet_banner
    Run Time: 0.015531
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadmon_statisticALL    31663Using where
  18. SELECT *
    FROM admon_statistic
    WHERE statistic_id=?
    Params: 32398
    Run Time: 0.000225
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadmon_statisticconstPRIMARYPRIMARY4const1 
  19. begin
    Run Time: 0.000127
  20. UPDATE `admon_statistic` SET `statistic_value` = ? WHERE (statistic_id = 32398)
    Params: 1224
    Run Time: 0.000142
  21. commit
    Run Time: 0.000506

Included Files (85, XenForo Classes: 48)

  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/Audentio/AdManager/Listener/CodeEvent.php
  33. library/Audentio/UIX/Listener/CodeEvent.php
  34. library/Audentio/UIX/vendor/autoload.php
  35. library/Audentio/UIX/vendor/composer/autoload_real.php
  36. library/Audentio/UIX/vendor/composer/ClassLoader.php
  37. library/Audentio/UIX/vendor/composer/autoload_namespaces.php
  38. library/Audentio/UIX/vendor/composer/autoload_psr4.php
  39. library/Audentio/UIX/vendor/composer/autoload_classmap.php
  40. library/XenForo/Router.php
  41. library/XenForo/Route/Filter.php
  42. library/XenForo/Route/Interface.php
  43. library/XenForo/Route/ResponseSuffix.php
  44. library/XenForo/Route/Prefix.php
  45. library/XenForo/Route/Prefix/Tags.php
  46. library/XenForo/RouteMatch.php
  47. library/XenForo/ControllerPublic/Tag.php
  48. library/XenForo/ControllerPublic/Abstract.php
  49. library/XenForo/Controller.php
  50. library/XenForo/Input.php
  51. library/XenForo/Session.php
  52. library/XenForo/Helper/Ip.php
  53. library/XenForo/Visitor.php
  54. library/XenForo/Model/User.php
  55. library/Audentio/UIX/Model/User.php
  56. library/XenForo/Permission.php
  57. library/XenForo/Helper/Php.php
  58. library/XenForo/Phrase.php
  59. library/XenForo/Locale.php
  60. library/XenForo/Model/Tag.php
  61. library/XenForo/ControllerResponse/View.php
  62. library/XenForo/ControllerResponse/Abstract.php
  63. library/XenForo/Helper/Cookie.php
  64. library/XenForo/ViewRenderer/HtmlPublic.php
  65. library/XenForo/ViewRenderer/Abstract.php
  66. library/XenForo/Template/Public.php
  67. library/XenForo/Template/Abstract.php
  68. library/XenForo/ViewPublic/Base.php
  69. library/XenForo/View.php
  70. library/XenForo/Model/Node.php
  71. library/Audentio/UIX/Model/Node.php
  72. library/Audentio/UIX/Model/NodeLayout.php
  73. library/Audentio/AdManager/Model/Advertisement.php
  74. library/XenForo/Route/Prefix/Members.php
  75. library/XenForo/Model/StyleProperty.php
  76. library/XenForo/Helper/Criteria.php
  77. library/Audentio/AdManager/Route/Prefix/Funbox.php
  78. library/XenForo/Debug.php
  79. library/Audentio/AdManager/Template/Helper/Core.php
  80. library/XenForo/DataWriter.php
  81. library/Audentio/AdManager/DataWriter/Advertisement.php
  82. library/XenForo/Db.php
  83. library/Audentio/AdManager/Model/Statistic.php
  84. library/Audentio/AdManager/DataWriter/Statistic.php
  85. library/XenForo/ViewRenderer/Json.php