8340
https://usbreweryguide.com/media/com_jbusinessdirectory/pictures/companies/6184/cropped-1561431109.png

Alewerks Brewing Company

197 Ewell Rd, Williamsburg, Virginia 23188
Virginia Breweries
|
Closed

Business Details

Back in 2006, before it was cool to brew craft beer, Chuck Haines had a bright idea to open a brewery in Williamsburg. Inspired by his time in Europe, Chuck wanted to share his passion for authentic, craft-brewed ales with Virginia. He rolled his sleeves up and started brewing in what was a very different, and significantly more challenging, time for craft beer. Doors didn't open to craft beer as easily, and it was through Chuck's determination and perseverance that Alewerks was able to establish a foothold.

In 2008, Geoff Logan was brought on board as Brewmaster and immediately began receiving awards and accolades for his delicately crafted brews. The craft-beer market began to expand, as did Alewerks' portfolio, including the introduction of many our our now-classic recipes like BBP, Café Royale, Bitter Valentine, and Pumpkin Ale. 2015 saw Chuck take his well-deserved retirement and pass the mantle of Managing Director to Geoff, leading to Alewerks being the rare, brewer-driven brewery. Here the beer truly does come first.

Alewerks remains committed to quality, even as we continually increase production. We take great pride in each and every ounce of beer we brew, whether

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
197 Ewell Rd, Williamsburg, Virginia 23188

Social Networks

Opening hours
GMT -4:00
Monday
12:00 PM - 09:00 PM
Tuesday
12:00 PM - 09:00 PM
Wednesday
12:00 PM - 09:00 PM
Thursday
12:00 PM - 09:00 PM
Friday
12:00 PM - 09:00 PM
Saturday
12:00 PM - 09:00 PM
Sunday
12:00 PM - 08:00 PM
J! InfoRequestSessionProfileQueries124Log
13.425MBMemory Usage382msRequest Duration
Joomla! Version5.2.2
PHP Version8.1.31
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
array:2 [ "7446a39c0487e807b461c8b1a207dfa7" => "2d8d4bec6b7669c4af24f230715f9f18" "jbdViewedLis...
$_SERVER
array:56 [ "CONTEXT_DOCUMENT_ROOT" => "/home/nicklesu/public_html/usbreweryguide.com" "CONTEXT_P...
session
array:3 [ "counter" => 6 "timer" => array:3 [ "start" => 1741922292 "last" => 1741922310...
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
null
  • afterLoad (414.6KB) (44.15ms)
  • afterInitialise (3.77MB) (146ms)
  • afterRoute (958.18KB) (17.24ms)
  • beforeRenderComponent com_jbusinessdirectory (48.53KB) (649μs)
  • Before Access::preloadComponents (all components) (2.78MB) (83.44ms)
  • After Access::preloadComponents (all components) (171.05KB) (738μs)
  • Before Access::getAssetRules (id:1 name:root.1) (2.45KB) (13μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.58KB) (576μs)
  • afterRenderComponent com_jbusinessdirectory (595.77KB) (23.21ms)
  • afterDispatch (2.95KB) (1.04ms)
  • beforeRenderRawModule mod_menu (Main Menu) (632.02KB) (43.7ms)
  • afterRenderRawModule mod_menu (Main Menu) (115.84KB) (2.96ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (6μs)
  • afterRenderModule mod_menu (Main Menu) (49.97KB) (2.59ms)
  • afterRender (311.39KB) (15.02ms)
  • 1 x afterInitialise (3.77MB) (38.18%)
    146ms
    1 x Before Access::preloadComponents (all components) (2.78MB) (21.83%)
    83.44ms
    1 x afterLoad (414.6KB) (11.55%)
    44.15ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (632.02KB) (11.43%)
    43.70ms
    1 x afterRenderComponent com_jbusinessdirectory (595.77KB) (6.07%)
    23.21ms
    1 x afterRoute (958.18KB) (4.51%)
    17.24ms
    1 x afterRender (311.39KB) (3.93%)
    15.02ms
    1 x afterRenderRawModule mod_menu (Main Menu) (115.84KB) (0.77%)
    2.96ms
    1 x afterRenderModule mod_menu (Main Menu) (49.97KB) (0.68%)
    2.59ms
    1 x afterDispatch (2.95KB) (0.27%)
    1.04ms
    1 x After Access::preloadComponents (all components) (171.05KB) (0.19%)
    738μs
    1 x beforeRenderComponent com_jbusinessdirectory (48.53KB) (0.17%)
    649μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.58KB) (0.15%)
    576μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (2.45KB) (0%)
    13μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    6μs
124 statements were executed, 39 of which were duplicates, 85 unique22.05ms1.53MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7
  • SELECT @@SESSION.sql_mode;71μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `brew_session` WHERE `session_id` = ?146μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 193μ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_id108μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `brew_viewlevels`129μ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` = :guest130μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'216μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`87μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'210μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'226μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM `brew_admintools_ipautoban`365μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
  • SELECT `ip` FROM `brew_admintools_ipblock`92μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
  • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'89μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC93μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
  • SELECT `id` FROM `brew_jbusinessdirectory_companies` WHERE alias = 'alewerks-brewing-company'223μs856B/components/com_jbusinessdirectory/router.php:355Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas333μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_date_formats fas WHERE fas.id ='3'77μ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 = 'alewerks-brewing-company' LIMIT 1138μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'alewerks-brewing-company' LIMIT 1251μ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` = 1110μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'112μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'alewerks-brewing-company' LIMIT 1140μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'alewerks-brewing-company' LIMIT 1245μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`311μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes94μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`430μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SET SESSION group_concat_max_len = 1000026μ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=6184 group by bc.id order by name521μs21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`346μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 618483μ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=6184 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 = 4 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc646μs21.42KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`223μ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 = 6184 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday168μs2.23KB/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 = 6184 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday147μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`280μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_categories c where c.id=261100μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_locations`271μs2.14KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select a.*,b.country_name as country from brew_jbusinessdirectory_company_locations a left join brew_jbusinessdirectory_countries b on a.countryId = b.id where company_id=6184115μs3.61KB/administrator/components/com_jbusinessdirectory/tables/companylocations.php:32Copy
  • select * from brew_jbusinessdirectory_company_attachments where type=1 and status=1 and object_id=6184 ORDER BY ordering asc, name,path71μs1.17KB/components/com_jbusinessdirectory/helpers/attachments.php:38Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`201μ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=6184 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering144μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_contact`208μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_contact where companyId=6184 order by contact_department67μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • select * from brew_jbusinessdirectory_company_contact where companyId=6184 order by contact_department61μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_testimonials`197μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_testimonials where companyId=6184 order by testimonial_title104μs1.06KB/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:30Copy
  • select DISTINCT contact_department from brew_jbusinessdirectory_company_contact where companyId=6184 order by contact_department49μs840B/administrator/components/com_jbusinessdirectory/tables/companycontact.php:47Copy
  • SELECT * FROM brew_jbusinessdirectory_company_pictures WHERE picture_enable =1 and companyId =6184 ORDER BY id60μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT * FROM brew_jbusinessdirectory_company_pictures_extra WHERE image_enable =1 and companyId =6184 ORDER BY id62μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_videos`202μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_videos where companyId=618457μs1008B/administrator/components/com_jbusinessdirectory/tables/companyvideos.php:38Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_offers`346μ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=6184 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 desc274μs4.39KB/administrator/components/com_jbusinessdirectory/tables/offer.php:219Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_events`361μ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=6184 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=6184 and (co.approved = 1) group by co.id order by co.start_date240μs24.48KB/administrator/components/com_jbusinessdirectory/tables/event.php:699Copy
  • SELECT id, name, event_config as config FROM brew_jbusinessdirectory_default_attributes126μ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=6184 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 = 1291μs20.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1842Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_services_list`256μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_services_list where companyId=6184 order by service_section, id66μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companyserviceslist.php:30Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_event_associated_items`187μ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=6184 ) 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())302μs8.39KB/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:235Copy
  • SELECT id, name, offer_config as config FROM brew_jbusinessdirectory_default_attributes88μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_memberships`495μ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=6184 AND c.status = 1 AND c.show_in_front = 1 ORDER BY c.type,c.name81μs9.89KB/administrator/components/com_jbusinessdirectory/tables/memberships.php:110Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews`246μ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=6184 and cr.review_type =1 and state=1 and (cr.approved = 2) order by creationDate desc LIMIT 10358μs4.02KB/administrator/components/com_jbusinessdirectory/tables/review.php:76Copy
  • select cr.* from brew_jbusinessdirectory_company_reviews cr where 1 and cr.itemId=6184 and cr.review_type =1 and state=1 and (cr.approved = 2)93μs3.77KB/administrator/components/com_jbusinessdirectory/tables/review.php:91Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_criteria`215μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_reviews_criteria where published = 178μs1008B/administrator/components/com_jbusinessdirectory/tables/reviewcriteria.php:31Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_question`219μ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`190μ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 =6184 and review_type = 179μs1.05KB/administrator/components/com_jbusinessdirectory/tables/reviewquestionanswer.php:34Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_projects`201μ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=6184 and status=1 group by co.id order by co.id83μs1.17KB/administrator/components/com_jbusinessdirectory/tables/projects.php:42Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_announcements`212μ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=6184 and (expiration_date >= DATE(NOW()) or expiration_date is null or expiration_date='0000-00-00') ORDER BY co.title121μs2.05KB/administrator/components/com_jbusinessdirectory/tables/announcements.php:134Copy
  • select * from brew_jbusinessdirectory_company_claim where companyId = 6184 and status <> -1 order by id desc107μs1.2KB/administrator/components/com_jbusinessdirectory/tables/company.php:1370Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_articles`191μ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=6184 and ct.state = 1 order by ct.created desc131μs4.39KB/administrator/components/com_jbusinessdirectory/tables/companyarticles.php:34Copy
  • SELECT id, name FROM brew_jbusinessdirectory_companies as c WHERE c.id != 6184 AND c.state = 1 GROUP BY c.id ORDER BY c.name ASC LIMIT 50209μs1.75KB/components/com_jbusinessdirectory/helpers/utils.php:3776Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_registered`197μ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=6184 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'332μs20.77KB/administrator/components/com_jbusinessdirectory/tables/registeredcompany.php:197Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_members`204μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_members where company_id=6184 order by id60μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companymembers.php:33Copy
  • update brew_jbusinessdirectory_companies set viewCount = viewCount + 1 where id=618484μs48B/administrator/components/com_jbusinessdirectory/tables/company.php:1314Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_statistics`315μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_statistics`206μ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','6184','1','2025-03-14 03:18:30','0')155μ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)416μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • select * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name487μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
  • SELECT `alias` FROM `brew_jbusinessdirectory_companies` WHERE id = '6184'94μs856B/components/com_jbusinessdirectory/router.php:246Copy
  • SELECT `alias` FROM `brew_jbusinessdirectory_companies` WHERE id = '6184'66μs856B/components/com_jbusinessdirectory/router.php:246Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'214μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μ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'92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'179μ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'135μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'119μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μ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'115μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'95μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'135μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'95μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'93μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μ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'93μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'119μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'106μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'129μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'93μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'94μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'120μ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` = 1158μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'criticalfiles'83μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'131μ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.22ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy