Results 1 - 45 of 45
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.32 |
Identity | guest |
Response | 200 |
Template | j-directory |
Database |
|
1 x afterRenderComponent com_jbusinessdirectory (6.54MB) (43.18%) | 208ms |
1 x afterInitialise (3.77MB) (30.19%) | 146ms |
1 x beforeRenderRawModule mod_menu (Main Menu) (635.19KB) (9.95%) | 48.00ms |
1 x afterLoad (414.6KB) (8.73%) | 42.10ms |
1 x afterRender (580.3KB) (3.42%) | 16.49ms |
1 x afterRoute (810.58KB) (2.61%) | 12.59ms |
1 x afterRenderRawModule mod_menu (Main Menu) (183.3KB) (0.68%) | 3.27ms |
1 x afterRenderModule mod_menu (Main Menu) (50.59KB) (0.56%) | 2.69ms |
1 x afterDispatch (3.21KB) (0.35%) | 1.69ms |
1 x beforeRenderComponent com_jbusinessdirectory (46.22KB) (0.14%) | 677μs |
1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%) | 8μs |
SELECT @@SESSION.sql_mode;
68μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `brew_session`
WHERE `session_id` = ?
491μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `brew_session`
WHERE `session_id` = :session_id LIMIT 1
60μ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)
3.8ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `brew_viewlevels`
128μ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
143μs1.63KBParams/libraries/src/Access/Access.php:868CopySELECT `value`
FROM `brew_admintools_storage`
WHERE `key` = 'cparams'
180μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120CopySELECT `option`,`view`,`query`
FROM `brew_admintools_wafexceptions`
83μs960B/plugins/system/admintools/src/Utility/Cache.php:196CopySELECT `params`
FROM `brew_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
209μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT `params`
FROM `brew_extensions`
WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'
239μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324CopySELECT *
FROM `brew_admintools_ipautoban`
324μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126CopySELECT `ip`
FROM `brew_admintools_ipblock`
94μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136CopySELECT *
FROM `brew_admintools_storage`
WHERE `key` LIKE 'timestamp_%'
95μs912B/plugins/system/admintools/src/Feature/Base.php:255CopySELECT `source`,`dest`,`keepurlparams`
FROM `brew_admintools_redirects`
WHERE `published` = 1
ORDER BY `ordering` ASC
96μs960B/plugins/system/admintools/src/Utility/Cache.php:162CopySELECT fas.*
FROM brew_jbusinessdirectory_application_settings fas
277μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM brew_jbusinessdirectory_date_formats fas
WHERE fas.id ='3'
84μs1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM brew_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='143'
82μs3.5KB/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'nevada-breweries' LIMIT 1
238μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application`
FROM `brew_admintools_wafblacklists`
WHERE `enabled` = 1
95μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
119μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'nevada-breweries' LIMIT 1
170μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225CopySELECT *
FROM brew_jbusinessdirectory_mobile_app_config
159μs1.94KB/components/com_jbusinessdirectory/helpers/utils.php:9443CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`
247μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes
89μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`
436μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`
281μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect * from brew_jbusinessdirectory_categories c
where c.id=243
132μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name
340μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copyinsert into brew_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values
('2','1','2025-03-28','243','0')
135μs0B/components/com_jbusinessdirectory/helpers/utils.php:7651Copyselect * from brew_jbusinessdirectory_categories c
where c.id=243
112μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name
292μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySET SQL_BIG_SELECTS=1
25μs0B/components/com_jbusinessdirectory/helpers/utils.php:6906Copyselect * from
(select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured,
cp.id
from brew_jbusinessdirectory_companies cp
left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join brew_jbusinessdirectory_company_locations l on cp.id = l.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 inv.state= 1 and (NOW() between inv.start_date and inv.end_date) 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 1 and cc.categoryId in (243,243) and (
(
(inv.state= 1 and (
(
(( now() between inv.start_date and inv.end_date))
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.state=1 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)
group by cp.id
having 1
) s
where 1
1.63ms12.73KB/administrator/components/com_jbusinessdirectory/tables/company.php:1156CopySET SESSION group_concat_max_len = 10000
28μs0B/components/com_jbusinessdirectory/helpers/utils.php:6887Copyselect slec.* , companyName ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from (
select
cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering
,GROUP_CONCAT( DISTINCT cg.id) as categoryIds
,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name
from brew_jbusinessdirectory_companies cp
left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join brew_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1
left join brew_jbusinessdirectory_company_locations l on cp.id = l.company_id
left join brew_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and cr.approved=2
left join brew_jbusinessdirectory_countries cn on cp.countryId=cn.id
left join brew_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId)
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 inv.state= 1 and (NOW() between inv.start_date and inv.end_date) 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_package_fields pf on p.id=pf.package_id
left join brew_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1
where 1 and cp.state=1 and cc.categoryId in (243,243) and (
(
(inv.state= 1 and (
(
(( now() between inv.start_date and inv.end_date))
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)
group by cp.id
) as slec
where 1
having 1
order by featured desc, packageOrder desc, companyName asc LIMIT 100
12.36ms3.02KB/administrator/components/com_jbusinessdirectory/tables/company.php:1122Copyselect slec.* , companyName ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from (
select
cp.name as companyName, cp.id as companyId1, cp.ad_image, cp.yelp_id, cp.viewCount, cp.recommended,
cp.id, cp.name, cp.alias, cp.short_description, cp.meta_description, cp.street_number, cp.address, cp.city, cp.county, cp.province, cp.area, cp.website, cp.phone, cp.mobile,
cp.email, cp.state, cp.fax, cp.opening_status, cp.time_zone,
cp.employees, cp.hourly_rate, cp.min_project_size, cp.facebook, cp.twitter, cp.whatsapp, cp.instagram, cp.pinterest, cp.youtube, cp.linkedin,
cp.averageRating, cp.slogan,cp.logoLocation, cp.activity_radius, cp. review_score, cp.creationDate, cp.package_id,
cp.featured,cp.publish_only_city,cp.userId, cp.business_cover_image,
cp.latitude, cp.longitude, cp.keywords,cp.approved, cp.mainSubcategory, cp.countryId,cp.typeId, cp.postalCode, cp.publish_start_date, cp.publish_end_date,cp.ordering,
GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color ORDER BY cg.lft separator '#|') as categories,
GROUP_CONCAT( DISTINCT cg.id) as categoryIds,
bcm.name as mainCategory, bcm.alias as mainCategoryAlias ,bcm.markerLocation as categoryMaker,bcm.icon as mainCategoryIcon, bcm.iconImgLocation as categoryIconImage, bcm.id as mainCategoryId,
GROUP_CONCAT(DISTINCT ct.name) as typeName,
bk.id as bookmark,
count(distinct cr.id) as nr_reviews,
cn.country_name as countryName
, GROUP_CONCAT(DISTINCT l.latitude,'|',l.longitude,'|',l.street_number,'|',l.address,'|',l.city,'|',l.county,'|',l.postalCode,'|',l.phone,'|',l.province,'|',l.area separator '#') as locations
,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name
from brew_jbusinessdirectory_companies cp
left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId
left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1
left join brew_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1
left join brew_jbusinessdirectory_company_locations l on cp.id = l.company_id
left join brew_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and cr.approved=2
left join brew_jbusinessdirectory_countries cn on cp.countryId=cn.id
left join brew_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId)
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 inv.state= 1 and (NOW() between inv.start_date and inv.end_date) 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_package_fields pf on p.id=pf.package_id
left join brew_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1
where 1 and cp.id in (10713,11115,15657,15658,6186,15659,6369,6411,6441,6624,6709,6897,6917,15660,7305,7487,7627,7857,8300,8353,15661,15662,16057,8632,8719,9061,9219,15663,10035,10053,15664,10317,10486,10675,15665,15666,15667,15668,10972,15669,15670,15671,11242,11296,11487)
group by cp.id
) as slec
where 1
order by featured desc, packageOrder desc, companyName asc
4ms37.27KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`
356μs2.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 = 10713 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
272μs2.23KB/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 = 10713 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
155μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`
205μ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=10713
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
130μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`
317μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 10713
82μ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=10713
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 desc
697μs21.42KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 11115 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
165μs2.23KB/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 = 11115 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
163μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=11115
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 11115
89μ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=11115
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 desc
667μs21.42KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15657 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
145μ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 = 15657 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
140μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15657
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15657
71μ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=15657
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
557μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15658 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
143μ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 = 15658 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
151μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15658
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
141μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15658
72μ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=15658
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
587μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 6186 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
143μ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 = 6186 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
158μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=6186
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
125μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 6186
71μ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=6186
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
565μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15659 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
144μs10.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 = 15659 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
153μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15659
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
114μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15659
70μ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=15659
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
616μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 6369 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
147μ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 = 6369 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
169μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=6369
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
124μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 6369
71μ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=6369
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
571μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 6411 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
144μ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 = 6411 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=6411
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
132μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 6411
70μ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=6411
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
657μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 6441 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
147μ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 = 6441 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
155μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=6441
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 6441
70μ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=6441
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
543μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 6624 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
142μ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 = 6624 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
136μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=6624
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 6624
71μ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=6624
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
587μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 6709 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
145μ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 = 6709 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
138μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=6709
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 6709
94μ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=6709
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
543μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 6897 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
152μ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 = 6897 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
141μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=6897
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
117μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 6897
73μ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=6897
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
609μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 6917 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
161μ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 = 6917 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
142μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=6917
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
128μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 6917
70μ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=6917
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
590μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15660 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
147μ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 = 15660 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15660
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15660
80μ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=15660
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
566μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 7305 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
156μ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 = 7305 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=7305
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 7305
69μ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=7305
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
542μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 7487 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
311μ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 = 7487 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
323μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=7487
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
143μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 7487
72μ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=7487
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
619μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 7627 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
143μ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 = 7627 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=7627
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 7627
71μ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=7627
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
577μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 7857 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
143μ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 = 7857 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
136μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=7857
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 7857
87μ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=7857
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
575μs37.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 8300 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
151μ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 = 8300 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
152μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=8300
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
121μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 8300
73μ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=8300
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
554μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 8353 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
142μ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 = 8353 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=8353
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
134μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 8353
75μ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=8353
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
583μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15661 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
191μ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 = 15661 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15661
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15661
71μ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=15661
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
572μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15662 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
144μ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 = 15662 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15662
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15662
69μ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=15662
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
550μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 16057 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
144μ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 = 16057 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=16057
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
114μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 16057
72μ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=16057
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
561μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 8632 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
142μ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 = 8632 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
148μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=8632
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 8632
88μ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=8632
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
603μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 8719 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
148μ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 = 8719 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
139μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=8719
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 8719
82μ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=8719
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
545μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 9061 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
156μ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 = 9061 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
138μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=9061
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
123μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 9061
71μ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=9061
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
619μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 9219 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
200μ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 = 9219 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
190μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=9219
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
130μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 9219
77μ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=9219
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
661μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15663 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
148μ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 = 15663 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
156μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15663
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15663
71μ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=15663
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
574μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 10035 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
146μ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 = 10035 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
139μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=10035
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
123μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 10035
69μ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=10035
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
543μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 10053 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
140μ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 = 10053 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
134μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=10053
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
108μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 10053
67μ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=10053
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
542μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15664 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
185μ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 = 15664 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
136μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15664
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
128μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15664
70μ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=15664
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
561μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 10317 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
154μ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 = 10317 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=10317
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
143μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 10317
72μ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=10317
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
556μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 10486 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
144μ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 = 10486 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
140μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=10486
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 10486
72μ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=10486
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
531μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 10675 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
154μ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 = 10675 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
141μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=10675
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
111μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 10675
71μ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=10675
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
548μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15665 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
185μ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 = 15665 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
151μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15665
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
153μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15665
77μ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=15665
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
586μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15666 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
183μ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 = 15666 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
165μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15666
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
133μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15666
78μ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=15666
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
717μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15667 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
202μ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 = 15667 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
162μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15667
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
134μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15667
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=15667
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
686μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15668 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
169μ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 = 15668 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
175μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15668
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
139μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15668
108μ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=15668
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
639μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 10972 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
152μ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 = 10972 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
186μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=10972
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
114μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 10972
81μ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=10972
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
566μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15669 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
145μ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 = 15669 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
153μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15669
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
111μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15669
100μ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=15669
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
569μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15670 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
146μ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 = 15670 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
161μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15670
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
117μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15670
72μ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=15670
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
589μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 15671 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
160μ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 = 15671 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
141μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=15671
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
144μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 15671
74μ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=15671
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
608μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 11242 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
147μ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 = 11242 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
138μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=11242
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
128μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 11242
73μ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=11242
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
546μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 11296 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
142μ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 = 11296 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
142μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=11296
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
127μs35.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 11296
128μ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=11296
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
614μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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 = 11487 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
173μ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 = 11487 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
229μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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=11487
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
166μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect id, package_id from brew_jbusinessdirectory_companies where id= 11487
147μ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=11487
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
645μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect * from brew_jbusinessdirectory_categories c
where c.id=243
107μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50CopySHOW FULL COLUMNS FROM `brew_jbusinessdirectory_attributes`
234μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM brew_jbusinessdirectory_companies WHERE approved=2 ORDER BY letter
6.47ms1.45KB/administrator/components/com_jbusinessdirectory/tables/company.php:1524Copyselect * from brew_jbusinessdirectory_categories c
where c.id=243
120μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copyselect * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name
313μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copyselect * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name
495μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
178μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
96μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
102μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
96μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
219μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
173μ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'
154μ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'
123μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
113μ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'
145μ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'
100μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
104μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
109μ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'
90μ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'
109μ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 *
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'
92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
137μ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
148μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT `value`
FROM `brew_admintools_storage`
WHERE `key` = 'criticalfiles'
97μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185CopySELECT *
FROM `brew_template_styles`
WHERE `client_id` = 0 AND `id` = '451'
111μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT `session_id`
FROM `brew_session`
WHERE `session_id` = ?
148μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `brew_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
1.96ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy