This page uses Google Maps. The map will be loaded from Google-Server and some of your data may be used by Google. In order to see the maps, please click accept. You can also click here to see further information related to this.
In order to perform this action you have to login
In order to perform this action you have to login
Joomla! Version | 5.2.2 |
PHP Version | 8.1.31 |
Identity | guest |
Response | 200 |
Template | j-directory |
Database |
|
1 x afterInitialise (3.64MB) (24.31%) | 157ms |
1 x afterOptimizeCssDelivery plgSystem (JCH Optimize) (1022.83KB) (14.33%) | 92.41ms |
1 x Before Access::preloadComponents (all components) (2.74MB) (14.33%) | 92.37ms |
1 x beforeProcess plgSystem (JCH Optimize) (1.09MB) (9.61%) | 61.98ms |
1 x afterLoad (414.6KB) (7.94%) | 51.22ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (636.02KB) (7.2%) | 46.42ms |
1 x afterRoute (1012.09KB) (5.11%) | 32.93ms |
1 x afterMinifyHtml plgSystem (JCH Optimize) (73.66KB) (2.36%) | 15.23ms |
1 x afterRenderComponent com_jbusinessdirectory (435.02KB) (2.19%) | 14.15ms |
1 x afterProcessImageAttributes plgSystem (JCH Optimize) (182.94KB) (1.52%) | 9.80ms |
1 x afterGetCombinedFiles - css plgSystem (JCH Optimize) (168.27KB) (1.43%) | 9.19ms |
1 x afterCombineFile - /media/system/css/joomla-fontawesome.min.css?7eaf7d plgSystem (JCH Optimize) (15.01KB) (1.21%) | 7.83ms |
1 x afterAddImgAttributes plgSystem (JCH Optimize) (91.6KB) (1.07%) | 6.92ms |
1 x afterGetCombinedFiles - css plgSystem (JCH Optimize) (17.59KB) (0.76%) | 4.92ms |
1 x afterGetCombinedFiles - css plgSystem (JCH Optimize) (45.02KB) (0.6%) | 3.84ms |
1 x afterGetCombinedFiles - css plgSystem (JCH Optimize) (127.34KB) (0.56%) | 3.60ms |
1 x beforePreProcessHtml plgSystem (JCH Optimize) (170.34KB) (0.55%) | 3.54ms |
1 x beforeGetContents - css plgSystem (JCH Optimize) (41.15KB) (0.54%) | 3.49ms |
1 x afterGetCombinedFiles - css plgSystem (JCH Optimize) (135.32KB) (0.48%) | 3.11ms |
1 x afterRenderRawModule mod_menu (Main Menu) (141.62KB) (0.47%) | 3.02ms |
1 x afterGetCombinedFiles - css plgSystem (JCH Optimize) (184.52KB) (0.41%) | 2.66ms |
1 x afterRenderModule mod_menu (Main Menu) (50.22KB) (0.39%) | 2.49ms |
1 x afterProcessCssUrls plgSystem (JCH Optimize) (3.15KB) (0.34%) | 2.16ms |
1 x afterLazyLoadImages plgSystem (JCH Optimize) (300.96KB) (0.32%) | 2.09ms |
1 x afterGetCombinedFiles - js plgSystem (JCH Optimize) (20.4KB) (0.26%) | 1.68ms |
1 x afterRender (39.15KB) (0.2%) | 1.26ms |
1 x afterGetCombinedFiles - css plgSystem (JCH Optimize) (127.74KB) (0.19%) | 1.25ms |
1 x afterDispatch (2.95KB) (0.16%) | 1.04ms |
1 x afterGetCombinedFiles - js plgSystem (JCH Optimize) (63.34KB) (0.13%) | 866μs |
1 x After Access::preloadComponents (all components) (171.14KB) (0.12%) | 767μs |
1 x afterSetUpExcludes plgSystem (JCH Optimize) (7.39KB) (0.12%) | 758μs |
1 x afterGetCombinedFiles - js plgSystem (JCH Optimize) (68.72KB) (0.12%) | 750μs |
1 x beforeRenderComponent com_jbusinessdirectory (48.22KB) (0.11%) | 725μs |
1 x afterPostProcessHtml plgSystem (JCH Optimize) (234.73KB) (0.09%) | 607μs |
1 x After Access::getAssetRules (id:1 name:root.1) (7.58KB) (0.09%) | 552μs |
1 x afterCreateStaticFiles - css plgSystem (JCH Optimize) (181.81KB) (0.06%) | 398μs |
1 x afterReplaceLinks - js plgSystem (JCH Optimize) (81.81KB) (0.02%) | 139μs |
1 x afterReplaceLinks - js plgSystem (JCH Optimize) (84.1KB) (0.02%) | 117μs |
1 x afterReplaceLinks - js plgSystem (JCH Optimize) (80.48KB) (0.02%) | 102μs |
1 x afterCreateStaticFiles - css plgSystem (JCH Optimize) (74.81KB) (0.01%) | 74μs |
1 x afterCreateStaticFiles - css plgSystem (JCH Optimize) (728B) (0.01%) | 45μs |
1 x afterCreateStaticFiles - css plgSystem (JCH Optimize) (131.13KB) (0.01%) | 44μs |
1 x afterCreateStaticFiles - css plgSystem (JCH Optimize) (320B) (0.01%) | 43μs |
1 x afterCreateStaticFiles - css plgSystem (JCH Optimize) (5.44KB) (0.01%) | 42μs |
1 x afterCreateStaticFiles - css plgSystem (JCH Optimize) (122.56KB) (0.01%) | 38μs |
1 x afterCreateStaticFiles - js plgSystem (JCH Optimize) (696B) (0.01%) | 38μs |
1 x afterCreateStaticFiles - js plgSystem (JCH Optimize) (13KB) (0%) | 30μs |
1 x afterCreateStaticFiles - js plgSystem (JCH Optimize) (141KB) (0%) | 28μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (2.45KB) (0%) | 23μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 7μs |
1 x afterProcess plgSystem (JCH Optimize) (424B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;
90μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `brew_session`
WHERE `session_id` = ?
636μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `brew_session`
WHERE `session_id` = :session_id LIMIT 1
90μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `brew_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
1.5ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `brew_viewlevels`
125μs1.56KB/libraries/src/Access/Access.php:955CopySELECT `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` = :guest
150μs1.63KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `brew_admintools_storage`
WHERE `key` = 'cparams'
198μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `brew_admintools_wafexceptions`
146μs960B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `brew_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
259μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT `params`
FROM `brew_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
265μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT *
FROM `brew_admintools_ipautoban`
140μs3.44KB/plugins/system/admintools/src/Utility/Cache.php:126CopySELECT `ip`
FROM `brew_admintools_ipblock`
75μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136CopySELECT *
FROM `brew_admintools_storage`
WHERE `key` LIKE 'timestamp_%'
92μs912B/plugins/system/admintools/src/Feature/Base.php:255CopySELECT `source`,`dest`,`keepurlparams`
FROM `brew_admintools_redirects`
WHERE `published` = 1
ORDER BY `ordering` ASC
134μs960B/plugins/system/admintools/src/Utility/Cache.php:162CopySELECT `id`
FROM `brew_jbusinessdirectory_companies`
WHERE alias = 'garphish-brewing-company'
238μs856B/components/com_jbusinessdirectory/router.php:355CopySELECT fas.*
FROM brew_jbusinessdirectory_application_settings fas
294μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM brew_jbusinessdirectory_date_formats fas
WHERE fas.id ='3'
78μs3.56KB/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM brew_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='143'
68μs1KB/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'garphish-brewing-company' LIMIT 1
164μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'garphish-brewing-company' LIMIT 1
298μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181CopySELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application`
FROM `brew_admintools_wafblacklists`
WHERE `enabled` = 1
116μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
172μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'garphish-brewing-company' LIMIT 1
174μs3.95KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT * FROM `brew_jbusinessdirectory_companies` c where c.alias = 'garphish-brewing-company' LIMIT 1
297μs20.78KB/plugins/system/urltranslator/jbdrouter.php:181CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`
374μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes
96μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`
458μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySET SESSION group_concat_max_len = 10000
26μs0B/components/com_jbusinessdirectory/helpers/utils.php:6866Copyselect 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=15526 group by bc.id order by name
652μs21.59KB/administrator/components/com_jbusinessdirectory/tables/company.php:128CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`
388μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15526
76μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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=15526
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 desc
739μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`
282μs13.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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 = 15526 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
186μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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 = 15526 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
166μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`
302μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_categories c
where c.id=238
108μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from brew_jbusinessdirectory_company_attachments where type=1 and status=1 and object_id=15526 ORDER BY ordering asc, name,path
75μs1.17KB/components/com_jbusinessdirectory/helpers/attachments.php:38CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`
255μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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=15526
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
131μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_contact`
281μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_company_contact where companyId=15526 order by contact_department
69μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40Copyselect * from brew_jbusinessdirectory_company_contact where companyId=15526 order by contact_department
74μs1.89KB/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_testimonials`
245μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_company_testimonials where companyId=15526 order by testimonial_title
117μs1.05KB/administrator/components/com_jbusinessdirectory/tables/companytestimonials.php:30Copyselect DISTINCT contact_department from brew_jbusinessdirectory_company_contact where companyId=15526 order by contact_department
53μs840B/administrator/components/com_jbusinessdirectory/tables/companycontact.php:47CopySELECT *
FROM brew_jbusinessdirectory_company_pictures
WHERE picture_enable =1 and companyId =15526
ORDER BY id
63μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT *
FROM brew_jbusinessdirectory_company_pictures_extra
WHERE image_enable =1 and companyId =15526
ORDER BY id
64μs1.11KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_videos`
471μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_company_videos where companyId=15526
60μs1008B/administrator/components/com_jbusinessdirectory/tables/companyvideos.php:38CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_offers`
381μs2.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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=15526 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 desc
301μs4.39KB/administrator/components/com_jbusinessdirectory/tables/offer.php:219CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_events`
395μs2.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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=15526
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=15526 and (co.approved = 1)
group by co.id
order by co.start_date
293μs24.48KB/administrator/components/com_jbusinessdirectory/tables/event.php:699CopySELECT id, name, event_config as config FROM brew_jbusinessdirectory_default_attributes
90μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copyselect 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=15526 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 = 1
453μs20.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1840CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_services_list`
296μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_company_services_list where companyId=15526 order by service_section, id
94μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companyserviceslist.php:30CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_event_associated_items`
416μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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=15526
) 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())
285μs8.39KB/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:235CopySELECT id, name, offer_config as config FROM brew_jbusinessdirectory_default_attributes
115μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_memberships`
239μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT c.*
FROM brew_jbusinessdirectory_memberships c
LEFT JOIN brew_jbusinessdirectory_company_membership cc ON c.id=cc.membership_id
WHERE company_id=15526 AND c.status = 1 AND c.show_in_front = 1
ORDER BY c.type,c.name
98μs1.89KB/administrator/components/com_jbusinessdirectory/tables/memberships.php:110CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews`
258μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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=15526 and cr.review_type =1 and state=1 and (cr.approved = 2)
order by creationDate desc LIMIT 10
411μs12.02KB/administrator/components/com_jbusinessdirectory/tables/review.php:76Copyselect cr.* from brew_jbusinessdirectory_company_reviews cr
where 1 and cr.itemId=15526 and cr.review_type =1 and state=1 and (cr.approved = 2)
95μs3.77KB/administrator/components/com_jbusinessdirectory/tables/review.php:91CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_criteria`
216μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_company_reviews_criteria
where published = 1
80μs1008B/administrator/components/com_jbusinessdirectory/tables/reviewcriteria.php:31CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_question`
233μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect *
from brew_jbusinessdirectory_company_reviews_question
where 1 and published = 1
order by ordering
65μs1.11KB/administrator/components/com_jbusinessdirectory/tables/reviewquestion.php:33CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_reviews_question_answer`
229μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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 =15526 and review_type = 1
76μs1.05KB/administrator/components/com_jbusinessdirectory/tables/reviewquestionanswer.php:34CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_projects`
247μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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=15526 and status=1
group by co.id
order by co.id
84μs1.17KB/administrator/components/com_jbusinessdirectory/tables/projects.php:42CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_announcements`
261μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT 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=15526 and (expiration_date >= DATE(NOW()) or expiration_date is null or expiration_date='0000-00-00')
ORDER BY co.title
116μs2.05KB/administrator/components/com_jbusinessdirectory/tables/announcements.php:134Copyselect * from brew_jbusinessdirectory_company_claim where companyId = 15526 and status <> -1 order by id desc
153μs1.2KB/administrator/components/com_jbusinessdirectory/tables/company.php:1368CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_articles`
222μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect *
from brew_jbusinessdirectory_company_articles ca
inner join brew_content ct on ct.id = ca.article_id
where company_id=15526 and ct.state = 1
order by ct.created desc
369μs4.39KB/administrator/components/com_jbusinessdirectory/tables/companyarticles.php:34CopySELECT id, name
FROM brew_jbusinessdirectory_companies as c
WHERE c.id != 15526 AND c.state = 1
GROUP BY c.id
ORDER BY c.name ASC LIMIT 50
253μs1.75KB/components/com_jbusinessdirectory/helpers/utils.php:3756CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_registered`
265μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect 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=15526 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'
440μs20.77KB/administrator/components/com_jbusinessdirectory/tables/registeredcompany.php:197CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_members`
387μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_company_members where company_id=15526 order by id
71μs1.17KB/administrator/components/com_jbusinessdirectory/tables/companymembers.php:33Copyupdate brew_jbusinessdirectory_companies set viewCount = viewCount + 1 where id=15526
111μs48B/administrator/components/com_jbusinessdirectory/tables/company.php:1312CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_statistics`
243μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_statistics`
227μs1.98KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopyINSERT INTO `brew_jbusinessdirectory_statistics`
(`id`,`item_id`,`item_type`,`date`,`type`) VALUES
('0','15526','1','2025-01-20 01:24:35','0')
105μs0B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:767CopySELECT `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)
435μs8.25KBParams/libraries/src/Access/Access.php:357Copyselect * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name
589μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySELECT `alias`
FROM `brew_jbusinessdirectory_companies`
WHERE id = '15526'
145μs856B/components/com_jbusinessdirectory/router.php:246CopySELECT `alias`
FROM `brew_jbusinessdirectory_companies`
WHERE id = '15526'
67μs856B/components/com_jbusinessdirectory/router.php:246CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
216μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
98μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
94μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
94μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
224μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
134μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
101μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
116μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
120μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
103μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
100μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
111μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
142μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
101μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
98μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
97μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
115μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
129μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
242μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
98μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
348μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
116μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
139μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
103μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
99μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT 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` = 1
150μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT `value`
FROM `brew_admintools_storage`
WHERE `key` = 'criticalfiles'
95μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
117μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT `session_id`
FROM `brew_session`
WHERE `session_id` = ?
160μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `brew_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
6.87ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
Garphish Brewing Company
Microbrewery