Results 1 - 20 of 20

Filter

Clear
MarkerMarker
2
8
Marker
2
5
Leaflet © OpenStreetMap contributors
14.192MBMemory Usage485msRequest Duration
Joomla! Version5.2.2
PHP Version8.1.32
Identityguest
Response200
Templatej-directory
Database
Server
mysql
Version
10.6.21-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:55 [ "CONTEXT_DOCUMENT_ROOT" => "/home/nicklesu/public_html/usbreweryguide.com" "CONTEXT_P...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745441892 "last" => 1745441892...
registry
array:3 [ "data" => array:1 [ "com_jbusinessdirectory" => array:1 [ "listing" => array:1...
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
menuId
961
categorySearch
null
searchkeyword
""
searchkeywordLocation
""
typeSearch
""
citySearch
""
starRating
""
regionSearch
""
countrySearch
""
zipcode
""
customAtrributes
""
letter
""
radius
100
provinceSearch
""
areaSearch
""
filter-by-fav
""
filterParams
""
location
""
geo-latitude
""
geo-longitude
""
geo-country
""
geolocation
""
location-detected
""
categories
""
onlyLocal
0
categoryId
249
listing-search
true
menuItemId
961
showCustomMarkers
1
moreFilters
null
lSearchType
1
  • afterLoad (414.6KB) (90.31ms)
  • afterInitialise (3.79MB) (141ms)
  • afterRoute (810.58KB) (12.26ms)
  • beforeRenderComponent com_jbusinessdirectory (46.22KB) (666μs)
  • afterRenderComponent com_jbusinessdirectory (4.36MB) (172ms)
  • afterDispatch (3.21KB) (1.06ms)
  • beforeRenderRawModule mod_menu (Main Menu) (651.19KB) (47.05ms)
  • afterRenderRawModule mod_menu (Main Menu) (77.56KB) (3.35ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (7μs)
  • afterRenderModule mod_menu (Main Menu) (50.59KB) (2.88ms)
  • afterRender (396.18KB) (12.9ms)
  • 1 x afterRenderComponent com_jbusinessdirectory (4.36MB) (35.47%)
    172ms
    1 x afterInitialise (3.79MB) (29.15%)
    141ms
    1 x afterLoad (414.6KB) (18.63%)
    90.31ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (651.19KB) (9.71%)
    47.05ms
    1 x afterRender (396.18KB) (2.66%)
    12.90ms
    1 x afterRoute (810.58KB) (2.53%)
    12.26ms
    1 x afterRenderRawModule mod_menu (Main Menu) (77.56KB) (0.69%)
    3.35ms
    1 x afterRenderModule mod_menu (Main Menu) (50.59KB) (0.59%)
    2.88ms
    1 x afterDispatch (3.21KB) (0.22%)
    1.06ms
    1 x beforeRenderComponent com_jbusinessdirectory (46.22KB) (0.14%)
    666μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    7μs
176 statements were executed, 38 of which were duplicates, 138 unique64.36ms1.94MB
  • SELECT @@SESSION.sql_mode;63μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `brew_session` WHERE `session_id` = ?657μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 175μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `brew_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.36ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `brew_viewlevels`105μs1.56KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `brew_usergroups` AS `a` LEFT JOIN `brew_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest136μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'146μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`71μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'172μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'223μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM `brew_admintools_ipautoban`310μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
  • SELECT `ip` FROM `brew_admintools_ipblock`78μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
  • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'115μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC131μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas287μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_date_formats fas WHERE fas.id ='3'87μs1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78Copy
  • SELECT fas.* FROM brew_jbusinessdirectory_currencies fas WHERE fas.currency_id ='143'69μs3.5KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'north-dakota-breweries' LIMIT 1164μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application` FROM `brew_admintools_wafblacklists` WHERE `enabled` = 196μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'114μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'north-dakota-breweries' LIMIT 1166μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225Copy
  • SELECT * FROM brew_jbusinessdirectory_mobile_app_config153μs1.94KB/components/com_jbusinessdirectory/helpers/utils.php:9443Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`267μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes93μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`402μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`264μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select * from brew_jbusinessdirectory_categories c where c.id=249126μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • select * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name315μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
  • insert into brew_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values ('2','1','2025-04-23','249','0')170μs0B/components/com_jbusinessdirectory/helpers/utils.php:7651Copy
  • select * from brew_jbusinessdirectory_categories c where c.id=249100μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • select * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name254μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
  • SET SQL_BIG_SELECTS=124μs0B/components/com_jbusinessdirectory/helpers/utils.php:6906Copy
  • select * 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 (249,249) 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 11.47ms12.3KB/administrator/components/com_jbusinessdirectory/tables/company.php:1156Copy
  • SET SESSION group_concat_max_len = 1000027μs0B/components/com_jbusinessdirectory/helpers/utils.php:6887Copy
  • select 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 (249,249) 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 10011.48ms2.58KB/administrator/components/com_jbusinessdirectory/tables/company.php:1122Copy
  • select 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 (7746,7949,15722,6693,15723,15724,16761,7101,15725,15726,15727,15728,15729,16759,9047,15730,15731,10324,10833,10969) group by cp.id ) as slec where 1 order by featured desc, packageOrder desc, companyName asc3.06ms20.83KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`299μs2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7746 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday236μs2.23KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7746 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday151μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`237μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7746 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering144μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`298μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 774682μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7746 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 desc684μs21.42KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7949 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday197μs2.23KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7949 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday168μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7949 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering138μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 794980μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7949 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 desc724μs21.42KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15722 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday162μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15722 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday139μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15722 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering124μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 15722102μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15722 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 desc603μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 6693 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday259μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 6693 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday145μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6693 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering156μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 669386μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=6693 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 desc645μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15723 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday156μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15723 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday137μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15723 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1572379μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15723 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 desc621μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15724 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday171μs10.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15724 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday140μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15724 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1572478μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15724 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 desc598μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16761 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday172μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16761 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday153μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=16761 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1676175μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=16761 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 desc556μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7101 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday159μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7101 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday370μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7101 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering147μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 710187μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7101 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 desc778μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15725 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday174μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15725 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday147μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15725 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1572570μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15725 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 desc562μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15726 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday146μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15726 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday144μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15726 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering114μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1572670μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15726 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 desc541μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15727 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday139μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15727 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday140μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15727 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering128μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1572770μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15727 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 desc551μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15728 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday142μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15728 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday134μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15728 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1572867μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15728 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 desc534μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15729 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday143μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15729 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday136μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15729 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering131μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1572969μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15729 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 desc511μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16759 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday156μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16759 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday1.35ms2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=16759 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering121μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1675970μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=16759 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 desc537μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 9047 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday146μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 9047 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday133μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=9047 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 904798μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=9047 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 desc533μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15730 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15730 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday148μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15730 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1573073μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15730 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 desc532μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15731 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday194μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15731 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday143μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15731 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering125μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1573173μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=15731 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 desc625μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10324 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday144μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10324 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday136μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10324 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering141μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1032469μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=10324 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 desc574μs37.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10833 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday148μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10833 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday134μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10833 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering142μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 108334.1ms912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=10833 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 desc796μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10969 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday151μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10969 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday145μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10969 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select id, package_id from brew_jbusinessdirectory_companies where id= 1096968μs912B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copy
  • select * , p.id as pck_id, inv.id as invoice_id, max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS from brew_jbusinessdirectory_packages p left join brew_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=10969 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 desc557μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • select * from brew_jbusinessdirectory_categories c where c.id=249103μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_attributes`227μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM brew_jbusinessdirectory_companies WHERE approved=2 ORDER BY letter6.2ms1.45KB/administrator/components/com_jbusinessdirectory/tables/company.php:1524Copy
  • select * from brew_jbusinessdirectory_categories c where c.id=249138μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
  • select * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name297μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `brew_modules` AS `m` LEFT JOIN `brew_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `brew_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`809μs2.22KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • select * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name511μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'220μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'95μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'91μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'94μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'181μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'114μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'98μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'117μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'93μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'98μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'118μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'95μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'135μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'166μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'117μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'145μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'111μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'101μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'103μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'93μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'96μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'91μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'97μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'90μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'97μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `brew_scheduler_tasks` AS `a` WHERE `a`.`state` = 1136μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'criticalfiles'92μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
  • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'102μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `brew_session` WHERE `session_id` = ?147μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `brew_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.27ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy