Results 1 - 66 of 66
Relevance

    Filter

    Clear
    2
    4
    16
    2
    8
    Marker
    4
    2
    27
    22
    10
    34
    Leaflet © OpenStreetMap contributors
    J! InfoRequestSessionProfileQueries405Log
    18.135MBMemory Usage527msRequest Duration
    Joomla! Version5.2.2
    PHP Version8.1.32
    Identityguest
    Response200
    Templatej-directory
    Database
    Server
    mysql
    Version
    10.6.21-MariaDB
    Collation
    latin1_swedish_ci
    Conn Collation
    utf8mb4_general_ci
    $_GET
    []
    $_POST
    []
    $_SESSION
    array:1 [ "joomla" => "***redacted***" ]
    $_COOKIE
    []
    $_SERVER
    array:55 [ "CONTEXT_DOCUMENT_ROOT" => "/home/nicklesu/public_html/usbreweryguide.com" "CONTEXT_P...
    session
    array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743058348 "last" => 1743058348...
    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
    972
    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
    260
    listing-search
    true
    menuItemId
    972
    showCustomMarkers
    1
    moreFilters
    null
    lSearchType
    1
    • afterLoad (414.6KB) (43.66ms)
    • afterInitialise (3.77MB) (161ms)
    • afterRoute (810.58KB) (12.3ms)
    • beforeRenderComponent com_jbusinessdirectory (46.22KB) (635μs)
    • afterRenderComponent com_jbusinessdirectory (8.33MB) (242ms)
    • afterDispatch (3.21KB) (1.09ms)
    • beforeRenderRawModule mod_menu (Main Menu) (635.19KB) (44.97ms)
    • afterRenderRawModule mod_menu (Main Menu) (183.3KB) (2.98ms)
    • beforeRenderModule mod_menu (Main Menu) (704B) (6μs)
    • afterRenderModule mod_menu (Main Menu) (50.59KB) (2.35ms)
    • afterRender (732.3KB) (14.16ms)
    • 1 x afterRenderComponent com_jbusinessdirectory (8.33MB) (46.03%)
      242ms
      1 x afterInitialise (3.77MB) (30.6%)
      161ms
      1 x beforeRenderRawModule mod_menu (Main Menu) (635.19KB) (8.54%)
      44.97ms
      1 x afterLoad (414.6KB) (8.29%)
      43.66ms
      1 x afterRender (732.3KB) (2.69%)
      14.16ms
      1 x afterRoute (810.58KB) (2.34%)
      12.30ms
      1 x afterRenderRawModule mod_menu (Main Menu) (183.3KB) (0.57%)
      2.98ms
      1 x afterRenderModule mod_menu (Main Menu) (50.59KB) (0.45%)
      2.35ms
      1 x afterDispatch (3.21KB) (0.21%)
      1.09ms
      1 x beforeRenderComponent com_jbusinessdirectory (46.22KB) (0.12%)
      635μs
      1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
      6μs
    405 statements were executed, 38 of which were duplicates, 367 unique110ms3.38MB
    UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5
    • SELECT @@SESSION.sql_mode;105μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
    • SELECT `data` FROM `brew_session` WHERE `session_id` = ?897μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
    • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 1124μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
    • INSERT INTO `brew_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.27ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
    • SELECT `id`,`rules` FROM `brew_viewlevels`90μs1.56KB/libraries/src/Access/Access.php:955Copy
    • SELECT `b`.`id` FROM `brew_usergroups` AS `a` LEFT JOIN `brew_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest108μs1.63KBParams/libraries/src/Access/Access.php:868Copy
    • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'1.85ms856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
    • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`91μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
    • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'330μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
    • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'266μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
    • SELECT * FROM `brew_admintools_ipautoban`306μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
    • SELECT `ip` FROM `brew_admintools_ipblock`90μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
    • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'89μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
    • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC96μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas266μ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'75μs3.5KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
    • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'vermont-breweries' LIMIT 1161μ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` = 193μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'110μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'vermont-breweries' LIMIT 1142μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225Copy
    • SELECT * FROM brew_jbusinessdirectory_mobile_app_config165μs1.94KB/components/com_jbusinessdirectory/helpers/utils.php:9443Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`246μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • SELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes90μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`399μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`274μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=260120μ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, name291μ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-27','260','0')185μs0B/components/com_jbusinessdirectory/helpers/utils.php:7651Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=260106μ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, name257μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SET SQL_BIG_SELECTS=126μ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 (260,260) 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.84ms13.23KB/administrator/components/com_jbusinessdirectory/tables/company.php:1156Copy
    • SET SESSION group_concat_max_len = 1000030μ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 (260,260) 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 10012.09ms3.52KB/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 (11315,6023,6032,16385,6539,6583,6830,6980,7001,7043,7129,16387,16388,7749,7955,7988,8078,8082,8125,8176,8277,8285,16389,16390,8489,8539,8572,16391,16392,16393,8712,8807,8928,16394,16395,9051,16396,9181,9207,9289,9294,14557,16397,9674,9743,9908,16398,10146,10185,10253,10365,10386,16399,16400,10525,10715,10964,11055,11108,6172,11409,11462,11492,11588,11762,11763) group by cp.id ) as slec where 1 order by featured desc, packageOrder desc, companyName asc4.29ms53.77KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`322μ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 = 11315 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday255μ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 = 11315 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday156μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`287μ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=11315 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering120μ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= 1131583μ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=11315 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 desc652μ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 = 6023 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday162μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 6023 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=6023 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering118μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 602379μ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=6023 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 = 6032 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday142μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 6032 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=6032 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering125μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 603271μ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=6032 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 desc514μ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 = 16385 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday170μ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 = 16385 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=16385 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering129μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1638577μ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=16385 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 desc510μ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 = 6539 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 = 6539 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=6539 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= 653979μ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=6539 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 desc518μ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 = 6583 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday148μ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 = 6583 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday158μ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=6583 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering159μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 658370μ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=6583 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 = 6830 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 = 6830 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=6830 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 683068μ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=6830 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 desc544μ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 = 6980 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 = 6980 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=6980 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 698067μ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=6980 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 desc552μ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 = 7001 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 = 7001 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=7001 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= 700176μ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=7001 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 desc544μ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 = 7043 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 = 7043 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=7043 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering129μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 704369μ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=7043 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 = 7129 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday148μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7129 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=7129 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= 712969μ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=7129 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 desc547μ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 = 16387 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 = 16387 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=16387 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering120μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1638768μ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=16387 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 desc567μ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 = 16388 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 = 16388 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=16388 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= 1638868μ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=16388 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 desc536μ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 = 7749 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 = 7749 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=7749 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering155μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 774970μ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=7749 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 desc513μ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 = 7955 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 = 7955 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday148μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7955 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= 795583μ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=7955 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 desc540μ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 = 7988 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday152μ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 = 7988 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=7988 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= 798892μ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=7988 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 = 8078 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday187μ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 = 8078 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=8078 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= 807872μ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=8078 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 = 8082 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 8082 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=8082 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= 808270μ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=8082 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 desc538μ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 = 8125 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 = 8125 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=8125 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= 812567μ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=8125 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc537μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 8176 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 = 8176 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday184μ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=8176 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= 817667μ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=8176 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 desc550μ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 = 8277 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 = 8277 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=8277 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering118μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 827766μ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=8277 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 = 8285 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday177μ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 = 8285 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=8285 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= 828575μ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=8285 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 desc568μ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 = 16389 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 = 16389 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=16389 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering124μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1638986μ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=16389 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 desc518μ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 = 16390 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday182μ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 = 16390 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday180μ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=16390 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= 1639083μ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=16390 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 desc523μ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 = 8489 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday151μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 8489 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=8489 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 848974μ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=8489 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 desc536μ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 = 8539 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 = 8539 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=8539 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering146μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 853985μ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=8539 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 = 8572 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 = 8572 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=8572 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= 857271μ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=8572 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 = 16391 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday142μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16391 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday142μ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=16391 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= 1639167μ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=16391 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 desc653μ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 = 16392 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 = 16392 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday144μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=16392 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering118μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1639268μ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=16392 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc537μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16393 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 = 16393 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday182μ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=16393 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1639389μ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=16393 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 desc593μ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 = 8712 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 = 8712 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday158μ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=8712 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= 871269μ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=8712 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc537μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 8807 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 = 8807 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=8807 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering148μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 880769μ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=8807 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 = 8928 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 = 8928 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=8928 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering124μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 892870μ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=8928 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc511μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16394 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday159μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16394 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=16394 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= 16394118μ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=16394 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 desc546μ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 = 16395 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 = 16395 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=16395 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= 1639566μ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=16395 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 = 9051 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 = 9051 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday141μ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=9051 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= 905166μ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=9051 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 desc618μ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 = 16396 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 = 16396 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday149μ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=16396 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= 1639668μ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=16396 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 desc544μ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 = 9181 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 = 9181 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=9181 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 918169μ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=9181 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 desc563μ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 = 9207 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 = 9207 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=9207 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 920769μ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=9207 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 desc543μ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 = 9289 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday205μ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 = 9289 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=9289 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 928978μ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=9289 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 desc636μ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 = 9294 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday144μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 9294 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=9294 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 929469μ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=9294 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 desc554μ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 = 14557 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 = 14557 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday148μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14557 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= 1455772μ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=14557 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 desc583μ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 = 16397 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 = 16397 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=16397 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering120μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1639768μ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=16397 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 desc554μ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 = 9674 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 = 9674 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=9674 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering124μs35.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 967468μ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=9674 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 = 9743 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 = 9743 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=9743 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering178μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 974370μ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=9743 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 = 9908 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 = 9908 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=9908 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 990869μ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=9908 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 desc523μ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 = 16398 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday176μ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 = 16398 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=16398 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering120μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1639882μ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=16398 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 = 10146 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday152μ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 = 10146 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=10146 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering120μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1014668μ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=10146 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 desc536μ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 = 10185 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 = 10185 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=10185 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= 1018568μ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=10185 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 desc538μ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 = 10253 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 = 10253 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday149μ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=10253 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= 1025367μ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=10253 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 desc584μ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 = 10365 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 = 10365 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=10365 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering113μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1036569μ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=10365 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 desc544μ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 = 10386 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 = 10386 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=10386 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering118μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1038668μ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=10386 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μ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 = 16399 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 = 16399 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=16399 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering124μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1639999μ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=16399 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 desc545μ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 = 16400 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 = 16400 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=16400 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering112μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1640074μ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=16400 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 = 10525 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 = 10525 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=10525 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= 1052568μ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=10525 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 desc525μ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 = 10715 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 = 10715 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday140μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10715 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= 1071567μ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=10715 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 desc545μ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 = 10964 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 = 10964 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=10964 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= 1096469μ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=10964 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 = 11055 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 = 11055 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=11055 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering125μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1105570μ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=11055 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 = 11108 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 = 11108 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday163μ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=11108 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering124μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1110870μ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=11108 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 desc614μ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 = 6172 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday162μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 6172 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=6172 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 617275μ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=6172 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 desc588μ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 = 11409 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 = 11409 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=11409 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering147μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1140971μ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=11409 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 desc592μ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 = 11462 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 = 11462 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=11462 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering123μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1146269μ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=11462 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 desc540μ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 = 11492 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday204μ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 = 11492 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=11492 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1149268μ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=11492 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 desc515μ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 = 11588 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 = 11588 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=11588 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering187μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1158881μ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=11588 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 = 11762 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 = 11762 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=11762 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering115μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1176269μ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=11762 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 desc515μ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 = 11763 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 = 11763 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=11763 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= 1176381μ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=11763 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 desc528μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=260104μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_attributes`227μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • SELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM brew_jbusinessdirectory_companies WHERE approved=2 ORDER BY letter6.52ms1.45KB/administrator/components/com_jbusinessdirectory/tables/company.php:1524Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=260154μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
    • select * from brew_jbusinessdirectory_categories where published=1 and type = 1 order by lft, parent_id, name297μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • select * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name521μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'180μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'81μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'80μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'73μ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'111μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'117μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'176μ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'135μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'1.47ms41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'103μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'119μ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'91μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'89μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'110μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'102μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'96μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'115μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μ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'81μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'99μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT `session_id` FROM `brew_session` WHERE `session_id` = ?184μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
    • UPDATE `brew_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.05ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy