Results 1 - 20 of 60
Filters

In order to perform this action you have to login
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.
Joomla! Version | 4.4.4 |
PHP Version | 8.2.26 |
Identity | guest |
Response | 200 |
Template | j-network |
Database |
|
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 |
SELECT @@SESSION.sql_mode;
75μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `n36ic_session`
WHERE `session_id` = ?
222μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `n36ic_session`
WHERE `session_id` = :session_id LIMIT 1
199μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT 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:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `n36ic_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
115μs34.23KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `n36ic_viewlevels`
56μs656B/libraries/src/Access/Access.php:955CopySELECT `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` = :guest
69μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `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:294CopySELECT `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:166CopySELECT `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` = 1
79μs40.86KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
55μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySET @@SESSION.sql_mode =''
41μs0B/plugins/system/jomsocial.system/jomsocial.system.php:139CopySELECT manifest_cache
FROM `n36ic_extensions`
WHERE element = "com_affiliatetracker"
42μs536B/plugins/system/affiliate_tracker/affiliate_tracker.php:203CopySELECT `id`
FROM `n36ic_affiliate_tracker_accounts`
WHERE `ref_word` = 'local-business' AND `publish` = '1'
40μs520B/plugins/system/affiliate_tracker/affiliate_tracker.php:75CopySELECT `template`
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `home` = 1
39μs536B/plugins/system/helix3/helix3.php:247CopySELECT *
FROM n36ic_rsform_config
52μs1KB/administrator/components/com_rsform/helpers/config.php:50CopySELECT `session_id`
FROM `n36ic_session`
WHERE `session_id` = :session_id LIMIT 1
112μs2.56KBParams/libraries/src/Session/MetadataManager.php:187CopyUPDATE `n36ic_session`
SET `guest` = :guest
, `time` = :time
, `userid` = :user_id
, `username` = :username
, `client_id` = :client_id
WHERE `session_id` = :session_id
132μs992BParams/libraries/src/Session/MetadataManager.php:316CopySELECT setting,value FROM n36ic_jfbconnect_config
57μs17.77KB/administrator/components/com_jfbconnect/models/config.php:304CopySELECT value
FROM n36ic_jfbconnect_config
WHERE setting="profile_joomla"
92μs536B/libraries/sourcecoast/plugins/socialprofile.php:649CopySELECT value
FROM n36ic_jfbconnect_config
WHERE setting="profile_customdb"
66μs536B/libraries/sourcecoast/plugins/socialprofile.php:649CopySELECT fas.*
FROM n36ic_jbusinessdirectory_application_settings fas
127μs40.73KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM n36ic_jbusinessdirectory_date_formats fas
WHERE fas.id ='2'
44μs768B/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM n36ic_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='26'
43μs704B/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
56μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySHOW TABLES
3.97ms48.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT * FROM n36ic_acym_plugin
109μs1.5KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM n36ic_acym_configuration
65μs3.06KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM n36ic_acym_plugin
59μs1.5KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT `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:32CopySELECT *
FROM `n36ic_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
68μs1.59KB/libraries/src/Language/LanguageHelper.php:142CopySELECT *
FROM n36ic_jbusinessdirectory_mobile_app_config
76μs640B/components/com_jbusinessdirectory/helpers/utils.php:9373CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_default_attributes`
680μs3.84KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT id, name, listing_config as config FROM n36ic_jbusinessdirectory_default_attributes
57μs1.88KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_companies`
924μs2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyinsert 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:7602CopySET SQL_BIG_SELECTS=1
50μs0B/components/com_jbusinessdirectory/helpers/utils.php:6857Copyselect * 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 1
34.22ms33.73KB/administrator/components/com_jbusinessdirectory/tables/company.php:1155CopySET SESSION group_concat_max_len = 10000
50μs0B/components/com_jbusinessdirectory/helpers/utils.php:6838Copyselect 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 20
28.31ms17.95KB/administrator/components/com_jbusinessdirectory/tables/company.php:1121Copyselect 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 desc
17.93ms57.83KB/administrator/components/com_jbusinessdirectory/tables/company.php:1134Copyselect 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:1022CopySELECT 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:102CopySELECT 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:106CopySELECT 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:486CopySELECT 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:490CopySELECT 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:68Copyselect 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:1342CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_company_providers`
514μs1.48KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect 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.weekday
52μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
41μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_company_attributes`
423μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect 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.ordering
76μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
28μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
26μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_packages`
513μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 8
137μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.38ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
56μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
61μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
63μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
50μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 49
85μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.05ms21.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
53μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
50μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
61μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
38μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
36μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 20
128μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.1ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
57μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
53μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
64μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
39μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 59
84μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.05ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
55μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
52μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
63μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
39μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 32
83μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.03ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
54μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
51μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
72μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
43μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
43μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 31
86μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.04ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
54μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
62μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
74μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
37μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 46
82μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.03ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
83μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
48μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
64μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
39μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
37μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 7
84μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.06ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
60μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
49μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
62μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
38μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
43μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 41
83μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.03ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
57μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
50μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
59μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
52μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 65
108μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.27ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
69μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
55μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
66μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 44
84μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.07ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
78μs9.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
49μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
61μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
38μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
42μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 64
107μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.05ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
60μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
54μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
81μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
40μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
37μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 1
82μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.04ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
61μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
53μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
65μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
43μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
43μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 19
88μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.04ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
72μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
51μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
277μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
56μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
40μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 60
161μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.64ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
67μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
73μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
74μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
41μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
47μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 63
102μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.14ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
60μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
56μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
89μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
44μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
39μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 61
92μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.11ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
55μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
111μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
130μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
53μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
59μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 68
105μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.55ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
72μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
81μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
100μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
42μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
48μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 62
117μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.07ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261Copyselect 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.weekday
60μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.weekday
53μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62Copyselect 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.ordering
76μs2.73KB/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52Copyselect 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.name
44μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2054Copyselect 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.name
39μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 54
125μs592B/administrator/components/com_jbusinessdirectory/tables/package.php:231Copyselect * , 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 desc
1.1ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_attributes`
487μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM n36ic_jbusinessdirectory_companies WHERE approved=2 ORDER BY letter
273μs840B/administrator/components/com_jbusinessdirectory/tables/company.php:1523Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631CopySELECT `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:51CopySELECT * FROM n36ic_jbusinessdirectory_categories
WHERE parent_id=1 AND published=1 AND type=1
ORDER BY lft
186μs3.02KB/modules/mod_jbusiness_listings_search/helper.php:21CopySELECT 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 1000
90μs2.73KB/modules/mod_jbusiness_listings_search/helper.php:31CopySELECT 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 ASC
546μs704B/modules/mod_jbusiness_listings_search/helper.php:100Copyselect * from n36ic_jbusinessdirectory_countries where id = 36
81μs896B/components/com_jbusinessdirectory/helpers/utils.php:4951Copyselect * from n36ic_jbusinessdirectory_countries where id = 226
45μs896B/components/com_jbusinessdirectory/helpers/utils.php:4951CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
80μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
65μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
51μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
67μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
69μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
60μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
52μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySHOW FULL COLUMNS FROM `n36ic_community_config`
501μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `n36ic_community_config`
WHERE `name` = 'config'
50μs592B/libraries/src/Table/Table.php:755CopySELECT `id` FROM `n36ic_users` WHERE `id` = '0'
100μs520B/components/com_community/libraries/core.php:191CopySELECT 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:181CopySHOW FULL COLUMNS FROM `n36ic_community_profiles`
442μs1.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT `id` FROM `n36ic_community_fields` WHERE `fieldcode`='FIELD_GENDER'
39μs536B/components/com_community/models/profile.php:825CopySELECT `value` FROM `n36ic_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '0'
34μs520B/components/com_community/models/profile.php:808Copyshow tables like '%_kunena_users'
2.16ms520B/plugins/community/mykunenaposts/mykunenaposts.php:34CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
77μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
52μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
48μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT `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:357CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
55μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
58μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
68μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
57μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
56μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
132μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
58μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
48μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
91μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631Copyselect * 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:631CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
61μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
50μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
64μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
61μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
84μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
60μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
82μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
67μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
89μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
77μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
67μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT * FROM n36ic_acym_list WHERE type = 'standard'
66μs1.67KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM n36ic_acym_field
84μs1.69KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM n36ic_acym_form WHERE active = 1 AND type != 'shortcode'
51μs912B/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT 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` = 1
254μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
123μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT `value` FROM n36ic_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
60μs536B/plugins/system/acymtriggers/acymtriggers.php:202CopySHOW TABLES
2.95ms48.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT namekey,value FROM `n36ic_invitex_config`
64μs832B/components/com_invitex/helper.php:275CopySELECT namekey,value FROM `n36ic_invitex_config`
44μs832B/components/com_invitex/helper.php:275CopySELECT id FROM n36ic_menu
WHERE link LIKE '%index.php?option=com_invitex&view=invites%'
AND published =1
LIMIT 1
37μs536B/components/com_invitex/helper.php:1394CopySELECT `session_id`
FROM `n36ic_session`
WHERE `session_id` = ?
180μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `n36ic_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
346μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy