J-BusinessDirectory is a professional and reliable business directory. You can create now the professional business directory you've always dreamed of.

You can create and efficiently manage any type of directory.

Latest News

Church Detail 18 October 2017

Company Listing Page 12 October 2017

Welcome to the URC Directory 29 March 2017

Our Partners

Quick Link

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1619162107,
                "last": 1619162107,
                "now": 1619162107
            },
            "token": "SX6o3o2H5iMpY3v05PHW9xl29dz4Sihd"
        },
        "registry": {
            "com_jbusinessdirectory": {
                "search": {
                    "ordercol": null
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "categorySearch": "221",
        "searchkeyword": "",
        "pilots": "-1",
        "fairtrade": null,
        "searchkeywordLocation": "",
        "typeSearch": "",
        "citySearch": "",
        "regionSearch": "",
        "countrySearch": "",
        "zipcode": "",
        "customAtrributes": ""
    }
}

Profile Information

Time

Memory

Time: 9.16 ms / 9.16 ms Memory: 1.747 MB / 2.13 MB Application: afterLoad

Time: 45.54 ms / 54.70 ms Memory: 5.352 MB / 7.48 MB Application: afterInitialise

Time: 7.44 ms / 62.14 ms Memory: 0.777 MB / 8.25 MB Application: afterRoute

Time: 9.53 ms / 71.67 ms Memory: 0.275 MB / 8.53 MB Application: beforeRenderComponent com_jbusinessdirectory

Time: 60.95 ms / 132.62 ms Memory: 3.837 MB / 12.37 MB Application: afterRenderComponent com_jbusinessdirectory

Time: 0.23 ms / 132.84 ms Memory: 0.005 MB / 12.37 MB Application: afterDispatch

Time: 14.13 ms / 146.98 ms Memory: 0.980 MB / 13.35 MB Application: beforeRenderModule mod_search (Search)

Time: 0.70 ms / 147.68 ms Memory: 0.045 MB / 13.40 MB Application: afterRenderModule mod_search (Search)

Time: 0.02 ms / 147.70 ms Memory: 0.000 MB / 13.39 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 0.95 ms / 148.65 ms Memory: 0.046 MB / 13.44 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.05 ms / 148.70 ms Memory: 0.000 MB / 13.44 MB Application: beforeRenderModule mod_menu (Quick Link)

Time: 0.55 ms / 149.25 ms Memory: 0.014 MB / 13.45 MB Application: afterRenderModule mod_menu (Quick Link)

Time: 0.04 ms / 149.29 ms Memory: 0.000 MB / 13.45 MB Application: beforeRenderModule mod_menu (Our Partners)

Time: 0.55 ms / 149.84 ms Memory: 0.014 MB / 13.46 MB Application: afterRenderModule mod_menu (Our Partners)

Time: 0.04 ms / 149.87 ms Memory: 0.000 MB / 13.46 MB Application: beforeRenderModule mod_articles_latest (Latest News)

Time: 0.98 ms / 150.85 ms Memory: 0.151 MB / 13.61 MB Application: Before Access::preloadComponents (all components)

Time: 0.77 ms / 151.62 ms Memory: 0.062 MB / 13.67 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 151.64 ms Memory: 0.000 MB / 13.67 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.32 ms / 151.96 ms Memory: 0.026 MB / 13.70 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 2.53 ms / 154.49 ms Memory: 0.127 MB / 13.82 MB Application: afterRenderModule mod_articles_latest (Latest News)

Time: 0.04 ms / 154.53 ms Memory: 0.000 MB / 13.78 MB Application: beforeRenderModule mod_custom (About directory)

Time: 0.28 ms / 154.81 ms Memory: 0.006 MB / 13.79 MB Application: afterRenderModule mod_custom (About directory)

Time: 2.13 ms / 156.94 ms Memory: 0.298 MB / 14.09 MB Application: afterRender

Database queries total: 50.36 ms

Memory Usage

Database Queries

120 Queries Logged 50.36 ms

71 duplicate found!

2 duplicates: #10 #11

5 duplicates: #18 #43 #45 #47 #51

4 duplicates: #19 #46 #48 #52

60 duplicates: #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117

Query Time: 0.24 ms Query memory: 0.025 MB Memory before query: 3.878 MB Rows returned: 0

SELECT `data`

  FROM `llabe_session`

  WHERE `session_id` = 'fbc27e7107659b2a6c57f94c0654fafe'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.99 ms Query memory: 0.022 MB Memory before query: 3.980 MB Rows returned: 0

SELECT `session_id`

  FROM `llabe_session`

  WHERE `session_id` = 'fbc27e7107659b2a6c57f94c0654fafe' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.11 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 3.986 MB

INSERT INTO `llabe_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('fbc27e7107659b2a6c57f94c0654fafe', 1, 1619162107, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `llabe_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('fbc27e7107659b2a6c57f94c0654fafe', 1, 1619162107, 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.53 ms After last query: 2.07 ms Query memory: 0.031 MB Memory before query: 4.196 MB Rows returned: 41

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `llabe_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_extensions	NULL	ref	extension	extension	82	const	41	1.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 1.48 ms Query memory: 0.023 MB Memory before query: 4.392 MB Rows returned: 5

SELECT id, rules

  FROM `llabe_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.24 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 4.404 MB Rows returned: 2

SELECT b.id

  FROM llabe_usergroups AS a

  LEFT JOIN llabe_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 13

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.76 ms After last query: 0.47 ms Query memory: 0.034 MB Memory before query: 4.534 MB Rows returned: 99

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM llabe_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_extensions	NULL	ref	extension	extension	82	const	123	0.41	Using index condition; Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.94 ms After last query: 6.62 ms Query memory: 0.047 MB Memory before query: 5.886 MB Rows returned: 30

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component

  FROM llabe_menu AS m

  LEFT JOIN llabe_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	82	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	urcdir2_joomsite.m.component_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
16	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
13	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
12	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
11	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
10	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
9	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
8	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/plugins/system/expiresheaders/expiresheaders.php:28
7	plgSystemExpiresHeaders->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 11.87 ms Query memory: 0.026 MB Memory before query: 7.379 MB Rows returned: 33

SELECT *

  FROM llabe_rsform_config

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_rsform_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	33	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.54 ms After last query: 6.61 ms Query memory: 0.064 MB Memory before query: 8.180 MB Rows returned: 1

Duplicate queries: #11

SELECT fas.*, df.*, c.currency_name, c.currency_id 
  FROM llabe_jbusinessdirectory_applicationsettings fas
					
  inner join  llabe_jbusinessdirectory_date_formats df 
  on fas.date_format_id=df.id
					
  inner join  llabe_jbusinessdirectory_currencies c 
  on fas.currency_id=c.currency_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fas	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	df	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/components/com_jbusinessdirectory/assets/utils.php:69
10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/assets/utils.php:56
9	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/urltranslator.php:38
8	plgSystemUrlTranslator->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.33 ms After last query: 0.03 ms Query memory: 0.064 MB Memory before query: 8.185 MB Rows returned: 1

Duplicate queries: #10

SELECT fas.*, df.*, c.currency_name, c.currency_id 
  FROM llabe_jbusinessdirectory_applicationsettings fas
					
  inner join  llabe_jbusinessdirectory_date_formats df 
  on fas.date_format_id=df.id
					
  inner join  llabe_jbusinessdirectory_currencies c 
  on fas.currency_id=c.currency_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fas	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	df	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
11	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/assets/utils.php:74
10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/assets/utils.php:56
9	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/urltranslator.php:38
8	plgSystemUrlTranslator->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.24 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 8.209 MB Rows returned: 1

SELECT * 
  FROM llabe_jbusinessdirectory_categories c 
  where c.type=1 
  and c.alias = 'west-midlands-synod' 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_alias	idx_alias	302	const	1	10.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/urltranslator.php:156
9	plgSystemUrlTranslator->getCategoryParms()	JROOT/plugins/system/urltranslator/urltranslator.php:64
8	plgSystemUrlTranslator->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.23 ms After last query: 0.62 ms Query memory: 0.025 MB Memory before query: 8.291 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `llabe_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.07 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 8.281 MB

UPDATE `llabe_extensions`

  SET `params` = '{\"mediaversion\":\"ade631aa59c7cf5adc1e16be82004794\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	llabe_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.32 ms After last query: 1.56 ms Query memory: 0.025 MB Memory before query: 8.451 MB Rows returned: 1

SELECT *

  FROM llabe_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.27 ms After last query: 0.21 ms Query memory: 0.030 MB Memory before query: 8.462 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM llabe_template_styles as s

  LEFT JOIN llabe_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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	16.67	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	urcdir2_joomsite.s.template,const	1	4.37	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.66 ms After last query: 13.00 ms Query memory: 0.033 MB Memory before query: 10.094 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `llabe_jbusinessdirectory_categories`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `llabe_jbusinessdirectory_categories`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:29
17	JBusinessTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:71
15	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:213
14	JBusinessDirectorCategoryLib->getCategoryLeafs()	JROOT/components/com_jbusinessdirectory/models/search.php:241
13	JBusinessDirectoryModelSearch->getSearchParams()	JROOT/components/com_jbusinessdirectory/models/search.php:290
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.41 ms Query memory: 0.030 MB Memory before query: 10.147 MB Rows returned: 1

Duplicate queries: #43 #45 #47 #51

select * 
  from llabe_jbusinessdirectory_categories c
				 
  where c.id=221

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:51
16	JBusinessTableCategory->getCategoryById()	JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:75
15	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:213
14	JBusinessDirectorCategoryLib->getCategoryLeafs()	JROOT/components/com_jbusinessdirectory/models/search.php:241
13	JBusinessDirectoryModelSearch->getSearchParams()	JROOT/components/com_jbusinessdirectory/models/search.php:290
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.29 ms After last query: 0.05 ms Query memory: 0.035 MB Memory before query: 10.158 MB Rows returned: 13

Duplicate queries: #46 #48 #52

select * 
  from llabe_jbusinessdirectory_categories 
  where published=1 
  and type = 1 
  order by parent_id, name

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	llabe_jbusinessdirectory_categories	NULL	ref	idx_state	idx_state	1	const	12	10.00	Using index condition; Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:58
16	JBusinessTableCategory->getAllCategories()	JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:79
15	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:213
14	JBusinessDirectorCategoryLib->getCategoryLeafs()	JROOT/components/com_jbusinessdirectory/models/search.php:241
13	JBusinessDirectoryModelSearch->getSearchParams()	JROOT/components/com_jbusinessdirectory/models/search.php:290
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.77 ms After last query: 0.88 ms Query memory: 0.043 MB Memory before query: 10.263 MB Rows returned: 73

SHOW FULL COLUMNS 
  FROM `llabe_jbusinessdirectory_companies`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `llabe_jbusinessdirectory_companies`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:31
15	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:53
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:291
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 8.65 ms After last query: 0.18 ms Query memory: 0.057 MB Memory before query: 10.405 MB Rows returned: 20

select slec.*, mainCategory, mainCategoryId, categoryMaker, companyName,  companyId1, count(cra.id) as nrRatings, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
				
				 
  from (
					 select cp.*,  cp.name as companyName,cp.id as companyId1,  
				 
					 ct.name as typeName, 
					 #cnt.contact_name,
					 GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, 
					 bc.name as mainCategory, bc.alias as mainCategoryAlias ,bc.markerLocation as categoryMaker, bc.id as mainCategoryId
					
  from 
					(
					 select 
				   	  	cp2.id, cp2.name, cp2.alias, cp2.pilots,cp2.fairtrade, cp2.short_description, cp2.meta_description, cp2.street_number, cp2.address, cp2.city, cp2.county, cp2.website, cp2.phone, cp2.email, cp2.state, cp2.fax, 
						 cp2.averageRating, cp2.slogan,cp2.logoLocation, cp2.activity_radius, cp2. review_score, cp2.creationDate,
						 cp2.featured,cp2.publish_only_city,cp2.userId,
						 cp2.latitude, cp2.longitude, cp2.keywords,cp2.approved, cp2.mainSubcategory, cp2.countryId,cp2.typeId, cp2.postalCode,
					 	 GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(cg.name separator '#') as categoryNames, GROUP_CONCAT(cg.alias separator '#') as categoryAliases
					 	
					 
					  
  from llabe_jbusinessdirectory_companies cp2
					  
  left join llabe_jbusinessdirectory_company_category cc 
  on cp2.id=cc.companyId 
					  
  left join llabe_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					  
					  
  where 1  
  and cc.categoryId in (221,221)
					  
                      
  group by cp2.id
					 ) as cp
					
  left join llabe_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId 
					
  left join llabe_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					
  left join llabe_jbusinessdirectory_categories bc 
  on bc.id=cp.mainSubcategory 
  and bc.published=1
					 
					#
  left join llabe_jbusinessdirectory_company_contact cnt 
  on cp.id=cnt.companyId 
					 
  left join llabe_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id
					
  left join llabe_jbusinessdirectory_company_types ct 
  on cp.typeId=ct.id 
					
  left join llabe_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id
					
  left join llabe_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and p.status=1 
  and 0) or (p.price=0 
  and p.status=1 
  and 0)
					
  left join llabe_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id
					
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.company_id=cp.id 
  where 1   
  and cc.categoryId in (221,221)          
  and cp.state=1 
  and (cp.approved = 2 or cp.approved= -1) 
					
  group by cp.id 
  order by cp.name  ) as slec 
				
  left join llabe_jbusinessdirectory_company_ratings cra 
  on cra.companyId=companyId1
				
  group by companyId1 
				
				
  order by featured desc, packageOrder desc 
  LIMIT 0, 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	cra	NULL	system	idx_company	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	610	100.00	Using temporary; Using filesort
2	DERIVED	ct	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
2	DERIVED	<derived3>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	223	1.90	Using where; Using temporary; Using filesort
2	DERIVED	cc	NULL	ref	PRIMARY,idx_category	idx_category	4	cp.id	1	20.00	Using where; Using index
2	DERIVED	cg	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	urcdir2_joomsite.cc.categoryId	1	100.00	Using where
2	DERIVED	bc	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	cp.mainSubcategory	1	100.00	Using where
2	DERIVED	cn	NULL	eq_ref	PRIMARY	PRIMARY	4	cp.countryId	1	100.00	Using index
2	DERIVED	inv	NULL	ref	idx_company	idx_company	4	cp.id	1	100.00	NULL
2	DERIVED	p	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	pf	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	30	100.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	ca	NULL	index	company_UNIQUE	company_UNIQUE	761	NULL	6	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
3	DERIVED	cc	NULL	index	PRIMARY,idx_category	PRIMARY	8	NULL	1116	20.00	Using where; Using index; Using temporary; Using filesort
3	DERIVED	cg	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	urcdir2_joomsite.cc.categoryId	1	100.00	Using where
3	DERIVED	cp2	NULL	eq_ref	PRIMARY	PRIMARY	4	urcdir2_joomsite.cc.companyId	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:473
13	JTableCompany->getCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:293
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.28 ms After last query: 0.55 ms Query memory: 0.030 MB Memory before query: 10.600 MB Rows returned: 5

SHOW FULL COLUMNS 
  FROM `llabe_jbusinessdirectory_company_attributes`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `llabe_jbusinessdirectory_company_attributes`

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:23
15	JTableCompanyAttributes->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:53
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:300
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.40 ms After last query: 0.07 ms Query memory: 0.028 MB Memory before query: 10.619 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=416
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.20 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 10.627 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=417
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.16 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 10.634 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=418
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.15 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 10.642 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=419
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 10.649 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=420
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.05 ms Query memory: 0.028 MB Memory before query: 10.657 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=421
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 10.664 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=422
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 10.672 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=423
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.12 ms After last query: 0.03 ms Query memory: 0.028 MB Memory before query: 10.679 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=424
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.11 ms After last query: 0.03 ms Query memory: 0.028 MB Memory before query: 10.687 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=425
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.03 ms Query memory: 0.029 MB Memory before query: 10.701 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=426
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 10.710 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=427
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.03 ms Query memory: 0.028 MB Memory before query: 10.717 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=428
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:27
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:51
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.03 ms Query memory: 0.028 MB Memory before query: 10.725 MB Rows returned: 0

select a.*, 
				  GROUP_CONCAT(DISTINCT ao.name 
  ORDER BY ao.id asc SEPARATOR ',')  options,
				  GROUP_CONCAT(DISTINCT ao.id 
  ORDER BY ao.id asc SEPARATOR ',')  optionsIDS,
				  at.code as attributeTypeCode,
				  ca.value as attributeValue
				  
  from llabe_jbusinessdirectory_attributes a 
		          
  left join llabe_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
		          
  left join llabe_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
		          
  left join llabe_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=429
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  group by a.id 
		          
  order by a.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:51
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/search.php:301
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:27
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla

Search Filter

Synods

West Midlands Synod

About directory

Latest News

Our Partners

Quick Link

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

120 Queries Logged 50.36 ms

71 duplicate found!