Results 1 - 20 of 60
Filters
loading...

Filter

Clear

GET COMMUNITY CONNECTED

Commnunity Marketplace is connecting user communities. We are providing access to use, manage and even purchase your very own social community platform. By providing localized community platforms like Facebook, Groupon, YouTube, Uber and others we can effectively empower each community to effectively keep money local .

Check out a collection of our community sites for you to join and thrive from collected from GET COMMUNITY CONNECTED. If you want to use those, we would love to empower you to get your own community connected.

12.943MBMemory Usage306msRequest Duration
Joomla! Version4.4.4
PHP Version8.2.26
Identityguest
Response200
Templatej-network
Database
Server
mysql
Version
10.6.20-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "searchkeyword" => "local" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:72 [ "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => "/tmp" "TMP" => "/tmp" "TMPDIR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743871884 "last" => 1743871884...
registry
array:3 [ "data" => array:1 [ "com_jbusinessdirectory" => array:1 [ "listing" => array:1...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jomsocial_userip
"18.227.209.106"
menuId
1057
categorySearch
null
searchkeyword
"local"
searchkeywordLocation
""
typeSearch
""
citySearch
""
starRating
""
regionSearch
""
countrySearch
0
zipcode
""
customAtrributes
""
letter
""
radius
""
provinceSearch
""
areaSearch
""
filter-by-fav
""
filterParams
""
location
""
geo-latitude
""
geo-longitude
""
geo-country
""
geolocation
""
categories
""
onlyLocal
0
categoryId
null
listing-search
true
menuItemId
1057
showCustomMarkers
1
moreFilters
null
lSearchType
1
  • afterLoad (476.02KB) (2.19ms)
  • afterInitialise (3.04MB) (32.33ms)
  • afterRoute (988.08KB) (11.46ms)
  • beforeRenderComponent com_jbusinessdirectory (50.99KB) (974μs)
  • beforeRenderRawModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (3.42MB) (165ms)
  • afterRenderRawModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (119.22KB) (8.4ms)
  • beforeRenderModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (768B) (14μs)
  • afterRenderModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (9.38KB) (237μs)
  • afterRenderComponent com_jbusinessdirectory (625.42KB) (9.44ms)
  • afterDispatch (2.98KB) (269μs)
  • Before Access::preloadComponents (all components) (1.59MB) (21.8ms)
  • After Access::preloadComponents (all components) (188.52KB) (632μs)
  • Before Access::getAssetRules (id:137 name:com_jfbconnect) (2.43KB) (16μs)
  • After Access::getAssetRules (id:137 name:com_jfbconnect) (6.87KB) (59μs)
  • beforeRenderRawModule mod_menu (Offcanvas) (7.31KB) (167μs)
  • afterRenderRawModule mod_menu (Offcanvas) (14.44KB) (1.08ms)
  • beforeRenderModule mod_menu (Offcanvas) (704B) (5μs)
  • afterRenderModule mod_menu (Offcanvas) (13.7KB) (1.4ms)
  • beforeRenderRawModule mod_menu (POLICY) (568B) (55μs)
  • afterRenderRawModule mod_menu (POLICY) (66.63KB) (1.53ms)
  • beforeRenderModule mod_menu (POLICY) (704B) (7μs)
  • afterRenderModule mod_menu (POLICY) (36.34KB) (1.28ms)
  • beforeRenderRawModule mod_custom (GET COMMUNITY CONNECTED) (1.52KB) (61μs)
  • afterRenderRawModule mod_custom (GET COMMUNITY CONNECTED) (4.03KB) (539μs)
  • beforeRenderModule mod_custom (GET COMMUNITY CONNECTED) (720B) (5μs)
  • afterRenderModule mod_custom (GET COMMUNITY CONNECTED) (36.82KB) (1.59ms)
  • beforeRenderRawModule mod_jbusiness_user (User module) (3.16KB) (47μs)
  • afterRenderRawModule mod_jbusiness_user (User module) (204.94KB) (5.35ms)
  • beforeRenderModule mod_jbusiness_user (User module) (720B) (11μs)
  • afterRenderModule mod_jbusiness_user (User module) (68.67KB) (1.37ms)
  • afterRender (811.22KB) (37.81ms)
  • 1 x beforeRenderRawModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (3.42MB) (54.05%)
    165.39ms
    1 x afterRender (811.22KB) (12.36%)
    37.81ms
    1 x afterInitialise (3.04MB) (10.56%)
    32.33ms
    1 x Before Access::preloadComponents (all components) (1.59MB) (7.12%)
    21.80ms
    1 x afterRoute (988.08KB) (3.74%)
    11.46ms
    1 x afterRenderComponent com_jbusinessdirectory (625.42KB) (3.08%)
    9.44ms
    1 x afterRenderRawModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (119.22KB) (2.75%)
    8.40ms
    1 x afterRenderRawModule mod_jbusiness_user (User module) (204.94KB) (1.75%)
    5.35ms
    1 x afterLoad (476.02KB) (0.71%)
    2.19ms
    1 x afterRenderModule mod_custom (GET COMMUNITY CONNECTED) (36.82KB) (0.52%)
    1.59ms
    1 x afterRenderRawModule mod_menu (POLICY) (66.63KB) (0.5%)
    1.53ms
    1 x afterRenderModule mod_menu (Offcanvas) (13.7KB) (0.46%)
    1.40ms
    1 x afterRenderModule mod_jbusiness_user (User module) (68.67KB) (0.45%)
    1.37ms
    1 x afterRenderModule mod_menu (POLICY) (36.34KB) (0.42%)
    1.28ms
    1 x afterRenderRawModule mod_menu (Offcanvas) (14.44KB) (0.35%)
    1.08ms
    1 x beforeRenderComponent com_jbusinessdirectory (50.99KB) (0.32%)
    974μs
    1 x After Access::preloadComponents (all components) (188.52KB) (0.21%)
    632μs
    1 x afterRenderRawModule mod_custom (GET COMMUNITY CONNECTED) (4.03KB) (0.18%)
    539μs
    1 x afterDispatch (2.98KB) (0.09%)
    269μs
    1 x afterRenderModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (9.38KB) (0.08%)
    237μs
    1 x beforeRenderRawModule mod_menu (Offcanvas) (7.31KB) (0.05%)
    167μs
    1 x beforeRenderRawModule mod_custom (GET COMMUNITY CONNECTED) (1.52KB) (0.02%)
    61μs
    1 x After Access::getAssetRules (id:137 name:com_jfbconnect) (6.87KB) (0.02%)
    59μs
    1 x beforeRenderRawModule mod_menu (POLICY) (568B) (0.02%)
    55μs
    1 x beforeRenderRawModule mod_jbusiness_user (User module) (3.16KB) (0.02%)
    47μs
    1 x Before Access::getAssetRules (id:137 name:com_jfbconnect) (2.43KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (768B) (0%)
    14μs
    1 x beforeRenderModule mod_jbusiness_user (User module) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_menu (POLICY) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Offcanvas) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (GET COMMUNITY CONNECTED) (720B) (0%)
    5μs
299 statements were executed, 92 of which were duplicates, 207 unique140ms2.6MB
  • SELECT @@SESSION.sql_mode;75μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `n36ic_session` WHERE `session_id` = ?222μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `n36ic_session` WHERE `session_id` = :session_id LIMIT 1199μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `n36ic_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)180μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `n36ic_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1115μs34.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `n36ic_viewlevels`56μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `n36ic_usergroups` AS `a` LEFT JOIN `n36ic_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest69μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `n36ic_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`105μs25.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `n36ic_menu` AS `m` LEFT JOIN `n36ic_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.41ms20.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `n36ic_template_styles` AS `s` LEFT JOIN `n36ic_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 179μs40.86KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'55μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SET @@SESSION.sql_mode =''41μs0B/plugins/system/jomsocial.system/jomsocial.system.php:139Copy
  • SELECT manifest_cache FROM `n36ic_extensions` WHERE element = "com_affiliatetracker"42μs536B/plugins/system/affiliate_tracker/affiliate_tracker.php:203Copy
  • SELECT `id` FROM `n36ic_affiliate_tracker_accounts` WHERE `ref_word` = 'local-business' AND `publish` = '1'40μs520B/plugins/system/affiliate_tracker/affiliate_tracker.php:75Copy
  • SELECT `template` FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `home` = 139μs536B/plugins/system/helix3/helix3.php:247Copy
  • SELECT * FROM n36ic_rsform_config52μs1KB/administrator/components/com_rsform/helpers/config.php:50Copy
  • SELECT `session_id` FROM `n36ic_session` WHERE `session_id` = :session_id LIMIT 1112μs2.56KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `n36ic_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id132μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT setting,value FROM n36ic_jfbconnect_config57μs17.77KB/administrator/components/com_jfbconnect/models/config.php:304Copy
  • SELECT value FROM n36ic_jfbconnect_config WHERE setting="profile_joomla"92μs536B/libraries/sourcecoast/plugins/socialprofile.php:649Copy
  • SELECT value FROM n36ic_jfbconnect_config WHERE setting="profile_customdb"66μs536B/libraries/sourcecoast/plugins/socialprofile.php:649Copy
  • SELECT fas.* FROM n36ic_jbusinessdirectory_application_settings fas127μs40.73KB/components/com_jbusinessdirectory/helpers/utils.php:67Copy
  • SELECT fas.* FROM n36ic_jbusinessdirectory_date_formats fas WHERE fas.id ='2'44μs768B/components/com_jbusinessdirectory/helpers/utils.php:78Copy
  • SELECT fas.* FROM n36ic_jbusinessdirectory_currencies fas WHERE fas.currency_id ='26'43μs704B/components/com_jbusinessdirectory/helpers/utils.php:87Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'56μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SHOW TABLES3.97ms48.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM n36ic_acym_plugin109μs1.5KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM n36ic_acym_configuration65μs3.06KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM n36ic_acym_plugin59μs1.5KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM n36ic_usergroups AS `groups`107μs1.02KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM `n36ic_languages` WHERE `published` = 1 ORDER BY `ordering` ASC68μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM n36ic_jbusinessdirectory_mobile_app_config76μs640B/components/com_jbusinessdirectory/helpers/utils.php:9373Copy
  • SHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_default_attributes`680μs3.84KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT id, name, listing_config as config FROM n36ic_jbusinessdirectory_default_attributes57μs1.88KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43Copy
  • SHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_companies`924μs2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • insert into n36ic_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values ('1','1','2025-04-05','local','1')581μs0B/components/com_jbusinessdirectory/helpers/utils.php:7602Copy
  • SET SQL_BIG_SELECTS=150μs0B/components/com_jbusinessdirectory/helpers/utils.php:6857Copy
  • select * from (select count(distinct cp.id) as nr_listings, cp.activity_radius, GROUP_CONCAT(DISTINCT pf.feature) as features, GREATEST(if(FIND_IN_SET('featured_companies',GROUP_CONCAT(DISTINCT pf.feature)),1,0), featured) as featured, cp.id from n36ic_jbusinessdirectory_companies cp left join n36ic_jbusinessdirectory_company_category cc on cp.id=cc.companyId left join n36ic_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join n36ic_jbusinessdirectory_company_locations l on cp.id = l.company_id left join n36ic_jbusinessdirectory_company_activity_city cat on cat.company_id=cp.id left join n36ic_jbusinessdirectory_cities cty on cty.id=cat.city_id left join n36ic_jbusinessdirectory_company_activity_region car on car.company_id=cp.id left join n36ic_jbusinessdirectory_regions rg on rg.id=car.region_id left join n36ic_jbusinessdirectory_company_activity_country cac on cac.company_id=cp.id left join n36ic_jbusinessdirectory_countries cntr on cntr.id=cac.country_id left join n36ic_jbusinessdirectory_orders inv on inv.company_id=cp.id left join n36ic_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 n36ic_jbusinessdirectory_package_fields pf on p.id= pf.package_id left join n36ic_jbusinessdirectory_language_translations t on cp.id = t.object_id and t.language_tag = 'en-GB' and t.type = 1 where 1 and ((cp.name LIKE '%local%') OR (cp.slogan LIKE '%local%') OR (cg.name LIKE '%local%') OR (cp.meta_description LIKE '%local%') OR (cp.short_description LIKE '%local%') OR (cp.phone LIKE '%local%') OR (cp.address LIKE '%local%') OR (cp.postalCode LIKE '%local%') OR (cp.city LIKE '%local%') OR LOCATE('local', cp.keywords)>0) 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 = cp.package_id and p.price=0)) ) and cp.state=1 and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0) 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 134.22ms33.73KB/administrator/components/com_jbusinessdirectory/tables/company.php:1155Copy
  • SET SESSION group_concat_max_len = 1000050μs0B/components/com_jbusinessdirectory/helpers/utils.php:6838Copy
  • 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 n36ic_jbusinessdirectory_companies cp left join n36ic_jbusinessdirectory_company_category cc on cp.id=cc.companyId left join n36ic_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join n36ic_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1 left join n36ic_jbusinessdirectory_company_locations l on cp.id = l.company_id left join n36ic_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and (cr.approved=2 OR cr.approved=0) left join n36ic_jbusinessdirectory_countries cn on cp.countryId=cn.id left join n36ic_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId) left join n36ic_jbusinessdirectory_orders inv on inv.company_id=cp.id left join n36ic_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 n36ic_jbusinessdirectory_package_fields pf on p.id=pf.package_id left join n36ic_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1 left join n36ic_jbusinessdirectory_language_translations t on cp.id = t.object_id and t.language_tag = 'en-GB' and t.type = 1 where 1 and cp.state=1 and ((cp.name LIKE '%local%') OR (cp.slogan LIKE '%local%') OR (cg.name LIKE '%local%') OR (cp.meta_description LIKE '%local%') OR (cp.short_description LIKE '%local%') OR (cp.phone LIKE '%local%') OR (cp.address LIKE '%local%') OR (cp.postalCode LIKE '%local%') OR (cp.city LIKE '%local%') OR LOCATE('local', cp.keywords)>0) 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 = cp.package_id and p.price=0)) ) and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0) 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, viewCount desc LIMIT 2028.31ms17.95KB/administrator/components/com_jbusinessdirectory/tables/company.php:1121Copy
  • 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 n36ic_jbusinessdirectory_companies cp left join n36ic_jbusinessdirectory_company_category cc on cp.id=cc.companyId left join n36ic_jbusinessdirectory_categories cg on cg.id=cc.categoryId and cg.published=1 left join n36ic_jbusinessdirectory_categories bcm on bcm.id=cp.mainSubcategory and bcm.published=1 left join n36ic_jbusinessdirectory_company_locations l on cp.id = l.company_id left join n36ic_jbusinessdirectory_company_reviews cr on cr.itemId = cp.id and cr.review_type = 1 and (cr.approved=2 OR cr.approved=0) left join n36ic_jbusinessdirectory_countries cn on cp.countryId=cn.id left join n36ic_jbusinessdirectory_company_types ct on find_in_set(ct.id,cp.typeId) left join n36ic_jbusinessdirectory_orders inv on inv.company_id=cp.id left join n36ic_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 n36ic_jbusinessdirectory_package_fields pf on p.id=pf.package_id left join n36ic_jbusinessdirectory_bookmarks bk on bk.item_id = cp.id and bk.user_id = 0 and bk.item_type = 1 left join n36ic_jbusinessdirectory_language_translations t on cp.id = t.object_id and t.language_tag = 'en-GB' and t.type = 1 where 1 and cp.id in (8,49,20,59,32,31,46,7,41,65,44,64,1,19,60,63,61,68,62,54) group by cp.id ) as slec where 1 order by featured desc, packageOrder desc, viewCount desc17.93ms57.83KB/administrator/components/com_jbusinessdirectory/tables/company.php:1134Copy
  • select object_id, name, content_short, content, additional_content from n36ic_jbusinessdirectory_language_translations where type=1 and object_id in (8,49,20,59,32,31,46,7,41,65,44,64,1,19,60,63,61,68,62,54) and language_tag='en-GB'620μs33.05KB/components/com_jbusinessdirectory/helpers/translations.php:1022Copy
  • SELECT t.* from n36ic_jbusinessdirectory_company_types bt inner join n36ic_jbusinessdirectory_language_translations t on bt.id=t.object_id where type=8 and language_tag='en-GB'49μs1.2KB/components/com_jbusinessdirectory/helpers/translations.php:102Copy
  • SELECT t.* from n36ic_jbusinessdirectory_company_types bt inner join n36ic_jbusinessdirectory_language_translations t on bt.id=t.object_id where type=8 and language_tag='en-GB'91μs0B/components/com_jbusinessdirectory/helpers/translations.php:106Copy
  • SELECT t.* from n36ic_jbusinessdirectory_countries c inner join n36ic_jbusinessdirectory_language_translations t on c.id=t.object_id where t.type=7 and language_tag='en-GB'109μs912B/components/com_jbusinessdirectory/helpers/translations.php:486Copy
  • SELECT t.* from n36ic_jbusinessdirectory_countries c inner join n36ic_jbusinessdirectory_language_translations t on c.id=t.object_id where t.type=7 and language_tag='en-GB'42μs0B/components/com_jbusinessdirectory/helpers/translations.php:490Copy
  • SELECT t.* from n36ic_jbusinessdirectory_categories c inner join n36ic_jbusinessdirectory_language_translations t on c.id=t.object_id where t.type=3 and language_tag='en-GB'53μs1.33KB/components/com_jbusinessdirectory/helpers/translations.php:68Copy
  • select object_id, content from n36ic_jbusinessdirectory_language_translations where type=2 and object_id in (8,49,20,59,32,31,46,7,41,65,44,64,1,19,60,63,61,68,62,54) and language_tag='en-GB'508μs896B/components/com_jbusinessdirectory/helpers/translations.php:1342Copy
  • SHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_company_providers`514μs1.48KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses from n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 8 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday52μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 8 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday41μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copy
  • SHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_company_attributes`423μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • 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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=8 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering76μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 8 order by rg.name28μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 8 order by cty.name26μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • SHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_packages`513μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 8137μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=8 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.38ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 49 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday56μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 49 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday61μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=49 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering63μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 49 order by rg.name40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 49 order by cty.name50μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 4985μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=49 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.05ms21.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 20 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday53μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 20 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday50μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=20 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering61μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 20 order by rg.name38μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 20 order by cty.name36μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 20128μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=20 left join n36ic_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 desc1.1ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 59 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday57μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 59 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday53μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=59 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering64μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 59 order by rg.name40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 59 order by cty.name39μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 5984μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=59 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.05ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 32 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday55μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 32 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday52μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=32 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering63μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 32 order by rg.name39μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 32 order by cty.name40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 3283μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=32 left join n36ic_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 desc1.03ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 31 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday54μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 31 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday51μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=31 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering72μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 31 order by rg.name43μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 31 order by cty.name43μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 3186μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=31 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.04ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 46 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday54μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 46 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday62μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=46 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering74μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 46 order by rg.name40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 46 order by cty.name37μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 4682μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=46 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.03ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday83μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 7 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday48μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=7 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering64μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 7 order by rg.name39μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 7 order by cty.name37μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 784μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=7 left join n36ic_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 desc1.06ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 41 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday60μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 41 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday49μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=41 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering62μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 41 order by rg.name38μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 41 order by cty.name43μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 4183μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=41 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.03ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 65 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday57μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 65 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday50μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=65 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering59μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 65 order by rg.name52μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 65 order by cty.name40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 65108μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=65 left join n36ic_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 desc1.27ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 44 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday69μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 44 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday55μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=44 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering66μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 44 order by rg.name40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 44 order by cty.name40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 4484μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=44 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.07ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 64 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday78μs9.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 64 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday49μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=64 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering61μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 64 order by rg.name38μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 64 order by cty.name42μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 64107μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=64 left join n36ic_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 desc1.05ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 1 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday60μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 1 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday54μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=1 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering81μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 1 order by rg.name40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 1 order by cty.name37μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 182μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=1 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.04ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 19 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday61μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 19 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday53μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=19 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering65μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 19 order by rg.name43μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 19 order by cty.name43μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 1988μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=19 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.04ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 60 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday72μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 60 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday51μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=60 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering277μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 60 order by rg.name56μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 60 order by cty.name40μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 60161μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=60 left join n36ic_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 desc1.64ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 63 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday67μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 63 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday73μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=63 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering74μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 63 order by rg.name41μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 63 order by cty.name47μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 63102μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=63 left join n36ic_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 desc1.14ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 61 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday60μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 61 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday56μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=61 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering89μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 61 order by rg.name44μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 61 order by cty.name39μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 6192μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=61 left join n36ic_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 desc1.11ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 68 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday55μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 68 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday111μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=68 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering130μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 68 order by rg.name53μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 68 order by cty.name59μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 68105μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=68 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.55ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 62 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday72μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 62 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday81μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=62 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering100μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 62 order by rg.name42μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 62 order by cty.name48μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 62117μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=62 left join n36ic_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 desc1.07ms10.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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 54 and cph.type = 0 and cph.item_type = 1 group by cph.weekday order by cph.weekday60μs1.48KB/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 n36ic_jbusinessdirectory_company_provider_hours as cph where cph.provider_id = 54 and cph.type = 1 and cph.item_type = 1 group by cph.weekday order by cph.weekday53μs1.48KB/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 n36ic_jbusinessdirectory_attributes a left join n36ic_jbusinessdirectory_attribute_types AS at on at.id=a.type left join n36ic_jbusinessdirectory_attribute_options as ao on ao.attribute_id = a.id left join n36ic_jbusinessdirectory_company_attributes AS ca on ca.attribute_id = a.id and ca.company_id=54 where a.status = 1 and a.attribute_type=1 group by a.id order by a.ordering76μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copy
  • select rg.id, rg.name from n36ic_jbusinessdirectory_company_activity_region as car left join n36ic_jbusinessdirectory_regions as rg on rg.id = car.region_id where car.company_id = 54 order by rg.name44μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copy
  • select cty.id, cty.name from n36ic_jbusinessdirectory_company_activity_city as cac left join n36ic_jbusinessdirectory_cities as cty on cty.id = cac.city_id where cac.company_id = 54 order by cty.name39μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copy
  • select id, package_id from n36ic_jbusinessdirectory_companies where id= 54125μs592B/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 n36ic_jbusinessdirectory_packages p left join n36ic_jbusinessdirectory_orders inv on p.id=inv.package_id and inv.company_id=54 left join n36ic_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 = 1 and p.price=0))) ) group by p.id order by p.price desc, p.ordering desc1.1ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copy
  • SHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_attributes`487μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM n36ic_jbusinessdirectory_companies WHERE approved=2 ORDER BY letter273μs840B/administrator/components/com_jbusinessdirectory/tables/company.php:1523Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=21 and object_id=2 and language_tag='en-GB'55μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=21 and object_id=1 and language_tag='en-GB'45μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=39 and object_id=1 and language_tag='en-GB'55μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=23 and object_id=1 and language_tag='en-GB'50μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=40 and object_id=1 and language_tag='en-GB'41μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=24 and object_id=1 and language_tag='en-GB'44μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=41 and object_id=1 and language_tag='en-GB'45μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=31 and object_id=1 and language_tag='en-GB'58μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=36 and object_id=1 and language_tag='en-GB'51μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=42 and object_id=1 and language_tag='en-GB'42μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=24 and object_id=2 and language_tag='en-GB'44μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=21 and object_id=1 and language_tag='en-GB'49μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=39 and object_id=1 and language_tag='en-GB'48μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=23 and object_id=1 and language_tag='en-GB'63μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=40 and object_id=1 and language_tag='en-GB'44μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=24 and object_id=1 and language_tag='en-GB'61μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=41 and object_id=1 and language_tag='en-GB'45μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=31 and object_id=1 and language_tag='en-GB'44μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=36 and object_id=1 and language_tag='en-GB'52μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=42 and object_id=1 and language_tag='en-GB'41μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `n36ic_modules` AS `m` LEFT JOIN `n36ic_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `n36ic_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,:preparedArray2)) 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`1.84ms2.31KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM n36ic_jbusinessdirectory_categories WHERE parent_id=1 AND published=1 AND type=1 ORDER BY lft186μs3.02KB/modules/mod_jbusiness_listings_search/helper.php:21Copy
  • SELECT c.* FROM n36ic_jbusinessdirectory_categories c INNER JOIN n36ic_jbusinessdirectory_categories cc ON c.parent_id = cc.id WHERE c.parent_id!=1 AND c.published=1 AND c.type=1 ORDER BY c.lft LIMIT 100090μs2.73KB/modules/mod_jbusiness_listings_search/helper.php:31Copy
  • SELECT city, county FROM n36ic_jbusinessdirectory_companies WHERE state = 1 AND city != '' union select city, county from n36ic_jbusinessdirectory_company_locations where city != '' ORDER BY county ASC546μs704B/modules/mod_jbusiness_listings_search/helper.php:100Copy
  • select * from n36ic_jbusinessdirectory_countries where id = 3681μs896B/components/com_jbusinessdirectory/helpers/utils.php:4951Copy
  • select * from n36ic_jbusinessdirectory_countries where id = 22645μs896B/components/com_jbusinessdirectory/helpers/utils.php:4951Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'80μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'65μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'51μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'67μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'69μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'60μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'52μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SHOW FULL COLUMNS FROM `n36ic_community_config`501μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `n36ic_community_config` WHERE `name` = 'config'50μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT `id` FROM `n36ic_users` WHERE `id` = '0'100μs520B/components/com_community/libraries/core.php:191Copy
  • SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`pages` as _pages, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, a.`longitude` as longitude, a.`latitude` as latitude, a.`default_avatar` as _defaultAvatar, a.`usergroup` as _usergroup, s.`userid` as _isonline, u.* FROM `n36ic_community_users` as a LEFT JOIN `n36ic_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `n36ic_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1' WHERE a.`userid`='0'248μs4.95KB/components/com_community/libraries/user.php:181Copy
  • SHOW FULL COLUMNS FROM `n36ic_community_profiles`442μs1.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `id` FROM `n36ic_community_fields` WHERE `fieldcode`='FIELD_GENDER'39μs536B/components/com_community/models/profile.php:825Copy
  • SELECT `value` FROM `n36ic_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '0'34μs520B/components/com_community/models/profile.php:808Copy
  • show tables like '%_kunena_users'2.16ms520B/plugins/community/mykunenaposts/mykunenaposts.php:34Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'77μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'52μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'48μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `n36ic_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51,:preparedArray52,:preparedArray53,:preparedArray54,:preparedArray55,:preparedArray56,:preparedArray57,:preparedArray58,:preparedArray59,:preparedArray60,:preparedArray61,:preparedArray62,:preparedArray63,:preparedArray64,:preparedArray65,:preparedArray66,:preparedArray67,:preparedArray68,:preparedArray69)207μs19.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'55μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'58μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'68μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'57μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'56μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'132μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'58μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'48μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'91μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=21 and object_id=2 and language_tag='en-GB'58μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=21 and object_id=1 and language_tag='en-GB'47μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=39 and object_id=1 and language_tag='en-GB'47μs16.89KB/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=23 and object_id=1 and language_tag='en-GB'51μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=40 and object_id=1 and language_tag='en-GB'46μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=24 and object_id=1 and language_tag='en-GB'79μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=41 and object_id=1 and language_tag='en-GB'55μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=31 and object_id=1 and language_tag='en-GB'47μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=36 and object_id=1 and language_tag='en-GB'53μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=42 and object_id=1 and language_tag='en-GB'68μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=36 and object_id=2 and language_tag='en-GB'71μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=21 and object_id=1 and language_tag='en-GB'46μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=39 and object_id=1 and language_tag='en-GB'47μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=23 and object_id=1 and language_tag='en-GB'50μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=40 and object_id=1 and language_tag='en-GB'44μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=24 and object_id=1 and language_tag='en-GB'43μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=41 and object_id=1 and language_tag='en-GB'45μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=31 and object_id=1 and language_tag='en-GB'44μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=36 and object_id=1 and language_tag='en-GB'69μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • select * from n36ic_jbusinessdirectory_language_translations where type=42 and object_id=1 and language_tag='en-GB'47μs912B/components/com_jbusinessdirectory/helpers/translations.php:631Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'61μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'64μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'61μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'84μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'60μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'82μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'67μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'89μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'77μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'67μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM n36ic_acym_list WHERE type = 'standard'66μs1.67KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM n36ic_acym_field84μs1.69KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM n36ic_acym_form WHERE active = 1 AND type != 'shortcode'51μs912B/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • 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 `n36ic_scheduler_tasks` AS `a` WHERE `a`.`state` = 1254μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `n36ic_template_styles` WHERE `client_id` = 0 AND `id` = '10'123μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `value` FROM n36ic_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"60μs536B/plugins/system/acymtriggers/acymtriggers.php:202Copy
  • SHOW TABLES2.95ms48.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT namekey,value FROM `n36ic_invitex_config`64μs832B/components/com_invitex/helper.php:275Copy
  • SELECT namekey,value FROM `n36ic_invitex_config`44μs832B/components/com_invitex/helper.php:275Copy
  • SELECT id FROM n36ic_menu WHERE link LIKE '%index.php?option=com_invitex&view=invites%' AND published =1 LIMIT 137μs536B/components/com_invitex/helper.php:1394Copy
  • SELECT `session_id` FROM `n36ic_session` WHERE `session_id` = ?180μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `n36ic_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?346μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy