Results 41 - 60 of 68
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.4MB) (50.11%) | 143.28ms |
1 x afterRender (811.25KB) (12.28%) | 35.12ms |
1 x afterInitialise (3.04MB) (12.05%) | 34.46ms |
1 x Before Access::preloadComponents (all components) (1.59MB) (8.42%) | 24.08ms |
1 x afterRoute (988.35KB) (3.8%) | 10.87ms |
1 x afterRenderComponent com_jbusinessdirectory (634.48KB) (3.19%) | 9.11ms |
1 x afterRenderRawModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (119.31KB) (2.77%) | 7.91ms |
1 x afterRenderRawModule mod_jbusiness_user (User module) (204.9KB) (1.69%) | 4.83ms |
1 x afterLoad (476.17KB) (0.73%) | 2.09ms |
1 x afterRenderRawModule mod_menu (POLICY) (66.63KB) (0.72%) | 2.07ms |
1 x afterRenderModule mod_custom (GET COMMUNITY CONNECTED) (36.82KB) (0.56%) | 1.59ms |
1 x afterRenderModule mod_menu (Offcanvas) (13.7KB) (0.55%) | 1.56ms |
1 x afterRenderRawModule mod_menu (Offcanvas) (14.44KB) (0.55%) | 1.56ms |
1 x afterRenderModule mod_menu (POLICY) (36.34KB) (0.51%) | 1.46ms |
1 x afterRenderModule mod_jbusiness_user (User module) (68.67KB) (0.46%) | 1.32ms |
1 x afterRenderRawModule mod_custom (GET COMMUNITY CONNECTED) (4.03KB) (0.41%) | 1.16ms |
1 x beforeRenderComponent com_jbusinessdirectory (50.99KB) (0.37%) | 1.07ms |
1 x After Access::preloadComponents (all components) (188.52KB) (0.32%) | 904μs |
1 x afterDispatch (2.98KB) (0.09%) | 263μs |
1 x beforeRenderRawModule mod_menu (Offcanvas) (7.31KB) (0.07%) | 198μs |
1 x afterRenderModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (9.38KB) (0.06%) | 172μs |
1 x beforeRenderRawModule mod_jbusiness_user (User module) (3.16KB) (0.03%) | 79μs |
1 x beforeRenderRawModule mod_menu (POLICY) (568B) (0.02%) | 65μs |
1 x After Access::getAssetRules (id:137 name:com_jfbconnect) (6.87KB) (0.02%) | 52μs |
1 x beforeRenderRawModule mod_custom (GET COMMUNITY CONNECTED) (1.52KB) (0.02%) | 49μs |
1 x Before Access::getAssetRules (id:137 name:com_jfbconnect) (2.43KB) (0.01%) | 18μs |
1 x beforeRenderModule mod_jbusiness_listings_search ( JBusinessDirectory Listing Search - Vertical ) (768B) (0%) | 11μs |
1 x beforeRenderModule mod_jbusiness_user (User module) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_menu (POLICY) (704B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (GET COMMUNITY CONNECTED) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_menu (Offcanvas) (704B) (0%) | 5μs |
SELECT @@SESSION.sql_mode;
115μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `n36ic_session`
WHERE `session_id` = ?
136μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `n36ic_session`
WHERE `session_id` = :session_id LIMIT 1
97μ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)
504μ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
104μs34.23KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `n36ic_viewlevels`
42μ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
42μ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`
97μ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.46ms20.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
68μs40.86KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
54μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySET @@SESSION.sql_mode =''
53μs0B/plugins/system/jomsocial.system/jomsocial.system.php:139CopySELECT manifest_cache
FROM `n36ic_extensions`
WHERE element = "com_affiliatetracker"
59μs536B/plugins/system/affiliate_tracker/affiliate_tracker.php:203CopySELECT `id`
FROM `n36ic_affiliate_tracker_accounts`
WHERE `ref_word` = 'local-business' AND `publish` = '1'
45μs520B/plugins/system/affiliate_tracker/affiliate_tracker.php:75CopySELECT `template`
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `home` = 1
42μs536B/plugins/system/helix3/helix3.php:247CopySELECT *
FROM n36ic_rsform_config
76μs1KB/administrator/components/com_rsform/helpers/config.php:50CopySELECT `session_id`
FROM `n36ic_session`
WHERE `session_id` = :session_id LIMIT 1
166μ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
159μs992BParams/libraries/src/Session/MetadataManager.php:316CopySELECT setting,value FROM n36ic_jfbconnect_config
76μs17.77KB/administrator/components/com_jfbconnect/models/config.php:304CopySELECT value
FROM n36ic_jfbconnect_config
WHERE setting="profile_joomla"
46μs536B/libraries/sourcecoast/plugins/socialprofile.php:649CopySELECT value
FROM n36ic_jfbconnect_config
WHERE setting="profile_customdb"
62μs536B/libraries/sourcecoast/plugins/socialprofile.php:649CopySELECT fas.*
FROM n36ic_jbusinessdirectory_application_settings fas
107μs40.73KB/components/com_jbusinessdirectory/helpers/utils.php:67CopySELECT fas.*
FROM n36ic_jbusinessdirectory_date_formats fas
WHERE fas.id ='2'
50μs768B/components/com_jbusinessdirectory/helpers/utils.php:78CopySELECT fas.*
FROM n36ic_jbusinessdirectory_currencies fas
WHERE fas.currency_id ='26'
53μs704B/components/com_jbusinessdirectory/helpers/utils.php:87CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
63μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySHOW TABLES
3.27ms48.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT * FROM n36ic_acym_plugin
69μs1.5KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM n36ic_acym_configuration
54μs3.06KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM n36ic_acym_plugin
52μ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`
53μs1.02KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT *
FROM `n36ic_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
60μs1.59KB/libraries/src/Language/LanguageHelper.php:142CopySELECT *
FROM n36ic_jbusinessdirectory_mobile_app_config
74μs640B/components/com_jbusinessdirectory/helpers/utils.php:9373CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_default_attributes`
532μs3.84KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT id, name, listing_config as config FROM n36ic_jbusinessdirectory_default_attributes
59μs1.88KB/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_companies`
972μs2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySET SQL_BIG_SELECTS=1
41μ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_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
where 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 = 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
14.04ms33.98KB/administrator/components/com_jbusinessdirectory/tables/company.php:1155CopySET SESSION group_concat_max_len = 10000
56μ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
where 1 and cp.state=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 = 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 40, 20
16.14ms17.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
where 1 and cp.id in (25,18,5,24,10,38,48,57,3,28,35,58,34,73,55,43,53,27,74,76)
group by cp.id
) as slec
where 1
order by featured desc, packageOrder desc, viewCount desc
13.89ms57.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 (25,18,5,24,10,38,48,57,3,28,35,58,34,73,55,43,53,27,74,76) and language_tag='en-GB'
789μ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'
56μ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'
34μs0B/components/com_jbusinessdirectory/helpers/translations.php:106CopySELECT 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'
62μs1.39KB/components/com_jbusinessdirectory/helpers/translations.php:68CopySELECT 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'
51μ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'
40μs0B/components/com_jbusinessdirectory/helpers/translations.php:490Copyselect object_id, content from n36ic_jbusinessdirectory_language_translations where type=2 and object_id in (25,18,5,24,10,38,48,57,3,28,35,58,34,73,55,43,53,27,74,76) and language_tag='en-GB'
582μs896B/components/com_jbusinessdirectory/helpers/translations.php:1342CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_company_providers`
506μ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 = 25 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
326μ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 = 25 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
197μs1.48KB/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_company_attributes`
462μ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=25
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
291μ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 = 25
order by rg.name
191μ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 = 25
order by cty.name
157μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_packages`
612μs2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 25
122μ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=25
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.21ms10.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 = 18 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
312μ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 = 18 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
188μ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=18
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
205μ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 = 18
order by rg.name
151μ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 = 18
order by cty.name
142μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 18
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=18
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.22ms10.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 = 5 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
195μs12.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 = 5 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
285μ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=5
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
202μ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 = 5
order by rg.name
180μ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 = 5
order by cty.name
146μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 5
184μ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=5
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.13ms10.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 = 24 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
175μ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 = 24 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
178μ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=24
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
262μ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 = 24
order by rg.name
178μ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 = 24
order by cty.name
154μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 24
225μ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=24
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.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 = 10 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
188μ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 = 10 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
164μ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=10
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
293μ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 = 10
order by rg.name
190μ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 = 10
order by cty.name
157μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 10
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=10
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.28ms10.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 = 38 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
182μ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 = 38 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
180μ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=38
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
166μ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 = 38
order by rg.name
165μ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 = 38
order by cty.name
138μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 38
98μ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=38
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.12ms10.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 = 48 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
231μ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 = 48 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
171μ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=48
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
158μ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 = 48
order by rg.name
167μ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 = 48
order by cty.name
149μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 48
93μ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=48
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.22ms10.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 = 57 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
178μ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 = 57 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
220μ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=57
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
257μ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 = 57
order by rg.name
141μ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 = 57
order by cty.name
159μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 57
95μ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=57
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.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 = 3 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
182μ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 = 3 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
192μ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=3
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
145μ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 = 3
order by rg.name
162μ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 = 3
order by cty.name
131μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 3
99μ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=3
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.09ms10.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 = 28 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
178μ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 = 28 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
161μ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=28
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
310μ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 = 28
order by rg.name
152μ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 = 28
order by cty.name
135μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 28
97μ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=28
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 = 35 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
181μ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 = 35 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
161μ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=35
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
155μ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 = 35
order by rg.name
140μ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 = 35
order by cty.name
133μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 35
106μ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=35
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.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 = 58 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
170μ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 = 58 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
171μs9.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=58
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
212μ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 = 58
order by rg.name
135μ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 = 58
order by cty.name
129μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 58
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=58
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: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 = 34 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
172μ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 = 34 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
159μ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=34
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
160μ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 = 34
order by rg.name
213μ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 = 34
order by cty.name
147μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 34
91μ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=34
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 = 73 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
181μ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 = 73 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
308μ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=73
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
243μ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 = 73
order by rg.name
146μ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 = 73
order by cty.name
127μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 73
90μ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=73
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.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 = 55 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
190μ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 = 55 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
195μ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=55
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
151μ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 = 55
order by rg.name
239μ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 = 55
order by cty.name
148μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 55
110μ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=55
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.09ms10.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 = 43 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
200μ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 = 43 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
188μ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=43
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
258μ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 = 43
order by rg.name
169μ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 = 43
order by cty.name
144μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 43
96μ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=43
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.08ms10.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 = 53 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
297μ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 = 53 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
195μ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=53
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
193μ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 = 53
order by rg.name
245μ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 = 53
order by cty.name
202μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 53
126μ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=53
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.51ms10.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 = 27 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
238μ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 = 27 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
157μ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=27
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
215μ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 = 27
order by rg.name
176μ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 = 27
order by cty.name
152μs592B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 27
101μ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=27
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.22ms10.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 = 74 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
240μs1.61KB/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 = 74 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
253μ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=74
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
151μ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 = 74
order by rg.name
179μ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 = 74
order by cty.name
235μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 74
115μ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=74
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: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 = 76 and cph.type = 0 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
214μs1.61KB/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 = 76 and cph.type = 1 and cph.item_type = 1
group by cph.weekday
order by cph.weekday
187μ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=76
where a.status = 1 and a.attribute_type=1
group by a.id
order by a.ordering
279μ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 = 76
order by rg.name
194μ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 = 76
order by cty.name
160μs576B/administrator/components/com_jbusinessdirectory/tables/company.php:2067Copyselect id, package_id from n36ic_jbusinessdirectory_companies where id= 76
112μ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=76
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.16ms10.41KB/administrator/components/com_jbusinessdirectory/tables/package.php:261CopySHOW FULL COLUMNS FROM `n36ic_jbusinessdirectory_attributes`
443μ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
305μ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'
51μ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'
85μ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'
45μ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'
45μ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'
49μ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'
46μ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'
46μ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'
45μ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'
47μ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'
45μ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'
44μ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'
46μ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'
55μ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'
45μ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`
2.78ms2.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
94μ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
68μs2.77KB/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
1.44ms704B/modules/mod_jbusiness_listings_search/helper.php:100Copyselect * from n36ic_jbusinessdirectory_countries where id = 36
52μ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'
67μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
53μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
53μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
276μ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'
94μ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'
54μ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:54CopySHOW FULL COLUMNS FROM `n36ic_community_config`
569μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `n36ic_community_config`
WHERE `name` = 'config'
52μs592B/libraries/src/Table/Table.php:755CopySELECT `id` FROM `n36ic_users` WHERE `id` = '0'
55μ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'
442μs4.95KB/components/com_community/libraries/user.php:181CopySHOW FULL COLUMNS FROM `n36ic_community_profiles`
515μs1.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT `id` FROM `n36ic_community_fields` WHERE `fieldcode`='FIELD_GENDER'
49μs536B/components/com_community/models/profile.php:825CopySELECT `value` FROM `n36ic_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '0'
89μs520B/components/com_community/models/profile.php:808Copyshow tables like '%_kunena_users'
2.33ms520B/plugins/community/mykunenaposts/mykunenaposts.php:34CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
121μ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'
117μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
46μ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 `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)
412μs19.81KBParams/libraries/src/Access/Access.php:357CopySELECT *
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'
53μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
45μ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'
79μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
41μ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'
73μ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'
48μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
47μ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_jbusinessdirectory_language_translations where type=21 and object_id=2 and language_tag='en-GB'
53μ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'
51μ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'
32μ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μs16.89KB/components/com_jbusinessdirectory/helpers/translations.php:631Copyselect * from n36ic_jbusinessdirectory_language_translations where type=40 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=24 and object_id=1 and language_tag='en-GB'
32μ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'
33μ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'
33μ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'
33μ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'
53μ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'
41μ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'
58μ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'
31μ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'
75μ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'
33μ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'
31μ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'
32μ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'
42μ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'
43μs912B/components/com_jbusinessdirectory/helpers/translations.php:631CopySELECT *
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'
59μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
43μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
63μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
42μ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'
59μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
47μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
42μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
46μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
70μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
70μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
45μ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
54μs1.69KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM n36ic_acym_form WHERE active = 1 AND type != 'shortcode'
36μ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
272μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT *
FROM `n36ic_template_styles`
WHERE `client_id` = 0 AND `id` = '10'
49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT `value` FROM n36ic_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
38μs536B/plugins/system/acymtriggers/acymtriggers.php:202CopySHOW TABLES
3.29ms48.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT namekey,value FROM `n36ic_invitex_config`
50μs832B/components/com_invitex/helper.php:275CopySELECT namekey,value FROM `n36ic_invitex_config`
36μ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
39μs536B/components/com_invitex/helper.php:1394CopySELECT `session_id`
FROM `n36ic_session`
WHERE `session_id` = ?
278μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `n36ic_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
216μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy