Results 1 - 35 of 35
Relevance

    Wyoming Breweries

    Search for breweries in Wyoming using our map and directory of WY breweries. Find a brewery near you, or search for other breweries in WY!
    Search for breweries in Wyoming using our map and directory of WY breweries. Find a brewery near you, or search for other breweries in WY! Less

    Filter

    Clear
    5
    5
    5
    7
    3
    2
    7
    Marker
    Leaflet © OpenStreetMap contributors
    J! InfoRequestSessionProfileQueries250Log
    15.559MBMemory Usage437msRequest Duration
    Joomla! Version5.2.2
    PHP Version8.1.31
    Identityguest
    Response200
    Templatej-directory
    Database
    Server
    mysql
    Version
    10.6.21-MariaDB
    Collation
    latin1_swedish_ci
    Conn Collation
    utf8mb4_general_ci
    $_GET
    []
    $_POST
    []
    $_SESSION
    array:1 [ "joomla" => "***redacted***" ]
    $_COOKIE
    array:1 [ "7446a39c0487e807b461c8b1a207dfa7" => "16eec620bec733cc912bb4f67bd294b7" ]
    $_SERVER
    array:56 [ "CONTEXT_DOCUMENT_ROOT" => "/home/nicklesu/public_html/usbreweryguide.com" "CONTEXT_P...
    session
    array:3 [ "counter" => 4 "timer" => array:3 [ "start" => 1741917811 "last" => 1741917817...
    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
    978
    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
    266
    listing-search
    true
    menuItemId
    978
    showCustomMarkers
    1
    moreFilters
    null
    lSearchType
    1
    • afterLoad (414.6KB) (42.67ms)
    • afterInitialise (3.78MB) (139ms)
    • afterRoute (811.03KB) (14.16ms)
    • beforeRenderComponent com_jbusinessdirectory (46.25KB) (660μs)
    • afterRenderComponent com_jbusinessdirectory (5.74MB) (178ms)
    • afterDispatch (3.52KB) (1.2ms)
    • beforeRenderRawModule mod_menu (Main Menu) (634.88KB) (41.76ms)
    • afterRenderRawModule mod_menu (Main Menu) (189KB) (2.88ms)
    • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
    • afterRenderModule mod_menu (Main Menu) (50.59KB) (2.43ms)
    • afterRender (500.49KB) (12.91ms)
    • 1 x afterRenderComponent com_jbusinessdirectory (5.74MB) (40.73%)
      178ms
      1 x afterInitialise (3.78MB) (31.87%)
      139ms
      1 x afterLoad (414.6KB) (9.77%)
      42.67ms
      1 x beforeRenderRawModule mod_menu (Main Menu) (634.88KB) (9.57%)
      41.76ms
      1 x afterRoute (811.03KB) (3.24%)
      14.16ms
      1 x afterRender (500.49KB) (2.96%)
      12.91ms
      1 x afterRenderRawModule mod_menu (Main Menu) (189KB) (0.66%)
      2.88ms
      1 x afterRenderModule mod_menu (Main Menu) (50.59KB) (0.56%)
      2.43ms
      1 x afterDispatch (3.52KB) (0.27%)
      1.20ms
      1 x beforeRenderComponent com_jbusinessdirectory (46.25KB) (0.15%)
      660μs
      1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
      5μs
    250 statements were executed, 38 of which were duplicates, 212 unique70.25ms2.4MB
    UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5
    • SELECT @@SESSION.sql_mode;48μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
    • SELECT `data` FROM `brew_session` WHERE `session_id` = ?117μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
    • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 178μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
    • UPDATE `brew_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id1.98ms992BParams/libraries/src/Session/MetadataManager.php:316Copy
    • SELECT `id`,`rules` FROM `brew_viewlevels`120μs1.52KB/libraries/src/Access/Access.php:955Copy
    • SELECT `b`.`id` FROM `brew_usergroups` AS `a` LEFT JOIN `brew_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest132μs1.63KBParams/libraries/src/Access/Access.php:868Copy
    • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'156μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
    • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`73μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
    • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'166μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
    • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'326μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
    • SELECT * FROM `brew_admintools_ipautoban`317μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
    • SELECT `ip` FROM `brew_admintools_ipblock`106μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
    • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'432μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
    • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC89μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas353μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_date_formats fas WHERE fas.id ='3'82μs1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_currencies fas WHERE fas.currency_id ='143'66μs3.5KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
    • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'wyoming-breweries' LIMIT 1162μ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` = 190μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'107μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'wyoming-breweries' LIMIT 1139μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225Copy
    • SELECT * FROM brew_jbusinessdirectory_mobile_app_config151μs1.94KB/components/com_jbusinessdirectory/helpers/utils.php:9443Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`231μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • SELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes89μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`410μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`253μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=266116μ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, name340μ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-03-14','266','0')142μs0B/components/com_jbusinessdirectory/helpers/utils.php:7651Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=26694μ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, name280μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SET SQL_BIG_SELECTS=125μ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 (266,266) 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.45ms12.61KB/administrator/components/com_jbusinessdirectory/tables/company.php:1156Copy
    • SET SESSION group_concat_max_len = 1000026μ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 (266,266) 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.11ms2.89KB/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 (10787,6140,6208,6648,6704,6751,16683,7361,16684,16685,14574,8175,8240,16686,8506,11728,9101,9246,9412,9413,9464,9870,16689,10378,16690,16691,16692,10797,16693,16694,16695,16696,11113,11664,11727) group by cp.id ) as slec where 1 order by featured desc, packageOrder desc, companyName asc2.74ms37.14KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`280μ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 = 10787 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday216μ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 = 10787 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday155μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`213μ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=10787 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
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`292μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1078774μ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=10787 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 desc639μ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 = 6140 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday161μ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 = 6140 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=6140 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering110μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 614066μ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=6140 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 desc519μ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 = 6208 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 = 6208 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday157μ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=6208 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= 620865μ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=6208 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 desc526μ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 = 6648 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 = 6648 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday135μ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=6648 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering111μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 664865μ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=6648 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 desc542μ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 = 6704 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday137μ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 = 6704 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=6704 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering137μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 670478μ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=6704 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 desc527μ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 = 6751 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday143μ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 = 6751 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=6751 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering116μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 675166μ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=6751 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 desc509μ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 = 16683 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 = 16683 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=16683 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering107μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1668366μ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=16683 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 desc501μ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 = 7361 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday145μ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 = 7361 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday135μ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=7361 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= 736166μ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=7361 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 desc527μ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 = 16684 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μ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 = 16684 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=16684 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= 1668466μ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=16684 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 desc520μ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 = 16685 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday147μ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 = 16685 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μ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=16685 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering111μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1668568μ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=16685 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 desc529μ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 = 14574 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday145μ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 = 14574 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=14574 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering117μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1457466μ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=14574 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 desc507μ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 = 8175 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday141μ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 = 8175 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=8175 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering107μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 817573μ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=8175 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 desc521μ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 = 8240 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday145μ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 = 8240 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
    • 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=8240 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= 824065μ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=8240 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 desc504μ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 = 16686 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday136μ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 = 16686 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday150μ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=16686 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering111μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1668663μ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=16686 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 desc526μ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 = 8506 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μ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 = 8506 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=8506 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= 850667μ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=8506 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 desc521μ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 = 11728 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μ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 = 11728 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday130μ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=11728 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering134μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1172873μ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=11728 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 desc521μ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 = 9101 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday149μ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 = 9101 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday154μ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=9101 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering108μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 910185μ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=9101 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 = 9246 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday153μ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 = 9246 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=9246 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering106μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 924666μ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=9246 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 desc527μ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 = 9412 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 = 9412 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=9412 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering116μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 941266μ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=9412 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 desc521μ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 = 9413 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday136μ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 = 9413 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday146μ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=9413 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering107μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 941365μ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=9413 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 = 9464 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 = 9464 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday132μ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=9464 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering108μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 946466μ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=9464 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 desc565μ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 = 9870 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 = 9870 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday131μ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=9870 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering126μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 987066μ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=9870 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 desc500μ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 = 16689 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μ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 = 16689 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=16689 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering126μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1668968μ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=16689 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 desc524μ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 = 10378 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday155μ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 = 10378 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday152μ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=10378 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering105μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1037876μ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=10378 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 desc507μ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 = 16690 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μ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 = 16690 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=16690 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= 1669094μ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=16690 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 = 16691 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday140μ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 = 16691 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday152μ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=16691 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering110μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1669165μ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=16691 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 desc526μ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 = 16692 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 = 16692 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday155μ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=16692 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering111μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1669285μ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=16692 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 desc569μ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 = 10797 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 = 10797 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=10797 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= 1079772μ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=10797 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 desc559μ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 = 16693 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μ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 = 16693 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday131μ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=16693 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering127μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1669365μ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=16693 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 desc553μ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 = 16694 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 = 16694 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday132μ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=16694 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering107μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1669466μ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=16694 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 desc507μ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 = 16695 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday157μ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 = 16695 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday132μ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=16695 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering106μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1669565μ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=16695 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 desc527μ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 = 16696 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday140μ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 = 16696 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=16696 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= 1669667μ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=16696 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 desc527μ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 = 11113 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 = 11113 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday160μ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=11113 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering116μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1111367μ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=11113 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 desc519μ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 = 11664 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 = 11664 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=11664 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= 1166465μ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=11664 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 desc531μ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 = 11727 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μ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 = 11727 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=11727 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering117μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 11727131μ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=11727 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 desc535μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=266117μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_attributes`228μ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.18ms1.45KB/administrator/components/com_jbusinessdirectory/tables/company.php:1524Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=266108μ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, name327μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • select * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name524μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'164μ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'90μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'109μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'192μ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'95μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'104μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'94μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'102μ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'98μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'141μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'100μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'104μ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'95μ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'107μ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'112μ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'90μ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 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` = 1140μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
    • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'criticalfiles'80μ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` = ?120μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
    • UPDATE `brew_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.17ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy