Results 1 - 41 of 41
Relevance

    Filter

    Clear
    2
    15
    2
    2
    18
    MarkerMarker
    Leaflet © OpenStreetMap contributors
    J! InfoRequestSessionProfileQueries281Log
    15.977MBMemory Usage467msRequest 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" => 1744539015 "last" => 1744539015...
    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
    963
    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
    251
    listing-search
    true
    menuItemId
    963
    showCustomMarkers
    1
    moreFilters
    null
    lSearchType
    1
    • afterLoad (414.6KB) (40.59ms)
    • afterInitialise (3.78MB) (145ms)
    • afterRoute (810.58KB) (12.56ms)
    • beforeRenderComponent com_jbusinessdirectory (46.22KB) (690μs)
    • afterRenderComponent com_jbusinessdirectory (6.16MB) (195ms)
    • afterDispatch (3.21KB) (1.34ms)
    • beforeRenderRawModule mod_menu (Main Menu) (691.19KB) (50.58ms)
    • afterRenderRawModule mod_menu (Main Menu) (77.56KB) (4ms)
    • beforeRenderModule mod_menu (Main Menu) (704B) (7μs)
    • afterRenderModule mod_menu (Main Menu) (50.59KB) (2.76ms)
    • afterRender (548.18KB) (14.19ms)
    • 1 x afterRenderComponent com_jbusinessdirectory (6.16MB) (41.72%)
      195ms
      1 x afterInitialise (3.78MB) (30.94%)
      145ms
      1 x beforeRenderRawModule mod_menu (Main Menu) (691.19KB) (10.83%)
      50.58ms
      1 x afterLoad (414.6KB) (8.69%)
      40.59ms
      1 x afterRender (548.18KB) (3.04%)
      14.19ms
      1 x afterRoute (810.58KB) (2.69%)
      12.56ms
      1 x afterRenderRawModule mod_menu (Main Menu) (77.56KB) (0.86%)
      4.00ms
      1 x afterRenderModule mod_menu (Main Menu) (50.59KB) (0.59%)
      2.76ms
      1 x afterDispatch (3.21KB) (0.29%)
      1.34ms
      1 x beforeRenderComponent com_jbusinessdirectory (46.22KB) (0.15%)
      690μs
      1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
      7μs
    281 statements were executed, 38 of which were duplicates, 243 unique89.55ms2.61MB
    UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5
    • SELECT @@SESSION.sql_mode;59μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
    • SELECT `data` FROM `brew_session` WHERE `session_id` = ?121μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
    • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 170μ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)6.8ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
    • SELECT `id`,`rules` FROM `brew_viewlevels`110μs1.56KB/libraries/src/Access/Access.php:955Copy
    • SELECT `b`.`id` FROM `brew_usergroups` AS `a` LEFT JOIN `brew_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest136μs1.63KBParams/libraries/src/Access/Access.php:868Copy
    • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'162μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
    • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`75μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
    • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'192μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
    • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'238μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
    • SELECT * FROM `brew_admintools_ipautoban`321μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
    • SELECT `ip` FROM `brew_admintools_ipblock`76μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
    • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'86μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
    • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC92μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas288μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_date_formats fas WHERE fas.id ='3'85μs1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_currencies fas WHERE fas.currency_id ='143'69μs3.5KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
    • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'oklahoma-breweries' LIMIT 1178μ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` = 1110μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'142μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'oklahoma-breweries' LIMIT 1144μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225Copy
    • SELECT * FROM brew_jbusinessdirectory_mobile_app_config149μs1.94KB/components/com_jbusinessdirectory/helpers/utils.php:9443Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`240μ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`445μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`267μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=251138μ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, name338μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • insert into brew_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values ('2','1','2025-04-13','251','0')153μs0B/components/com_jbusinessdirectory/helpers/utils.php:7651Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=25198μ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, name268μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SET SQL_BIG_SELECTS=124μs0B/components/com_jbusinessdirectory/helpers/utils.php:6906Copy
    • select * from (select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured, cp.id from brew_jbusinessdirectory_companies cp left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join brew_jbusinessdirectory_company_locations l on cp.id = l.company_id left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id left join brew_jbusinessdirectory_packages p on (inv.package_id=p.id and inv.state= 1 and (NOW() between inv.start_date and inv.end_date) and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1) where 1 and cc.categoryId in (251,251) 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.65ms12.73KB/administrator/components/com_jbusinessdirectory/tables/company.php:1156Copy
    • SET SESSION group_concat_max_len = 1000026μs0B/components/com_jbusinessdirectory/helpers/utils.php:6887Copy
    • select slec.* , companyName ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured from ( select cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering ,GROUP_CONCAT( DISTINCT cg.id) as categoryIds ,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name from brew_jbusinessdirectory_companies cp left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join brew_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1 left join brew_jbusinessdirectory_company_locations l on cp.id = l.company_id left join brew_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and cr.approved=2 left join brew_jbusinessdirectory_countries cn on cp.countryId=cn.id left join brew_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId) left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id left join brew_jbusinessdirectory_packages p on (inv.package_id=p.id and inv.state= 1 and (NOW() between inv.start_date and inv.end_date) and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1) left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id left join brew_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1 where 1 and cp.state=1 and cc.categoryId in (251,251) and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date)) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( (p.expiration_type=1 and p.price=0) or (p.id = cp.package_id and p.price=0)) ) and (cp.approved = 2 or cp.approved= -1) and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null) group by cp.id ) as slec where 1 having 1 order by featured desc, packageOrder desc, companyName asc LIMIT 10011.71ms3.02KB/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 (5999,6221,15836,6254,6478,6529,15837,6556,16778,15838,15839,6993,15840,15841,14517,7431,7585,7841,15842,9810,15843,15844,15845,10954,15847,9345,9560,15850,15851,15852,15853,8966,15854,10466,10478,10789,10968,15855,15856,15857,15858) group by cp.id ) as slec where 1 order by featured desc, packageOrder desc, companyName asc3.13ms37.27KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`318μ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 = 5999 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday195μ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 = 5999 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
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`225μ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=5999 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering145μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`338μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 599981μ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=5999 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 desc737μ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 = 6221 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 = 6221 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday171μ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=6221 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= 622171μ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=6221 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 = 15836 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 = 15836 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=15836 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1583667μ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=15836 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 = 6254 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday143μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 6254 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=6254 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= 625470μ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=6254 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 = 6478 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 = 6478 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6478 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= 647871μ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=6478 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 desc597μ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 = 6529 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday142μ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 = 6529 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday168μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=6529 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering121μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 652968μ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=6529 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 = 15837 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 = 15837 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=15837 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= 1583770μ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=15837 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 desc560μ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 = 6556 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 = 6556 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=6556 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= 6556106μ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=6556 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc598μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 16778 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 = 16778 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=16778 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= 1677877μ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=16778 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 = 15838 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 = 15838 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=15838 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= 1583874μ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=15838 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc535μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15839 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 = 15839 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=15839 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= 1583983μ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=15839 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 desc505μ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 = 6993 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday135μ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 = 6993 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=6993 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 699367μ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=6993 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 desc573μ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 = 15840 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday164μ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 = 15840 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=15840 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= 1584067μ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=15840 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 desc522μ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 = 15841 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 = 15841 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=15841 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= 1584167μ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=15841 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc532μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 14517 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday134μ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 = 14517 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday130μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=14517 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering106μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1451768μ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=14517 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc524μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7431 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 = 7431 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=7431 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= 743167μ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=7431 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 desc530μ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 = 7585 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 = 7585 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=7585 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering116μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 758571μ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=7585 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 desc549μ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 = 7841 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 = 7841 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=7841 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= 784181μ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=7841 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc541μ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 = 15842 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 = 15842 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=15842 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= 1584271μ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=15842 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 desc596μ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 = 9810 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 = 9810 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=9810 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering108μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 981068μ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=9810 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 = 15843 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 = 15843 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=15843 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= 1584368μ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=15843 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 = 15844 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 = 15844 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday146μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15844 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= 1584465μ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=15844 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 = 15845 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 = 15845 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=15845 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= 1584568μ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=15845 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 = 10954 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 = 10954 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=10954 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= 1095467μ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=10954 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 = 15847 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday167μ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 = 15847 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=15847 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1584768μ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=15847 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 = 9345 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday168μ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 = 9345 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=9345 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering133μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 934571μ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=9345 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 = 9560 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday150μ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 = 9560 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=9560 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering109μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 956075μ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=9560 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 = 15850 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 = 15850 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday173μ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=15850 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering128μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1585069μ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=15850 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 = 15851 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday143μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15851 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=15851 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= 1585166μ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=15851 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 desc555μ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 = 15852 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday153μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15852 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday139μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15852 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= 1585271μ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=15852 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 desc571μ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 = 15853 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday143μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15853 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=15853 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= 1585375μ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=15853 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 = 8966 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 = 8966 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=8966 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering141μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 896673μ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=8966 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 = 15854 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday150μ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 = 15854 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=15854 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering135μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1585469μ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=15854 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 desc522μ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 = 10466 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday174μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10466 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday153μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10466 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering177μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1046681μ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=10466 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 desc575μ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 = 10478 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 = 10478 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=10478 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering128μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1047871μ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=10478 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc557μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10789 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 = 10789 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday160μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10789 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= 1078972μ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=10789 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 = 10968 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday153μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 10968 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=10968 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= 1096886μ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=10968 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc535μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15855 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 = 15855 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=15855 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= 1585585μ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=15855 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 = 15856 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 = 15856 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=15856 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering108μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1585678μ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=15856 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 desc578μ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 = 15857 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday158μ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 = 15857 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday146μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15857 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering485μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1585775μ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=15857 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 desc561μ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 = 15858 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday168μ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 = 15858 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=15858 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering134μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 1585875μ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=15858 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 * from brew_jbusinessdirectory_categories c where c.id=251132μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_attributes`232μ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.3ms1.45KB/administrator/components/com_jbusinessdirectory/tables/company.php:1524Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=251158μ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, name301μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `brew_modules` AS `m` LEFT JOIN `brew_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `brew_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`853μs2.22KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
    • select * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name589μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'201μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'98μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'115μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'103μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'213μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'162μs73.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'101μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'149μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'99μ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'142μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'108μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'185μ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'107μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'106μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'118μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'94μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'93μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'101μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'100μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'92μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'143μ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'109μ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` = 1200μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
    • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'criticalfiles'110μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'134μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT `session_id` FROM `brew_session` WHERE `session_id` = ?148μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
    • UPDATE `brew_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?5.14ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy