{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1791986691,
                "last": 1791986691,
                "now": 1791986691
            },
            "token": "1jgQKsG1no6HxfjqQL4joZW3cX81RT0d"
        },
        "registry": {
            "com_jbusinessdirectory": {
                "catalog": {
                    "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
        },
        "lSearchType": 2,
        "listing-search": true,
        "menuItemId": "525"
    }
}

Time

Memory

67 Queries Logged 14.49 ms

1. Query Time: 0.19 ms Query memory: 0.023 MB Memory before query: 4.449 MB Rows returned: 0

   SELECT `data`
   
     FROM `qgvsi_session`
   
     WHERE `session_id` = X'3064643034343861393861313863336362303732643930343835383030373535'

   Explain

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

   Profile

   Error
   The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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.]

   ---

2. Query Time: 0.08 ms After last query: 0.28 ms Query memory: 0.020 MB Memory before query: 4.675 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `qgvsi_session`
   
     WHERE `session_id` = X'3064643034343861393861313863336362303732643930343835383030373535' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	qgvsi_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:1740
   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.]

   ---

3. Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.004 MB Memory before query: 4.680 MB

   INSERT INTO `qgvsi_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3064643034343861393861313863336362303732643930343835383030373535', 1, 1791986691, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `qgvsi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3064643034343861393861313863336362303732643930343835383030373535', 1, 1791986691, 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.]

   ---

4. Query Time: 0.29 ms After last query: 0.55 ms Query memory: 0.024 MB Memory before query: 4.927 MB Rows returned: 39

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `qgvsi_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	qgvsi_extensions	NULL	ref	extension	extension	82	const	39	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:1701
   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.]

   ---

5. Query Time: 0.15 ms After last query: 0.45 ms Query memory: 0.021 MB Memory before query: 5.170 MB Rows returned: 5

   SELECT id, rules
   
     FROM `qgvsi_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	qgvsi_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:1506
   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.]

   ---

6. Query Time: 0.17 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 5.182 MB Rows returned: 2

   SELECT b.id
   
     FROM qgvsi_usergroups AS a
   
     LEFT JOIN qgvsi_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	3	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:1550
   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.]

   ---

7. Query Time: 0.51 ms After last query: 0.13 ms Query memory: 0.030 MB Memory before query: 5.204 MB Rows returned: 85

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM qgvsi_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	qgvsi_extensions	NULL	ref	extension	extension	82	const	108	0.43	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:1701
   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.]

   ---

8. Query Time: 0.56 ms After last query: 4.42 ms Query memory: 0.048 MB Memory before query: 7.124 MB Rows returned: 19

   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 qgvsi_menu AS m
   
     LEFT JOIN qgvsi_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	118	6.19	Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.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
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
   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.]

   ---

9. Query Time: 0.41 ms After last query: 2.11 ms Query memory: 0.086 MB Memory before query: 8.017 MB Rows returned: 1
   Duplicate queries: #10

   SELECT fas.*, df.*, c.currency_name, c.currency_id 
     FROM qgvsi_jbusinessdirectory_applicationsettings fas
   					
     inner join  qgvsi_jbusinessdirectory_date_formats df 
     on fas.date_format_id=df.id
   					
     inner join  qgvsi_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:68
   10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/assets/utils.php:55
   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.]

   ---

10. Query Time: 0.23 ms After last query: 0.02 ms Query memory: 0.079 MB Memory before query: 8.030 MB Rows returned: 1
    Duplicate queries: #9

    SELECT fas.*, df.*, c.currency_name, c.currency_id 
      FROM qgvsi_jbusinessdirectory_applicationsettings fas
    					
      inner join  qgvsi_jbusinessdirectory_date_formats df 
      on fas.date_format_id=df.id
    					
      inner join  qgvsi_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:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/assets/utils.php:73
    10	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/assets/utils.php:55
    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.]

    ---

11. Query Time: 0.18 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 8.050 MB Rows returned: 0

    SELECT * 
      FROM qgvsi_jbusinessdirectory_categories c 
      where c.type=1 
      and c.alias = 'catalog' 
      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:1662
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/urltranslator.php:166
    9	plgSystemUrlTranslator->getCategoryParms()	JROOT/plugins/system/urltranslator/urltranslator.php:84
    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.]

    ---

12. Query Time: 0.18 ms After last query: 0.02 ms Query memory: 0.038 MB Memory before query: 8.055 MB Rows returned: 0

    SELECT * 
      FROM `qgvsi_jbusinessdirectory_companies` c 
      where c.alias = 'catalog' 
      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_alis	idx_alis	302	const	1	100.00	NULL

    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:1662
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/urltranslator.php:124
    9	plgSystemUrlTranslator->getBusinessListingParms()	JROOT/plugins/system/urltranslator/urltranslator.php:86
    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.]

    ---

13. Query Time: 0.17 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 8.083 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `qgvsi_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	qgvsi_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:1662
    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:1130
    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.]

    ---

14. Query Time: 0.27 ms After last query: 0.06 ms Query memory: 0.005 MB Memory before query: 8.073 MB

    UPDATE `qgvsi_extensions`
    
      SET `params` = '{\"mediaversion\":\"cef2f4860892b6b0a5115e56e85b9fb2\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `qgvsi_extensions` SET `params` = '{\"mediaversion\":\"cef2f4860892b6b0a5115e56e85b9fb2\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    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:1130
    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.]

    ---

15. Query Time: 0.19 ms After last query: 0.31 ms Query memory: 0.020 MB Memory before query: 8.098 MB Rows returned: 1

    SELECT *
    
      FROM qgvsi_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	qgvsi_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:1701
    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.]

    ---

16. Query Time: 0.25 ms After last query: 0.11 ms Query memory: 0.019 MB Memory before query: 8.108 MB Rows returned: 4

    SELECT id, home, template, s.params
    
      FROM qgvsi_template_styles as s
    
      LEFT JOIN qgvsi_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	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	magarea_db.e.element	1	66.67	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:1701
    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.]

    ---

17. Query Time: 1.42 ms After last query: 6.12 ms Query memory: 0.039 MB Memory before query: 10.495 MB Rows returned: 66

    SHOW FULL COLUMNS 
      FROM `qgvsi_jbusinessdirectory_companies`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `qgvsi_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:1701
    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:27
    15	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/catalog.php:66
    13	JBusinessDirectoryModelCatalog->getTable()	JROOT/components/com_jbusinessdirectory/models/catalog.php:90
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

18. Query Time: 1.88 ms After last query: 0.24 ms Query memory: 0.055 MB Memory before query: 10.587 MB Rows returned: 20

    select slec.*, mainCategory, mainCategoryId, companyName, companyId1, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
    				 
      from (
    				 select cp.id, cp.name, cp.alias, cp.short_description, cp.street_number, cp.address, cp.countryId, cp.city, cp.county, cp.province, cp.area, cp.typeId, cp.website, cp.phone, cp.email, cp.state, cp.fax,
    				 cp.averageRating, cp.slogan, cp.logoLocation, cp. review_score, cp.ad_image,
    				 cp.featured,cp.publish_only_city, cp.publish_start_date, cp.publish_end_date,
    				 cp.name as companyName,cp.id as companyId1, cp.latitude, cp.longitude, cp.postalCode,
    				 cn.country_name as countryName,ct.name as typeName, 
    				 count(distinct cr.id) as nr_reviews,
    				 GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
      ORDER BY cg.name separator '#|') as categories,
    				 GROUP_CONCAT(DISTINCT pf.feature) as features,
    				 bc.name as mainCategory, bc.alias as mainCategoryAlias, bc.markerLocation as categoryMaker, bc.id as mainCategoryId
    				 
      from qgvsi_jbusinessdirectory_companies cp 
    				
      left join qgvsi_jbusinessdirectory_company_category cc 
      on cp.id=cc.companyId 
    				
      left join qgvsi_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
    				
      left join qgvsi_jbusinessdirectory_categories bc 
      on bc.id=cp.mainSubcategory 
      and bc.published=1
    				
      left join qgvsi_jbusinessdirectory_company_reviews cr 
      on cr.itemId = cp.id  
      and cr.review_type = 1 
      and cr.approved=2 
    				
      left join qgvsi_jbusinessdirectory_countries cn 
      on cp.countryId=cn.id 
    				
      left join qgvsi_jbusinessdirectory_company_types ct 
      on cp.typeId=ct.id 
    				
      left join qgvsi_jbusinessdirectory_orders inv 
      on inv.company_id=cp.id 
    				
      left join qgvsi_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 qgvsi_jbusinessdirectory_package_fields pf 
      on p.id=pf.package_id
    				
      where (cp.name like '%' or cp.name like '%' )  
      and cp.state=1  
      and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0)   
      and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
      and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null) 
    				
      group by cp.id 
      order by cp.name  ) as slec 
    				
      group by companyId1 
    				
      order by companyName 
      LIMIT 0, 20

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	18	100.00	Using temporary; Using filesort
    2	DERIVED	cr	NULL	system	idx_approved,idx_review_type	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    2	DERIVED	p	NULL	const	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Impossible ON condition
    2	DERIVED	cp	NULL	ref	PRIMARY,idx_state,idx_approved,idx_publish_start_date,idx_publish_end_date	idx_state	2	const	35	14.78	Using where; Using temporary; Using filesort
    2	DERIVED	cc	NULL	ref	PRIMARY,idx_category	PRIMARY	4	magarea_db.cp.id	1	100.00	Using index
    2	DERIVED	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cc.categoryId	1	100.00	NULL
    2	DERIVED	bc	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	magarea_db.cp.mainSubcategory	1	100.00	Using where
    2	DERIVED	cn	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cp.countryId	1	100.00	NULL
    2	DERIVED	ct	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cp.typeId	1	100.00	Using index condition
    2	DERIVED	inv	NULL	ref	idx_company	idx_company	4	magarea_db.cp.id	1	100.00	NULL
    2	DERIVED	pf	NULL	ref	idx_package_id	idx_package_id	5	const	3	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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:215
    13	JTableCompany->getCompaniesByLetter()	JROOT/components/com_jbusinessdirectory/models/catalog.php:93
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

19. Query Time: 0.70 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 10.669 MB Rows returned: 3

    SHOW FULL COLUMNS 
      FROM `qgvsi_jbusinessdirectory_default_attributes`

    Explain

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

    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:1701
    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/defaultattributes.php:21
    15	TableDefaultAttributes->__construct()	JROOT/libraries/src/Table/Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/assets/utils.php:2901
    13	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/models/catalog.php:94
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

20. Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 10.681 MB Rows returned: 40

    SELECT * 
      FROM qgvsi_jbusinessdirectory_default_attributes

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	qgvsi_jbusinessdirectory_default_attributes	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	40	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:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:32
    14	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/assets/utils.php:2902
    13	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/models/catalog.php:94
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

21. Query Time: 0.77 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 10.696 MB Rows returned: 5

    SHOW FULL COLUMNS 
      FROM `qgvsi_jbusinessdirectory_company_attributes`

    Explain

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

    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:1701
    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:21
    15	JTableCompanyAttributes->__construct()	JROOT/libraries/src/Table/Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/catalog.php:66
    13	JBusinessDirectoryModelCatalog->getTable()	JROOT/components/com_jbusinessdirectory/models/catalog.php:97
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

22. Query Time: 0.09 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 10.711 MB
    Duplicate queries: #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

23. Query Time: 0.27 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.720 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=102
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

24. Query Time: 0.06 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 10.727 MB
    Duplicate queries: #22  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

25. Query Time: 0.15 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 10.735 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=36
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

26. Query Time: 0.03 ms After last query: 0.04 ms Query memory: 0.007 MB Memory before query: 10.741 MB
    Duplicate queries: #22  #24  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

27. Query Time: 0.10 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.750 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=64
    		          
    		          
      where a.status = 1 
      and a.attribute_type=1
    				  
      group by a.id 
    		          
      order by a.ordering

    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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

28. Query Time: 0.03 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 10.756 MB
    Duplicate queries: #22  #24  #26  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

29. Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 10.765 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=127
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

30. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.771 MB
    Duplicate queries: #22  #24  #26  #28  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

31. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.780 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=106
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

32. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.786 MB
    Duplicate queries: #22  #24  #26  #28  #30  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

33. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.024 MB Memory before query: 10.801 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=39
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

34. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.808 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

35. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.817 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=107
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

36. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.823 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

37. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.832 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=41
    		          
    		          
      where a.status = 1 
      and a.attribute_type=1
    				  
      group by a.id 
    		          
      order by a.ordering

    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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

38. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.838 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

39. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.847 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=40
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

40. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.853 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #42  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

41. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.861 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=100
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

42. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.868 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #44  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

43. Query Time: 0.09 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.876 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=42
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

44. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.883 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #46  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

45. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.891 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=105
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

46. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.897 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #48  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

47. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.906 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=44
    		          
    		          
      where a.status = 1 
      and a.attribute_type=1
    				  
      group by a.id 
    		          
      order by a.ordering

    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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

48. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.912 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #50  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

49. Query Time: 0.12 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.921 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=130
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

50. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.927 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #52  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

51. Query Time: 0.09 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.935 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=79
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

52. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.942 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #54  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

53. Query Time: 0.09 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.950 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=47
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

54. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.957 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #56  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

55. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.965 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=103
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

56. Query Time: 0.03 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 10.971 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #58  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

57. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.980 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=37
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

58. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 10.986 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #60

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

59. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 10.995 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=69
    		          
    		          
      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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

60. Query Time: 0.03 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 11.001 MB
    Duplicate queries: #22  #24  #26  #28  #30  #32  #34  #36  #38  #40  #42  #44  #46  #48  #50  #52  #54  #56  #58

    
      SET SESSION group_concat_max_len =1000000

    Explain

    EXPLAIN not possible on query: SET SESSION group_concat_max_len =1000000

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

61. Query Time: 0.08 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 11.009 MB Rows returned: 0

    select a.*, 
    				  GROUP_CONCAT(DISTINCT ao.name 
      ORDER BY ao.ordering asc SEPARATOR ',')  options,
    				  GROUP_CONCAT(DISTINCT ao.id 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIDS,
    				  GROUP_CONCAT(ao.icon 
      ORDER BY ao.ordering asc SEPARATOR ',')  optionsIcons,
    				  at.code as attributeTypeCode,
    				  ca.value as attributeValue
    				  
      from qgvsi_jbusinessdirectory_attributes a 
    		          
      left join qgvsi_jbusinessdirectory_attribute_types AS at 
      on at.id=a.type
    		          
      left join qgvsi_jbusinessdirectory_attribute_options as ao 
      on ao.attribute_id = a.id
    		          
      left join qgvsi_jbusinessdirectory_company_attributes AS ca 
      on ca.attribute_id = a.id 
      and ca.company_id=49
    		          
    		          
      where a.status = 1 
      and a.attribute_type=1
    				  
      group by a.id 
    		          
      order by a.ordering

    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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55
    13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/catalog.php:98
    12	JBusinessDirectoryModelCatalog->getCompaniesByLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

62. Query Time: 0.16 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 11.010 MB Rows returned: 19

    SELECT DISTINCT UPPER(
      LEFT(name, 1)) as letter 
      FROM qgvsi_jbusinessdirectory_companies 
      ORDER BY letter

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	qgvsi_jbusinessdirectory_companies	NULL	index	idx_name	idx_name	302	NULL	70	100.00	Using index; Using temporary; Using filesort

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1033
    13	JTableCompany->getUsedLetters()	JROOT/components/com_jbusinessdirectory/models/catalog.php:80
    12	JBusinessDirectoryModelCatalog->getUsedLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:48
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

63. Query Time: 0.38 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 11.013 MB Rows returned: 26

    SELECT a.id AS value, a.name AS text, a.level, a.published
    
      FROM qgvsi_jbusinessdirectory_categories AS a
    
      LEFT JOIN `qgvsi_jbusinessdirectory_categories` AS b 
      ON a.lft > b.lft 
      AND a.rgt < b.rgt
    
      WHERE a.published = 1 
      AND (a.type IN (0,1)) 
      AND a.id >1
    
      GROUP BY a.id, a.name, a.level, a.lft, a.rgt, a.parent_id, a.published
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	PRIMARY,idx_state	idx_state	1	const	26	19.26	Using where; Using temporary; Using filesort
    1	SIMPLE	b	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	27	100.00	Using where; Using join buffer (hash join)

    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:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/assets/utils.php:1733
    11	JBusinessUtil::getCategoriesOptions()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:50
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

64. Query Time: 0.12 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 11.033 MB Rows returned: 0
    Duplicate queries: #65

    SELECT t.*
    					
      from  qgvsi_jbusinessdirectory_categories c
    					
      inner join  qgvsi_jbusinessdirectory_language_translations t 
      on c.id=t.object_id 
      where t.type=3 
      and language_tag='en-GB'

    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

    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/database.php:33
    14	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/helpers/translations.php:47
    13	JBusinessDirectoryTranslations::getCategoriesTranslationsObjects()	JROOT/administrator/components/com_jbusinessdirectory/helpers/translations.php:29
    12	JBusinessDirectoryTranslations::getCategoriesTranslations()	JROOT/components/com_jbusinessdirectory/assets/utils.php:1734
    11	JBusinessUtil::getCategoriesOptions()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:50
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

65. Query Time: 0.07 ms After last query: 0.02 ms Query memory: 0.028 MB Memory before query: 11.050 MB Rows returned: 0
    Duplicate queries: #64

    SELECT t.*
    					
      from  qgvsi_jbusinessdirectory_categories c
    					
      inner join  qgvsi_jbusinessdirectory_language_translations t 
      on c.id=t.object_id 
      where t.type=3 
      and language_tag='en-GB'

    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

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/helpers/translations.php:51
    13	JBusinessDirectoryTranslations::getCategoriesTranslationsObjects()	JROOT/administrator/components/com_jbusinessdirectory/helpers/translations.php:29
    12	JBusinessDirectoryTranslations::getCategoriesTranslations()	JROOT/components/com_jbusinessdirectory/assets/utils.php:1734
    11	JBusinessUtil::getCategoriesOptions()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:50
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

66. Query Time: 1.56 ms After last query: 0.27 ms Query memory: 0.066 MB Memory before query: 11.077 MB Rows returned: 34

    select slec.*, mainCategory, mainCategoryId, companyName, companyId1, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
    				 
      from (
    				 select cp.id, cp.name, cp.alias, cp.short_description, cp.street_number, cp.address, cp.countryId, cp.city, cp.county, cp.province, cp.area, cp.typeId, cp.website, cp.phone, cp.email, cp.state, cp.fax,
    				 cp.averageRating, cp.slogan, cp.logoLocation, cp. review_score, cp.ad_image,
    				 cp.featured,cp.publish_only_city, cp.publish_start_date, cp.publish_end_date,
    				 cp.name as companyName,cp.id as companyId1, cp.latitude, cp.longitude, cp.postalCode,
    				 cn.country_name as countryName,ct.name as typeName, 
    				 count(distinct cr.id) as nr_reviews,
    				 GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
      ORDER BY cg.name separator '#|') as categories,
    				 GROUP_CONCAT(DISTINCT pf.feature) as features,
    				 bc.name as mainCategory, bc.alias as mainCategoryAlias, bc.markerLocation as categoryMaker, bc.id as mainCategoryId
    				 
      from qgvsi_jbusinessdirectory_companies cp 
    				
      left join qgvsi_jbusinessdirectory_company_category cc 
      on cp.id=cc.companyId 
    				
      left join qgvsi_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
    				
      left join qgvsi_jbusinessdirectory_categories bc 
      on bc.id=cp.mainSubcategory 
      and bc.published=1
    				
      left join qgvsi_jbusinessdirectory_company_reviews cr 
      on cr.itemId = cp.id  
      and cr.review_type = 1 
      and cr.approved=2 
    				
      left join qgvsi_jbusinessdirectory_countries cn 
      on cp.countryId=cn.id 
    				
      left join qgvsi_jbusinessdirectory_company_types ct 
      on cp.typeId=ct.id 
    				
      left join qgvsi_jbusinessdirectory_orders inv 
      on inv.company_id=cp.id 
    				
      left join qgvsi_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 qgvsi_jbusinessdirectory_package_fields pf 
      on p.id=pf.package_id
    				
      where (cp.name like '%' or cp.name like '%' )  
      and cp.state=1  
      and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0)   
      and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
      and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null) 
    				
      group by cp.id 
      order by cp.name  ) as slec 
    				
      group by companyId1 
    				
      order by companyName

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	18	100.00	Using temporary; Using filesort
    2	DERIVED	cr	NULL	system	idx_approved,idx_review_type	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    2	DERIVED	p	NULL	const	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Impossible ON condition
    2	DERIVED	cp	NULL	ref	PRIMARY,idx_state,idx_approved,idx_publish_start_date,idx_publish_end_date	idx_state	2	const	35	14.78	Using where; Using temporary; Using filesort
    2	DERIVED	cc	NULL	ref	PRIMARY,idx_category	PRIMARY	4	magarea_db.cp.id	1	100.00	Using index
    2	DERIVED	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cc.categoryId	1	100.00	NULL
    2	DERIVED	bc	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	magarea_db.cp.mainSubcategory	1	100.00	Using where
    2	DERIVED	cn	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cp.countryId	1	100.00	NULL
    2	DERIVED	ct	NULL	eq_ref	PRIMARY	PRIMARY	4	magarea_db.cp.typeId	1	100.00	Using index condition
    2	DERIVED	inv	NULL	ref	idx_company	idx_company	4	magarea_db.cp.id	1	100.00	NULL
    2	DERIVED	pf	NULL	ref	idx_package_id	idx_package_id	5	const	3	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/database.php:33
    15	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:223
    14	JTableCompany->getTotalCompaniesByLetter()	JROOT/components/com_jbusinessdirectory/models/catalog.php:117
    13	JBusinessDirectoryModelCatalog->getTotalCompaniesByLetter()	JROOT/components/com_jbusinessdirectory/models/catalog.php:129
    12	JBusinessDirectoryModelCatalog->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:56
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---

67. Query Time: 0.64 ms After last query: 0.44 ms Query memory: 0.027 MB Memory before query: 11.487 MB Rows returned: 8

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM qgvsi_modules AS m
    
      LEFT JOIN qgvsi_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN qgvsi_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-14 14:04:51') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-14 14:04:51') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 525 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	57	1.75	Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	magarea_db.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	magarea_db.m.id	1	40.00	Using where; Using index

    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:1701
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jbusinessdirectory/views/catalog/tmpl/default.php:51
    13	include JROOT/components/com_jbusinessdirectory/views/catalog/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:59
    10	JBusinessDirectoryViewCatalog->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:25
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66
    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.]

    ---