1264

John Harvards Brew House

1 Worcester Road, Framingham, Massachusetts 01701
Massachusetts Breweries
|

Business Details

Type:
Brewpub

Map Location

Map Directions
Marker
Leaflet © OpenStreetMap contributors

Claim Business

Claim listing is the best way to manage and protect your business.

Claim Business
company map
1 Worcester Road, Framingham, Massachusetts 01701
J! InfoRequestSessionProfileQueries122Log
13.25MBMemory Usage412msRequest Duration
Joomla! Version5.2.2
PHP Version8.1.32
Identityguest
Response200
Templatej-directory
Database
Server
mysql
Version
10.6.21-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:55 [ "CONTEXT_DOCUMENT_ROOT" => "/home/nicklesu/public_html/usbreweryguide.com" "CONTEXT_P...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745527760 "last" => 1745527760...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
menuId
799
company_yelp_id
""
  • afterLoad (414.6KB) (80.8ms)
  • afterInitialise (3.8MB) (143ms)
  • afterRoute (955.89KB) (16.87ms)
  • beforeRenderComponent com_jbusinessdirectory (48.53KB) (644μs)
  • Before Access::preloadComponents (all components) (2.74MB) (84.21ms)
  • After Access::preloadComponents (all components) (171.05KB) (684μs)
  • Before Access::getAssetRules (id:1 name:root.1) (2.45KB) (12μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.58KB) (502μs)
  • afterRenderComponent com_jbusinessdirectory (435.03KB) (13.26ms)
  • afterDispatch (2.91KB) (1.08ms)
  • beforeRenderRawModule mod_menu (Main Menu) (631.09KB) (45.77ms)
  • afterRenderRawModule mod_menu (Main Menu) (118.14KB) (3.16ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Main Menu) (49.97KB) (2.61ms)
  • afterRender (207.82KB) (18.38ms)
  • 1 x afterInitialise (3.8MB) (34.72%)
    143ms
    1 x Before Access::preloadComponents (all components) (2.74MB) (20.44%)
    84.21ms
    1 x afterLoad (414.6KB) (19.61%)
    80.80ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (631.09KB) (11.11%)
    45.77ms
    1 x afterRender (207.82KB) (4.46%)
    18.38ms
    1 x afterRoute (955.89KB) (4.1%)
    16.87ms
    1 x afterRenderComponent com_jbusinessdirectory (435.03KB) (3.22%)
    13.26ms
    1 x afterRenderRawModule mod_menu (Main Menu) (118.14KB) (0.77%)
    3.16ms
    1 x afterRenderModule mod_menu (Main Menu) (49.97KB) (0.63%)
    2.61ms
    1 x afterDispatch (2.91KB) (0.26%)
    1.08ms
    1 x After Access::preloadComponents (all components) (171.05KB) (0.17%)
    684μs
    1 x beforeRenderComponent com_jbusinessdirectory (48.53KB) (0.16%)
    644μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.58KB) (0.12%)
    502μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (2.45KB) (0%)
    12μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    5μs
122 statements were executed, 39 of which were duplicates, 83 unique24.61ms1.52MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7
  • SELECT @@SESSION.sql_mode;61μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `brew_session` WHERE `session_id` = ?604μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 175μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `brew_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.84ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `brew_viewlevels`113μs1.56KB/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` = :guest134μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'205μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`78μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'203μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'232μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM `brew_admintools_ipautoban`311μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
  • SELECT `ip` FROM `brew_admintools_ipblock`79μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
  • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'91μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC106μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
  • SELECT `id` FROM `brew_jbusinessdirectory_companies` WHERE alias = 'john-harvards-brew-house'189μs856B/components/com_jbusinessdirectory/router.php:355Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas295μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_date_formats fas WHERE fas.id ='3'103μs3.56KB/components/com_jbusinessdirectory/helpers/utils.php:78Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_currencies fas WHERE fas.currency_id ='143'67μs1KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'john-harvards-brew-house' LIMIT 1142μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'john-harvards-brew-house' LIMIT 1248μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181Copy
  • SELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application` FROM `brew_admintools_wafblacklists` WHERE `enabled` = 1102μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'120μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'john-harvards-brew-house' LIMIT 1175μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'john-harvards-brew-house' LIMIT 1249μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`338μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes95μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`513μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SET SESSION group_concat_max_len = 1000027μ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=15391 group by bc.id order by name551μs21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`332μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1539175μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15391 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc709μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`258μs13.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15391 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday166μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15391 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday149μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`298μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_categories c where c.id=236112μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • select * from brew_jbusinessdirectory_company_attachments where type=1 and status=1 and object_id=15391 ORDER BY ordering asc, name,path74μs1.17KB/components/com_jbusinessdirectory/helpers/attachments.php:38Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`223μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15391 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering130μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_contact`231μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_contact where companyId=15391 order by contact_department67μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • select * from brew_jbusinessdirectory_company_contact where companyId=15391 order by contact_department66μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_testimonials`273μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_testimonials where companyId=15391 order by testimonial_title123μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:30Copy
  • select DISTINCT contact_department from brew_jbusinessdirectory_company_contact where companyId=15391 order by contact_department53μs840B/administrator/components/com_jbusinessdirectory/tables/companycontact.php:47Copy
  • SELECT * FROM brew_jbusinessdirectory_company_pictures WHERE picture_enable =1 and companyId =15391 ORDER BY id66μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT * FROM brew_jbusinessdirectory_company_pictures_extra WHERE image_enable =1 and companyId =15391 ORDER BY id81μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_videos`217μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_videos where companyId=1539160μs1008B/administrator/components/com_jbusinessdirectory/tables/companyvideos.php:38Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_offers`338μs2.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select co.id, co.price , co.specialPrice, co.subject, co.short_description, co.address, co.city, co.county, co.province, co.area, co.latitude, co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url, co.quantity, co.min_purchase, co.max_purchase, op.picture_info,op.picture_path,op.picture_title, co.currencyId, co.price_text,co.time_zone, co.add_to_price_list, co.enable_offer_selling, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color ORDER BY cg.name separator '#|') as categories, GROUP_CONCAT(DISTINCT cg.id) as categoryIds, sum(os.qty) as stock_quantity from brew_jbusinessdirectory_company_offers co left join brew_jbusinessdirectory_company_offer_pictures op on co.id=op.offerId and (op.id in ( select min(op1.id) as min from brew_jbusinessdirectory_company_offers co1 left join brew_jbusinessdirectory_company_offer_pictures op1 on co1.id=op1.offerId where op1.picture_enable=1 group by co1.id ) ) left join brew_jbusinessdirectory_company_offer_category cc on co.id=cc.offerId left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join brew_jbusinessdirectory_offer_stock as os on os.offer_id = co.id where co.companyId=15391 and co.state=1 and (co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) and (co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00'or co.publish_end_date is null) and (co.approved = 1) and co.item_type = 1 and ((co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) and ((co.publish_start_date=DATE(now()) and time(co.publish_start_time)<=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_start_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_start_time='00:00:00' or co.publish_start_time is null)) and ((co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00' or co.publish_end_date is null ) and ((co.publish_end_date=DATE(now()) and time(co.publish_end_time)>=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_end_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_end_time='00:00:00' or co.publish_end_time is null) ) group by co.id, op.id order by co.id desc286μs4.39KB/administrator/components/com_jbusinessdirectory/tables/offer.php:219Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_events`336μs2.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select co.*, op.picture_path, et.name as eventType, cg.markerLocation as categoryMarker from brew_jbusinessdirectory_company_events co left join brew_jbusinessdirectory_company_event_pictures op on co.id=op.eventId and (op.id in ( select min(op1.id) as min from brew_jbusinessdirectory_company_events co1 left join brew_jbusinessdirectory_company_event_pictures op1 on co1.id=op1.eventId where op1.picture_enable=1 and company_id=15391 group by co1.id)) left join brew_jbusinessdirectory_company_event_types et on co.type=et.id left join brew_jbusinessdirectory_company_event_category cc on co.id=cc.eventId left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 where co.state=1 and (co.end_date>=DATE(now()) or co.end_date='0000-00-00') and company_id=15391 and (co.approved = 1) group by co.id order by co.start_date269μs24.48KB/administrator/components/com_jbusinessdirectory/tables/event.php:699Copy
  • SELECT id, name, event_config as config FROM brew_jbusinessdirectory_default_attributes91μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • select DISTINCT cp.* from brew_jbusinessdirectory_companies cp left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id left join brew_jbusinessdirectory_packages p on (inv.package_id=p.id and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1) left join brew_jbusinessdirectory_company_related rc on rc.related_company_id=cp.id where rc.company_id=15391 and ( ( (inv.state= 1 and ( ( (now() > (inv.start_date) and (now() < ( inv.start_date + INTERVAL p.days DAY) or p.expiration_type=1)) or (now() > (inv.start_trial_date) and now() < ( inv.start_trial_date + INTERVAL p.trial_days DAY))) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0))) ) and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null) and cp.state = 1302μs20.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1842Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_services_list`254μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_services_list where companyId=15391 order by service_section, id63μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companyserviceslist.php:30Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_event_associated_items`224μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select DISTINCT ce.* from brew_jbusinessdirectory_company_events ce left join brew_jbusinessdirectory_companies cp on cp.id = ce.company_id left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id left join brew_jbusinessdirectory_packages p on (inv.package_id=p.id and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1) WHERE ce.id IN ( select eac.event_id from brew_jbusinessdirectory_company_events co left join brew_jbusinessdirectory_company_event_associated_items eac on eac.event_id=co.id where eac.company_id=15391 ) and ce.state = 1 and (ce.approved = 1) and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0))) ) and ce.end_date>= DATE(NOW())260μs8.39KB/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:235Copy
  • SELECT id, name, offer_config as config FROM brew_jbusinessdirectory_default_attributes87μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_memberships`220μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT c.* FROM brew_jbusinessdirectory_memberships c LEFT JOIN brew_jbusinessdirectory_company_membership cc ON c.id=cc.membership_id WHERE company_id=15391 AND c.status = 1 AND c.show_in_front = 1 ORDER BY c.type,c.name80μs1.89KB/administrator/components/com_jbusinessdirectory/tables/memberships.php:110Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews`247μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select cr.*, scores, criteria_ids, answer_ids, question_ids from brew_jbusinessdirectory_company_reviews cr left join ( select GROUP_CONCAT(ruc.score) as scores, GROUP_CONCAT(rc.id) as criteria_ids, r.id as cr_id from brew_jbusinessdirectory_company_reviews r left join brew_jbusinessdirectory_company_reviews_user_criteria ruc on r.id=ruc.review_id left join brew_jbusinessdirectory_company_reviews_criteria rc on rc.id=ruc.criteria_id and rc.published =1 group by r.id ) rcs on cr.id = rcs.cr_id left join ( select GROUP_CONCAT(rqa.id) as answer_ids, GROUP_CONCAT(rq.id) as question_ids, r.id as cr_id from brew_jbusinessdirectory_company_reviews r left join brew_jbusinessdirectory_company_reviews_question_answer rqa on r.id=rqa.review_id left join brew_jbusinessdirectory_company_reviews_question rq on rq.id=rqa.question_id group by r.id ) rqs on cr.id = rqs.cr_id where 1 and cr.itemId=15391 and cr.review_type =1 and state=1 and (cr.approved = 2) order by creationDate desc LIMIT 10406μs12.02KB/administrator/components/com_jbusinessdirectory/tables/review.php:76Copy
  • select cr.* from brew_jbusinessdirectory_company_reviews cr where 1 and cr.itemId=15391 and cr.review_type =1 and state=1 and (cr.approved = 2)98μs3.77KB/administrator/components/com_jbusinessdirectory/tables/review.php:91Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_criteria`224μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_reviews_criteria where published = 183μs1008B/administrator/components/com_jbusinessdirectory/tables/reviewcriteria.php:31Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_question`216μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_reviews_question where 1 and published = 1 order by ordering62μs1.11KB/administrator/components/com_jbusinessdirectory/tables/reviewquestion.php:33Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_question_answer`229μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select rqa.* from brew_jbusinessdirectory_company_reviews_question_answer rqa left join brew_jbusinessdirectory_company_reviews cr on cr.id = rqa.review_id where cr.itemId =15391 and review_type = 174μs1.05KB/administrator/components/com_jbusinessdirectory/tables/reviewquestionanswer.php:34Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_projects`230μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select co.*, GROUP_CONCAT( DISTINCT op.id,'|',op.projectId,'|',op.picture_info,'|',op.picture_path,'|',op.picture_enable ORDER BY op.id separator '#|') as pictures from brew_jbusinessdirectory_company_projects co left join brew_jbusinessdirectory_company_projects_pictures op on co.id=op.projectId and op.picture_enable = 1 where company_id=15391 and status=1 group by co.id order by co.id84μs1.17KB/administrator/components/com_jbusinessdirectory/tables/projects.php:42Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_announcements`259μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT co.*,cp.name AS companyName FROM brew_jbusinessdirectory_company_announcements co LEFT JOIN brew_jbusinessdirectory_companies cp ON cp.id = co.company_id WHERE co.status=1 AND cp.id=15391 and (expiration_date >= DATE(NOW()) or expiration_date is null or expiration_date='0000-00-00') ORDER BY co.title115μs2.05KB/administrator/components/com_jbusinessdirectory/tables/announcements.php:134Copy
  • select * from brew_jbusinessdirectory_company_claim where companyId = 15391 and status <> -1 order by id desc129μs1.2KB/administrator/components/com_jbusinessdirectory/tables/company.php:1370Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_articles`209μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_articles ca inner join brew_content ct on ct.id = ca.article_id where company_id=15391 and ct.state = 1 order by ct.created desc149μs4.39KB/administrator/components/com_jbusinessdirectory/tables/companyarticles.php:34Copy
  • SELECT id, name FROM brew_jbusinessdirectory_companies as c WHERE c.id != 15391 AND c.state = 1 GROUP BY c.id ORDER BY c.name ASC LIMIT 50222μs1.75KB/components/com_jbusinessdirectory/helpers/utils.php:3776Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_registered`291μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select DISTINCT cp.* from brew_jbusinessdirectory_companies cp left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id left join brew_jbusinessdirectory_packages p on (inv.package_id=p.id and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1) left join brew_jbusinessdirectory_company_registered rc on rc.joined_company_id=cp.id where rc.company_id=15391 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0))) ) and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null) and cp.state = 1 and rc.approved='2'414μs20.77KB/administrator/components/com_jbusinessdirectory/tables/registeredcompany.php:197Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_members`226μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_members where company_id=15391 order by id64μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companymembers.php:33Copy
  • update brew_jbusinessdirectory_companies set viewCount = viewCount + 1 where id=15391111μs48B/administrator/components/com_jbusinessdirectory/tables/company.php:1314Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_statistics`216μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_statistics`220μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • INSERT INTO `brew_jbusinessdirectory_statistics` (`id`,`item_id`,`item_type`,`date`,`type`) VALUES ('0','15391','1','2025-04-24 20:49:21','0')88μs0B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:767Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `brew_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51)400μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • select * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name592μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
  • SELECT `alias` FROM `brew_jbusinessdirectory_companies` WHERE id = '15391'88μs856B/components/com_jbusinessdirectory/router.php:246Copy
  • SELECT `alias` FROM `brew_jbusinessdirectory_companies` WHERE id = '15391'62μs856B/components/com_jbusinessdirectory/router.php:246Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'193μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'99μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'105μ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'197μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'123μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'101μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'146μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'150μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'176μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'140μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • 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_template_styles` WHERE `client_id` = 0 AND `id` = '451'133μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'99μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'97μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'97μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'142μ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'166μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'116μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'109μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'118μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'101μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'107μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'114μ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` = 1207μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'criticalfiles'89μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'108μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = ?135μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `brew_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.19ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy