J! InfoRequestSessionProfileQueries58Log
11.574MBMemory Usage302msRequest Duration
Joomla! Version5.2.2
PHP Version8.1.32
Identityguest
Response200
Templatej-directory
Database
Server
mysql
Version
10.6.22-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:2 [ "claim_listing_id" => "15521" "Itemid" => "694" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "7446a39c0487e807b461c8b1a207dfa7" => "713bd7208a8d576cc2dbfe1da5e2bd4b" ]
$_SERVER
array:57 [ "CONTEXT_DOCUMENT_ROOT" => "/home/nicklesu/public_html/usbreweryguide.com" "CONTEXT_P...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1747671214 "last" => 1747671214...
registry
array:3 [ "data" => array:1 [ "com_jbusinessdirectory" => array:1 [ "listing" => array:1...
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
menuId
931
categorySearch
null
searchkeyword
""
searchkeywordLocation
""
typeSearch
""
citySearch
""
starRating
""
regionSearch
""
countrySearch
""
zipcode
""
customAtrributes
""
letter
""
radius
100
provinceSearch
""
areaSearch
""
filter-by-fav
""
filterParams
""
location
""
geo-latitude
""
geo-longitude
""
geo-country
""
geolocation
""
location-detected
""
categories
""
onlyLocal
0
categoryId
219
listing-search
true
menuItemId
931
showCustomMarkers
1
moreFilters
null
lSearchType
1
  • afterLoad (414.6KB) (53.84ms)
  • afterInitialise (3.83MB) (136ms)
  • afterRoute (943.52KB) (14.5ms)
  • beforeRenderComponent com_jbusinessdirectory (48.46KB) (564μs)
  • afterRenderComponent com_jbusinessdirectory (1.65MB) (41.81ms)
  • afterDispatch (3.3KB) (959μs)
  • beforeRenderRawModule mod_menu (Main Menu) (655.91KB) (37.73ms)
  • afterRenderRawModule mod_menu (Main Menu) (117KB) (2.47ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (4μs)
  • afterRenderModule mod_menu (Main Menu) (114.59KB) (2.02ms)
  • afterRender (178.71KB) (11.09ms)
  • 1 x afterInitialise (3.83MB) (45.12%)
    136ms
    1 x afterLoad (414.6KB) (17.81%)
    53.84ms
    1 x afterRenderComponent com_jbusinessdirectory (1.65MB) (13.83%)
    41.81ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (655.91KB) (12.48%)
    37.73ms
    1 x afterRoute (943.52KB) (4.8%)
    14.50ms
    1 x afterRender (178.71KB) (3.67%)
    11.09ms
    1 x afterRenderRawModule mod_menu (Main Menu) (117KB) (0.82%)
    2.47ms
    1 x afterRenderModule mod_menu (Main Menu) (114.59KB) (0.67%)
    2.02ms
    1 x afterDispatch (3.3KB) (0.32%)
    959μs
    1 x beforeRenderComponent com_jbusinessdirectory (48.46KB) (0.19%)
    564μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    4μs
58 statements were executed, 34 of which were duplicates, 24 unique10.82ms1.31MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4
  • SELECT @@SESSION.sql_mode;68μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `brew_session` WHERE `session_id` = ?122μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 188μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `brew_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id92μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `brew_viewlevels`69μs1.52KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `brew_usergroups` AS `a` LEFT JOIN `brew_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest111μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'126μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`59μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'182μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'181μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM `brew_admintools_ipautoban`399μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
  • SELECT `ip` FROM `brew_admintools_ipblock`72μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
  • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'82μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC94μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas234μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_date_formats fas WHERE fas.id ='3'100μs1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_currencies fas WHERE fas.currency_id ='143'56μs3.5KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'businessuser' LIMIT 1127μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'businessuser' LIMIT 1213μs20.77KB/plugins/system/urltranslator/jbdrouter.php:181Copy
  • SELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application` FROM `brew_admintools_wafblacklists` WHERE `enabled` = 177μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'104μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'businessuser' LIMIT 1112μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'businessuser' LIMIT 1202μs20.77KB/plugins/system/urltranslator/jbdrouter.php:181Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'167μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM brew_fields AS a LEFT JOIN `brew_languages` AS l ON l.lang_code = a.language LEFT JOIN brew_users AS uc ON uc.id=a.checked_out LEFT JOIN brew_viewlevels AS ag ON ag.id = a.access LEFT JOIN brew_users AS ua ON ua.id = a.created_user_id LEFT JOIN brew_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC485μs5.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`365μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SET SESSION group_concat_max_len = 1000020μs0B/components/com_jbusinessdirectory/helpers/utils.php:6887Copy
  • select bc.*, GROUP_CONCAT(DISTINCT ct.name separator ', ') as typeName, GROUP_CONCAT(DISTINCT ct.company_view separator ',') as companyView, cr.country_name, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',IFNULL(cg.icon,''),'|', IFNULL(cg.color,'') ORDER BY cg.lft separator '#|') as categories, cr.country_name,GROUP_CONCAT( DISTINCT cpt.picture_path) as pictures, ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId from brew_jbusinessdirectory_companies bc left join brew_jbusinessdirectory_company_types ct on find_in_set(ct.id,bc.typeId) left join brew_jbusinessdirectory_company_category cc on bc.id=cc.companyId left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId left join brew_jbusinessdirectory_categories ccm on ccm.id=bc.mainSubcategory and ccm.published=1 left join brew_jbusinessdirectory_countries as cr on cr.id = bc.countryId left join brew_jbusinessdirectory_company_pictures cpt on cpt.companyId=bc.id and cpt.picture_enable = 1 where bc.id=15521 group by bc.id order by name431μs21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'144μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'80μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'82μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'75μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'148μs52.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'100μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'115μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'88μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'77μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'79μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'89μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'78μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'90μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'77μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'75μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'75μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'103μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'75μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'74μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'72μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'110μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'84μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'76μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'78μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'76μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `brew_scheduler_tasks` AS `a` WHERE `a`.`state` = 1113μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'criticalfiles'64μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'96μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = ?115μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `brew_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?3.77ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy