7502
https://usbreweryguide.com/media/com_jbusinessdirectory/pictures/companies/10672/cropped-1561398249.png

Shipyard Brewing Company

86 Newbury Street, Portland, Maine 04101
Maine Breweries
|
Closed

Business Details

Shipyard Brewing Company is a family owned brewery – rooted in tradition and brimming with innovation. Our award-winning beer is handcrafted by our team of brewers who learned their art from world-renowned master brewer, Alan Pugsley.

We are committed to cultivating a new generation of creative, passionate brewers. Our team is constantly exploring innovative and diverse styles of beer through our pilot system at our Portland brewery and our 7-barrel system at Federal Jack’s Brew Pub in Kennebunk Harbor.

Type:
Brewpub
Business Locations:
86 Newbury Street, Portland, Maine 04101

 28 Levesque Drive, Eliot, Maine 03903

Map Location

Map Directions
MarkerMarker
Leaflet © OpenStreetMap contributors

Claim Business

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

Claim Business
company map
86 Newbury Street, Portland, Maine 04101

Social Networks

Opening hours
GMT -4:00
Monday
09:00 AM - 06:00 PM
Tuesday
09:00 AM - 06:00 PM
Wednesday
09:00 AM - 06:00 PM
Thursday
09:00 AM - 06:00 PM
Friday
09:00 AM - 09:00 PM
Saturday
09:00 AM - 09:00 PM
Sunday
11:00 AM - 07:00 PM
J! InfoRequestSessionProfileQueries124Log
13.427MBMemory Usage729msRequest 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" => "5aa76af58d6972b7b09a142c115ec19f" "jbdViewedLis...
$_SERVER
array:56 [ "CONTEXT_DOCUMENT_ROOT" => "/home/nicklesu/public_html/usbreweryguide.com" "CONTEXT_P...
session
array:3 [ "counter" => 5 "timer" => array:3 [ "start" => 1741921159 "last" => 1741921170...
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) (168ms)
  • afterInitialise (3.77MB) (323ms)
  • afterRoute (957.22KB) (18.23ms)
  • beforeRenderComponent com_jbusinessdirectory (48.53KB) (633μs)
  • Before Access::preloadComponents (all components) (2.78MB) (98.33ms)
  • After Access::preloadComponents (all components) (171.05KB) (707μs)
  • Before Access::getAssetRules (id:1 name:root.1) (2.45KB) (12μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.58KB) (530μs)
  • afterRenderComponent com_jbusinessdirectory (595.99KB) (34.72ms)
  • afterDispatch (2.91KB) (1.12ms)
  • beforeRenderRawModule mod_menu (Main Menu) (632.02KB) (62.84ms)
  • afterRenderRawModule mod_menu (Main Menu) (115.84KB) (3.06ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (6μs)
  • afterRenderModule mod_menu (Main Menu) (49.97KB) (2.55ms)
  • afterRender (311.39KB) (14.41ms)
  • 1 x afterInitialise (3.77MB) (44.32%)
    323ms
    1 x afterLoad (414.6KB) (23.02%)
    168ms
    1 x Before Access::preloadComponents (all components) (2.78MB) (13.49%)
    98.33ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (632.02KB) (8.62%)
    62.84ms
    1 x afterRenderComponent com_jbusinessdirectory (595.99KB) (4.76%)
    34.72ms
    1 x afterRoute (957.22KB) (2.5%)
    18.23ms
    1 x afterRender (311.39KB) (1.98%)
    14.41ms
    1 x afterRenderRawModule mod_menu (Main Menu) (115.84KB) (0.42%)
    3.06ms
    1 x afterRenderModule mod_menu (Main Menu) (49.97KB) (0.35%)
    2.55ms
    1 x afterDispatch (2.91KB) (0.15%)
    1.12ms
    1 x After Access::preloadComponents (all components) (171.05KB) (0.1%)
    707μs
    1 x beforeRenderComponent com_jbusinessdirectory (48.53KB) (0.09%)
    633μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.58KB) (0.07%)
    530μ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%)
    6μs
124 statements were executed, 39 of which were duplicates, 85 unique48.44ms1.53MB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7
  • SELECT @@SESSION.sql_mode;1.72ms1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `brew_session` WHERE `session_id` = ?10.72ms1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 13ms1.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_id10.95ms992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `brew_viewlevels`161μ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` = :guest128μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'129μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`71μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'188μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'171μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM `brew_admintools_ipautoban`291μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
  • SELECT `ip` FROM `brew_admintools_ipblock`82μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
  • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'100μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC96μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
  • SELECT `id` FROM `brew_jbusinessdirectory_companies` WHERE alias = 'shipyard-brewing-company'162μs856B/components/com_jbusinessdirectory/router.php:355Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas311μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_date_formats fas WHERE fas.id ='3'87μs3.56KB/components/com_jbusinessdirectory/helpers/utils.php:78Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_currencies fas WHERE fas.currency_id ='143'71μs1KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'shipyard-brewing-company' LIMIT 1144μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'shipyard-brewing-company' LIMIT 1262μ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` = 198μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'117μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'shipyard-brewing-company' LIMIT 1138μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'shipyard-brewing-company' LIMIT 1264μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`324μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes97μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`399μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SET SESSION group_concat_max_len = 1000044μ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=10672 group by bc.id order by name538μs21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`303μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1067275μ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=10672 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 desc660μs21.42KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`268μ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 = 10672 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday203μ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 = 10672 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday177μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`262μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_categories c where c.id=234104μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_locations`224μ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=10672136μs3.63KB/administrator/components/com_jbusinessdirectory/tables/companylocations.php:32Copy
  • select * from brew_jbusinessdirectory_company_attachments where type=1 and status=1 and object_id=10672 ORDER BY ordering asc, name,path73μs1.17KB/components/com_jbusinessdirectory/helpers/attachments.php:38Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`232μ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=10672 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_contact`271μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_contact where companyId=10672 order by contact_department75μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • select * from brew_jbusinessdirectory_company_contact where companyId=10672 order by contact_department63μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_testimonials`241μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_testimonials where companyId=10672 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=10672 order by contact_department54μs840B/administrator/components/com_jbusinessdirectory/tables/companycontact.php:47Copy
  • SELECT * FROM brew_jbusinessdirectory_company_pictures WHERE picture_enable =1 and companyId =10672 ORDER BY id61μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT * FROM brew_jbusinessdirectory_company_pictures_extra WHERE image_enable =1 and companyId =10672 ORDER BY id59μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_videos`200μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_videos where companyId=1067260μs1008B/administrator/components/com_jbusinessdirectory/tables/companyvideos.php:38Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_offers`330μ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=10672 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 desc282μs4.39KB/administrator/components/com_jbusinessdirectory/tables/offer.php:219Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_events`366μ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=10672 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=10672 and (co.approved = 1) group by co.id order by co.start_date255μs24.48KB/administrator/components/com_jbusinessdirectory/tables/event.php:699Copy
  • SELECT id, name, event_config as config FROM brew_jbusinessdirectory_default_attributes109μ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=10672 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 = 1348μs20.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1842Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_services_list`216μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_services_list where companyId=10672 order by service_section, id62μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companyserviceslist.php:30Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_event_associated_items`236μ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=10672 ) 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())429μs8.39KB/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:235Copy
  • SELECT id, name, offer_config as config FROM brew_jbusinessdirectory_default_attributes89μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_memberships`333μ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=10672 AND c.status = 1 AND c.show_in_front = 1 ORDER BY c.type,c.name90μs9.89KB/administrator/components/com_jbusinessdirectory/tables/memberships.php:110Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews`245μ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=10672 and cr.review_type =1 and state=1 and (cr.approved = 2) order by creationDate desc LIMIT 10363μs4.02KB/administrator/components/com_jbusinessdirectory/tables/review.php:76Copy
  • select cr.* from brew_jbusinessdirectory_company_reviews cr where 1 and cr.itemId=10672 and cr.review_type =1 and state=1 and (cr.approved = 2)96μs3.77KB/administrator/components/com_jbusinessdirectory/tables/review.php:91Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_criteria`201μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_reviews_criteria where published = 181μs1008B/administrator/components/com_jbusinessdirectory/tables/reviewcriteria.php:31Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_question`232μ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 ordering71μs1.11KB/administrator/components/com_jbusinessdirectory/tables/reviewquestion.php:33Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_question_answer`202μ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 =10672 and review_type = 173μs1.05KB/administrator/components/com_jbusinessdirectory/tables/reviewquestionanswer.php:34Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_projects`204μ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=10672 and status=1 group by co.id order by co.id85μs1.17KB/administrator/components/com_jbusinessdirectory/tables/projects.php:42Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_announcements`211μ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=10672 and (expiration_date >= DATE(NOW()) or expiration_date is null or expiration_date='0000-00-00') ORDER BY co.title113μs2.05KB/administrator/components/com_jbusinessdirectory/tables/announcements.php:134Copy
  • select * from brew_jbusinessdirectory_company_claim where companyId = 10672 and status <> -1 order by id desc119μs1.2KB/administrator/components/com_jbusinessdirectory/tables/company.php:1370Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_articles`225μ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=10672 and ct.state = 1 order by ct.created desc142μs4.39KB/administrator/components/com_jbusinessdirectory/tables/companyarticles.php:34Copy
  • SELECT id, name FROM brew_jbusinessdirectory_companies as c WHERE c.id != 10672 AND c.state = 1 GROUP BY c.id ORDER BY c.name ASC LIMIT 50213μs1.75KB/components/com_jbusinessdirectory/helpers/utils.php:3776Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_registered`245μ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=10672 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'348μs20.77KB/administrator/components/com_jbusinessdirectory/tables/registeredcompany.php:197Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_members`319μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_company_members where company_id=10672 order by id80μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companymembers.php:33Copy
  • update brew_jbusinessdirectory_companies set viewCount = viewCount + 1 where id=10672114μs48B/administrator/components/com_jbusinessdirectory/tables/company.php:1314Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_statistics`217μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_statistics`203μ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','10672','1','2025-03-14 02:59:31','0')96μ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)397μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • select * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name557μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
  • SELECT `alias` FROM `brew_jbusinessdirectory_companies` WHERE id = '10672'174μs856B/components/com_jbusinessdirectory/router.php:246Copy
  • SELECT `alias` FROM `brew_jbusinessdirectory_companies` WHERE id = '10672'70μs856B/components/com_jbusinessdirectory/router.php:246Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'194μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'208μ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'92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'244μ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'100μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'184μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'96μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'201μ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'98μ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'94μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'98μ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'104μ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'91μs41.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'122μ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'106μ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'90μ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` = 1156μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'criticalfiles'81μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'115μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = ?128μ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