Results 1 - 12 of 12
Relevance

    Filter

    Clear
    2
    2
    4
    MarkerMarkerMarkerMarker
    Leaflet © OpenStreetMap contributors
    J! InfoRequestSessionProfileQueries136Log
    13.457MBMemory Usage379msRequest Duration
    Joomla! Version5.2.2
    PHP Version8.1.31
    Identityguest
    Response200
    Templatej-directory
    Database
    Server
    mysql
    Version
    10.6.21-MariaDB
    Collation
    latin1_swedish_ci
    Conn Collation
    utf8mb4_general_ci
    $_GET
    []
    $_POST
    []
    $_SESSION
    array:1 [ "joomla" => "***redacted***" ]
    $_COOKIE
    array:2 [ "7446a39c0487e807b461c8b1a207dfa7" => "9220ca54d4dd504f0d5cd0a81c940592" "jbdViewedLis...
    $_SERVER
    array:56 [ "CONTEXT_DOCUMENT_ROOT" => "/home/nicklesu/public_html/usbreweryguide.com" "CONTEXT_P...
    session
    array:3 [ "counter" => 9 "timer" => array:3 [ "start" => 1741918246 "last" => 1741918264...
    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
    951
    company_yelp_id
    null
    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
    239
    listing-search
    true
    menuItemId
    951
    showCustomMarkers
    1
    moreFilters
    null
    lSearchType
    1
    • afterLoad (414.6KB) (41.37ms)
    • afterInitialise (3.78MB) (135ms)
    • afterRoute (810.58KB) (11.79ms)
    • beforeRenderComponent com_jbusinessdirectory (46.22KB) (684μs)
    • afterRenderComponent com_jbusinessdirectory (3.64MB) (125ms)
    • afterDispatch (3.21KB) (1.11ms)
    • beforeRenderRawModule mod_menu (Main Menu) (635.19KB) (43.5ms)
    • afterRenderRawModule mod_menu (Main Menu) (77.56KB) (3.61ms)
    • beforeRenderModule mod_menu (Main Menu) (704B) (7μs)
    • afterRenderModule mod_menu (Main Menu) (50.59KB) (2.34ms)
    • afterRender (368.18KB) (12.29ms)
    • 1 x afterInitialise (3.78MB) (35.79%)
      135ms
      1 x afterRenderComponent com_jbusinessdirectory (3.64MB) (33.1%)
      125ms
      1 x beforeRenderRawModule mod_menu (Main Menu) (635.19KB) (11.49%)
      43.50ms
      1 x afterLoad (414.6KB) (10.93%)
      41.37ms
      1 x afterRender (368.18KB) (3.25%)
      12.29ms
      1 x afterRoute (810.58KB) (3.11%)
      11.79ms
      1 x afterRenderRawModule mod_menu (Main Menu) (77.56KB) (0.96%)
      3.61ms
      1 x afterRenderModule mod_menu (Main Menu) (50.59KB) (0.62%)
      2.34ms
      1 x afterDispatch (3.21KB) (0.29%)
      1.11ms
      1 x beforeRenderComponent com_jbusinessdirectory (46.22KB) (0.18%)
      684μs
      1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
      7μs
    136 statements were executed, 38 of which were duplicates, 98 unique45.23ms1.7MB
    UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5
    • SELECT @@SESSION.sql_mode;77μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
    • SELECT `data` FROM `brew_session` WHERE `session_id` = ?140μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
    • SELECT `session_id` FROM `brew_session` WHERE `session_id` = :session_id LIMIT 182μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
    • UPDATE `brew_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id104μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
    • SELECT `id`,`rules` FROM `brew_viewlevels`89μs1.52KB/libraries/src/Access/Access.php:955Copy
    • SELECT `b`.`id` FROM `brew_usergroups` AS `a` LEFT JOIN `brew_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest121μs1.63KBParams/libraries/src/Access/Access.php:868Copy
    • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'cparams'143μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
    • SELECT `option`,`view`,`query` FROM `brew_admintools_wafexceptions`71μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
    • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'165μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
    • SELECT `params` FROM `brew_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'224μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
    • SELECT * FROM `brew_admintools_ipautoban`291μs28.94KB/plugins/system/admintools/src/Utility/Cache.php:126Copy
    • SELECT `ip` FROM `brew_admintools_ipblock`98μs1.7KB/plugins/system/admintools/src/Utility/Cache.php:136Copy
    • SELECT * FROM `brew_admintools_storage` WHERE `key` LIKE 'timestamp_%'87μs912B/plugins/system/admintools/src/Feature/Base.php:255Copy
    • SELECT `source`,`dest`,`keepurlparams` FROM `brew_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC88μs960B/plugins/system/admintools/src/Utility/Cache.php:162Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_application_settings fas274μs41.05KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_date_formats fas WHERE fas.id ='3'86μs1.06KB/components/com_jbusinessdirectory/helpers/utils.php:78Copy
    • SELECT fas.* FROM brew_jbusinessdirectory_currencies fas WHERE fas.currency_id ='143'67μs3.5KB/components/com_jbusinessdirectory/helpers/utils.php:87Copy
    • SELECT * FROM brew_jbusinessdirectory_categories c where c.type=1 and c.alias = 'mississippi-breweries' LIMIT 1168μ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` = 191μs1.27KB/plugins/system/admintools/src/Utility/Cache.php:182Copy
    • 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_jbusinessdirectory_categories c where c.type=1 and c.alias = 'mississippi-breweries' LIMIT 1154μs3.97KB/plugins/system/urltranslator/jbdrouter.php:225Copy
    • SELECT * FROM brew_jbusinessdirectory_mobile_app_config147μs1.94KB/components/com_jbusinessdirectory/helpers/utils.php:9443Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_default_attributes`266μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • SELECT id, name, listing_config as config FROM brew_jbusinessdirectory_default_attributes103μs2.19KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_companies`378μs3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_categories`273μs2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=239121μ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, name306μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • insert into brew_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values ('2','1','2025-03-14','239','0')134μs0B/components/com_jbusinessdirectory/helpers/utils.php:7651Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=23994μ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, name259μs4.83KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SET SQL_BIG_SELECTS=125μs0B/components/com_jbusinessdirectory/helpers/utils.php:6906Copy
    • select * from (select count(distinct cp.id) as nr_listings, cp.activity_radius,cp.featured, cp.id from brew_jbusinessdirectory_companies cp left join brew_jbusinessdirectory_company_category cc on cp.id=cc.companyId left join brew_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join brew_jbusinessdirectory_company_locations l on cp.id = l.company_id left join brew_jbusinessdirectory_orders inv on inv.company_id=cp.id left join brew_jbusinessdirectory_packages p on (inv.package_id=p.id and inv.state= 1 and (NOW() between inv.start_date and inv.end_date) and p.status=1 and 1) or (p.price=0 and (p.expiration_type=1 or cp.package_id = p.id) and p.status=1 and 1) where 1 and cc.categoryId in (239,239) 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.33ms12.17KB/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 (239,239) 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.04ms2.45KB/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 (9059,15563,7268,15564,6688,15565,15566,9372,9614,10857,16943,11733) group by cp.id ) as slec where 1 order by featured desc, packageOrder desc, companyName asc1.93ms20.7KB/administrator/components/com_jbusinessdirectory/tables/company.php:1135Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_providers`319μ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 = 9059 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday227μs2.23KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 9059 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday150μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_company_attributes`246μ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=9059 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering119μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_packages`303μs2.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 905976μ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=9059 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 4 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc632μ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 = 15563 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday160μ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 = 15563 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday143μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=15563 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= 1556383μ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=15563 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc507μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7268 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 = 7268 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=7268 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= 726882μ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=7268 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 desc516μ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 = 15564 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday154μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15564 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=15564 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= 1556468μ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=15564 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 desc539μ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 = 6688 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 = 6688 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=6688 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering122μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 668879μ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=6688 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 = 15565 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday143μs10.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15565 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=15565 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= 15565146μ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=15565 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc542μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 15566 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 = 15566 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=15566 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= 1556668μ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=15566 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc546μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 9372 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 = 9372 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=9372 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= 937269μ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=9372 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc527μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 9614 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 = 9614 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=9614 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= 961473μ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=9614 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 = 10857 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 = 10857 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday131μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=10857 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering107μs3.98KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
    • select id, package_id from brew_jbusinessdirectory_companies where id= 10857103μ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=10857 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 desc512μ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 = 16943 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 = 16943 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday138μs2.11KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
    • select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPARATOR '|#') options, GROUP_CONCAT(DISTINCT ao.id ORDER BY ao.ordering asc SEPARATOR '|#') optionsIDS, GROUP_CONCAT(DISTINCT ao.icon ORDER BY ao.ordering asc SEPARATOR '|#') optionsIcons, at.code as attributeTypeCode, GROUP_CONCAT(DISTINCT ca.value ORDER BY ca.value) as attributeValue from brew_jbusinessdirectory_attributes a left join brew_jbusinessdirectory_attribute_types AS at on at.id=a.type left join brew_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join brew_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=16943 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= 1694370μ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=16943 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc528μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from brew_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 11733 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 = 11733 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday183μ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=11733 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= 1173369μ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=11733 left join brew_jbusinessdirectory_package_fields pf on p.id=pf.package_id where p.status=1 and ( ( (inv.state= 1 and ( ( (( now() between inv.start_date and inv.end_date) or p.expiration_type=1) or (now() between inv.start_trial_date and inv.end_trial_date) ) )) ) or ( ((p.expiration_type=1 and p.price=0) or (p.id = 2 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc557μs21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=239104μs3.97KB/administrator/components/com_jbusinessdirectory/tables/category.php:50Copy
    • SHOW FULL COLUMNS FROM `brew_jbusinessdirectory_attributes`233μ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.23ms1.45KB/administrator/components/com_jbusinessdirectory/tables/company.php:1524Copy
    • select * from brew_jbusinessdirectory_categories c where c.id=239127μ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, name266μ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`759μs2.22KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
    • select * from brew_jbusinessdirectory_categories where published=1 order by lft, parent_id, name472μs38.95KB/administrator/components/com_jbusinessdirectory/tables/category.php:63Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'161μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'78μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'95μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'72μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'117μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'93μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'81μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'83μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'86μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'90μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'80μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'87μ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'94μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'79μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'78μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'85μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'84μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'76μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'74μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'89μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'77μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'76μs57.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'75μ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` = 1137μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
    • SELECT `value` FROM `brew_admintools_storage` WHERE `key` = 'criticalfiles'73μs856B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
    • SELECT * FROM `brew_template_styles` WHERE `client_id` = 0 AND `id` = '451'85μs41.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
    • SELECT `session_id` FROM `brew_session` WHERE `session_id` = ?85μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
    • UPDATE `brew_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.01ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy