{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1702171078,
                "last": 1702171078,
                "now": 1702171078
            }
        },
        "registry": {
            "com_jbusinessdirectory": {
                "search": {
                    "ordercol": null
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "citySearch": "Oppenweiler"
    }
}

Zeit

Speicher

160 ausgeführte Abfragen 137.70 ms

1. Abfragezeit: 0.17 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.190 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `jqfh5_session`
   
     WHERE `session_id` = X'6465393031333062616136663533313138656337313036316239373235386562'

   Erklären

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

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

2. Abfragezeit: 0.10 ms Nach letzter Abfrage: 1.19 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.286 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `jqfh5_session`
   
     WHERE `session_id` = X'6465393031333062616136663533313138656337313036316239373235386562' 
     LIMIT 1

   Erklären

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

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

3. Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.291 MB

   INSERT INTO `jqfh5_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6465393031333062616136663533313138656337313036316239373235386562', 1, 1702171078, 0, '', 0)

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jqfh5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6465393031333062616136663533313138656337313036316239373235386562', 1, 1702171078, 0, '', 0)

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

4. Abfragezeit: 0.44 ms Nach letzter Abfrage: 2.04 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 4.479 MB Zeilen zurückgegeben: 42

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jqfh5_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Erklären

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

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

5. Abfragezeit: 0.11 ms Nach letzter Abfrage: 2.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.743 MB Zeilen zurückgegeben: 6

   SELECT id, rules
   
     FROM `jqfh5_viewlevels`

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jqfh5_viewlevels	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	100.00	NULL

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (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:318
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

6. Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.755 MB Zeilen zurückgegeben: 1

   SELECT b.id
   
     FROM jqfh5_usergroups AS a
   
     LEFT JOIN jqfh5_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 1

   Erklären

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

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (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:318
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

7. Abfragezeit: 1.17 ms Nach letzter Abfrage: 0.61 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 4.823 MB Zeilen zurückgegeben: 113

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jqfh5_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jqfh5_extensions	NULL	ref	extension	extension	82	const	176	0.40	Using index condition; Using where; filesort wurde genutzt

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (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:351
   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:356
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

8. Abfragezeit: 0.28 ms Nach letzter Abfrage: 11.55 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 6.413 MB Zeilen zurückgegeben: 1

   SELECT `enabled`
   
     FROM `jqfh5_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jqfh5_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:71
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

9. Abfragezeit: 0.95 ms Nach letzter Abfrage: 13.77 ms Abfragespeichernutzung: 0.076 MB Speichernutzung vor Abfrage: 7.313 MB Zeilen zurückgegeben: 54

   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 jqfh5_menu AS m
   
     LEFT JOIN jqfh5_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

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	5.00	Using index condition; Using where; filesort wurde genutzt
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.m.component_id	1	100.00	Using where

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   Aufrufstapel (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:78
   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:142
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   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:65
   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:533
   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:1141
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

10. Abfragezeit: 4.02 ms Nach letzter Abfrage: 7.07 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 8.041 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM `jqfh5_jbusinessdirectory_companies` c 
    			 
      inner join ( select *, REPLACE(name,'-',' ') as companyName 
      FROM `jqfh5_jbusinessdirectory_companies`) bc 
      on bc.id = c.id
    			 
      WHERE companyName = 'Oppenweiler.html' 
      LIMIT 0, 1

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	753	100.00	NULL
    1	SIMPLE	jqfh5_jbusinessdirectory_companies	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.c.id	1	100.00	Using where

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    9	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/urltranslator.php:54
    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:1190
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

11. Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.082 MB Zeilen zurückgegeben: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jqfh5_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

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

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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:1137
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

12. Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.073 MB

    UPDATE `jqfh5_extensions`
    
      SET `params` = '{\"mediaversion\":\"43765b6924e2db0b853ea840b73aca7c\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

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

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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:1137
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

13. Abfragezeit: 0.18 ms Nach letzter Abfrage: 1.78 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 8.246 MB Zeilen zurückgegeben: 2

    SELECT *
    
      FROM jqfh5_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jqfh5_languages	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	50.00	Using where; filesort wurde genutzt

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

14. Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 8.255 MB Zeilen zurückgegeben: 4

    SELECT id, home, template, s.params
    
      FROM jqfh5_template_styles as s
    
      LEFT JOIN jqfh5_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

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3	100.00	NULL
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	usr_web1030_2.s.template,const	1	5.00	Using index condition; Using where

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

15. Abfragezeit: 0.12 ms Nach letzter Abfrage: 3.02 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 8.551 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #154

    SELECT default_frontend_language 
      FROM jqfh5_jbusinessdirectory_applicationsettings 
      LIMIT 1

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jqfh5_jbusinessdirectory_applicationsettings	NULL	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    7	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:55
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

16. Abfragezeit: 0.21 ms Nach letzter Abfrage: 6.39 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.104 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #17  #26  #27  #28  #29

    SELECT * 
      FROM jqfh5_jbusinessdirectory_applicationsettings fas
    				
      inner join  jqfh5_jbusinessdirectory_date_formats df 
      on fas.date_format_id=df.id
    				
      inner join  jqfh5_jbusinessdirectory_currencies c 
      on fas.currency_id=c.currency_id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fas	NULL	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	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

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    16	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:186
    15	getApplicationSettings()	JROOT/components/com_jbusinessdirectory/models/search.php:58
    14	JBusinessDirectoryModelSearch->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
    12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
    11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
    10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

17. Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.115 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #16  #26  #27  #28  #29

    SELECT * 
      FROM jqfh5_jbusinessdirectory_applicationsettings fas
    				
      inner join  jqfh5_jbusinessdirectory_date_formats df 
      on fas.date_format_id=df.id
    				
      inner join  jqfh5_jbusinessdirectory_currencies c 
      on fas.currency_id=c.currency_id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fas	NULL	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	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

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:191
    15	getApplicationSettings()	JROOT/components/com_jbusinessdirectory/models/search.php:58
    14	JBusinessDirectoryModelSearch->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
    12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
    11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
    10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

18. Abfragezeit: 0.65 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 9.180 MB Zeilen zurückgegeben: 35

    SHOW FULL COLUMNS 
      FROM `jqfh5_jbusinessdirectory_companies`

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jqfh5_jbusinessdirectory_companies`

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:31
    15	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:328
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:75
    13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:181
    12	JBusinessDirectoryModelSearch->getCompaniesByNameAndCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:32
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

19. Abfragezeit: 5.35 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.308 MB Zeilen zurückgegeben: 1

    select slec.*, mainCategory, mainCategoryId, companyName, companyId1, count(cra.id) as nrRatings, features, if(FIND_IN_SET('featured_companies',features) ,1,0) as featured
    				 
      from (
    				 select cp.*, cp.name as companyName,cp.id as companyId1, cn.country_name as countryName,ct.name as typeName, 
    				 GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT(DISTINCT cg.name separator '#') as categoryNames,
    				 GROUP_CONCAT(DISTINCT pf.feature) as features,
    				 bc.name as mainCategory,  bc.id as mainCategoryId
    				
      from jqfh5_jbusinessdirectory_companies cp 
    				
      left join jqfh5_jbusinessdirectory_company_category cc 
      on cp.id=cc.companyId 
    				
      left join jqfh5_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
    				
      left join jqfh5_jbusinessdirectory_categories bc 
      on bc.id=cp.mainSubcategory
    				
      left join jqfh5_jbusinessdirectory_countries cn 
      on cp.countryId=cn.country_id 
    				
      left join jqfh5_jbusinessdirectory_company_types ct 
      on cp.typeId=ct.id 
    				
      left join jqfh5_jbusinessdirectory_invoices inv 
      on inv.company_id=cp.id 
    				
      left join jqfh5_jbusinessdirectory_packages p 
      on (inv.package_id=p.id ) or (p.id=cp.package_id 
      and p.price=0)
    				
      left join jqfh5_jbusinessdirectory_package_fields pf 
      on p.id=pf.package_id
    				
      where 1    
      and ((inv.state= 1 
      and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id 
      and p.days = 0))) or p.price=0)   
      and cp.city = 'Oppenweiler'  
      and cp.state=1 
      and cp.aproved = 2
    				
      group by cp.id 
      order by cp.name  ) as slec 
    				
      left join jqfh5_jbusinessdirectory_company_ratings cra 
      on cra.companyId=companyId1
    				
      group by companyId1 
    				
      order by featured desc, companyName 
      LIMIT 0, 20

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	551570	100.00	Using temporary; filesort wurde genutzt
    1	PRIMARY	cra	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1088	100.00	Using where; Using join buffer (Block Nested Loop)
    2	DERIVED	cp	NULL	ref	PRIMARY,idx_state,idx_approved,idx_package	idx_state	2	const	743	9.97	Using where; Using temporary; filesort wurde genutzt
    2	DERIVED	cc	NULL	ref	PRIMARY	PRIMARY	4	usr_web1030_2.cp.id	10	100.00	Using index
    2	DERIVED	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cc.categoryId	1	100.00	NULL
    2	DERIVED	bc	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cp.mainSubcategory	1	100.00	NULL
    2	DERIVED	cn	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cp.countryId	1	100.00	NULL
    2	DERIVED	ct	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cp.typeId	1	100.00	NULL
    2	DERIVED	inv	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	21	100.00	Using where; Using join buffer (Block Nested Loop)
    2	DERIVED	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	40.74	Range checked for each record (index map: 0x1)
    2	DERIVED	pf	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	29	100.00	Using where; Using join buffer (Block Nested Loop)

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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:237
    13	JTableCompany->getCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:195
    12	JBusinessDirectoryModelSearch->getCompaniesByNameAndCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:32
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

20. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.318 MB Zeilen zurückgegeben: 20

    select * 
      from jqfh5_jbusinessdirectory_categories 
      order by parentId,name

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jqfh5_jbusinessdirectory_categories	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	20	100.00	filesort wurde genutzt

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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/library/category_lib.php:40
    14	JBusinessDirectorCategoryLib->getAllCategories()	JROOT/administrator/components/com_jbusinessdirectory/library/category_lib.php:26
    13	JBusinessDirectorCategoryLib->getCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:215
    12	JBusinessDirectoryModelSearch->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

21. Abfragezeit: 1.08 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.351 MB Zeilen zurückgegeben: 0

    select cp.id  
      from jqfh5_jbusinessdirectory_companies cp 
      left join jqfh5_jbusinessdirectory_company_category cc 
      on cp.id=cc.companyId 
      left join jqfh5_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
      left join jqfh5_jbusinessdirectory_invoices inv 
      on inv.company_id=cp.id 
      left join jqfh5_jbusinessdirectory_packages p 
      on (inv.package_id=p.id ) or (p.id=cp.package_id 
      and p.price=0) 
      where 1  
      and (cp.city like '%Oppenweiler%')   
      and cc.categoryId in  ( 4,89,87,88)  
      and ((inv.state= 1 
      and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id 
      and p.days = 0))) or p.price=0)  
      and cp.state=1 
      and cp.aproved=2 
      group by cp.id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cc	NULL	index	PRIMARY	PRIMARY	8	NULL	1002	40.00	Using where; Using index; Using temporary; filesort wurde genutzt
    1	SIMPLE	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cc.categoryId	1	100.00	Using index
    1	SIMPLE	cp	NULL	eq_ref	PRIMARY,idx_state,idx_approved,idx_package	PRIMARY	4	usr_web1030_2.cc.companyId	1	10.93	Using where
    1	SIMPLE	inv	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	21	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	40.74	Range checked for each record (index map: 0x1)

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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/company.php:304
    13	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:249
    12	JBusinessDirectoryModelSearch->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

22. Abfragezeit: 2.09 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.358 MB Zeilen zurückgegeben: 1

    select cp.id  
      from jqfh5_jbusinessdirectory_companies cp 
      left join jqfh5_jbusinessdirectory_company_category cc 
      on cp.id=cc.companyId 
      left join jqfh5_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
      left join jqfh5_jbusinessdirectory_invoices inv 
      on inv.company_id=cp.id 
      left join jqfh5_jbusinessdirectory_packages p 
      on (inv.package_id=p.id ) or (p.id=cp.package_id 
      and p.price=0) 
      where 1  
      and (cp.city like '%Oppenweiler%')   
      and cc.categoryId in  ( 90,91,3)  
      and ((inv.state= 1 
      and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id 
      and p.days = 0))) or p.price=0)  
      and cp.state=1 
      and cp.aproved=2 
      group by cp.id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cc	NULL	index	PRIMARY	PRIMARY	8	NULL	1002	30.00	Using where; Using index; Using temporary; filesort wurde genutzt
    1	SIMPLE	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cc.categoryId	1	100.00	Using index
    1	SIMPLE	cp	NULL	eq_ref	PRIMARY,idx_state,idx_approved,idx_package	PRIMARY	4	usr_web1030_2.cc.companyId	1	10.93	Using where
    1	SIMPLE	inv	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	21	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	40.74	Range checked for each record (index map: 0x1)

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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/company.php:304
    13	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:249
    12	JBusinessDirectoryModelSearch->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

23. Abfragezeit: 1.84 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.366 MB Zeilen zurückgegeben: 0

    select cp.id  
      from jqfh5_jbusinessdirectory_companies cp 
      left join jqfh5_jbusinessdirectory_company_category cc 
      on cp.id=cc.companyId 
      left join jqfh5_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
      left join jqfh5_jbusinessdirectory_invoices inv 
      on inv.company_id=cp.id 
      left join jqfh5_jbusinessdirectory_packages p 
      on (inv.package_id=p.id ) or (p.id=cp.package_id 
      and p.price=0) 
      where 1  
      and (cp.city like '%Oppenweiler%')   
      and cc.categoryId in  ( 97,86,85,2)  
      and ((inv.state= 1 
      and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id 
      and p.days = 0))) or p.price=0)  
      and cp.state=1 
      and cp.aproved=2 
      group by cp.id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cc	NULL	index	PRIMARY	PRIMARY	8	NULL	1002	40.00	Using where; Using index; Using temporary; filesort wurde genutzt
    1	SIMPLE	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cc.categoryId	1	100.00	Using index
    1	SIMPLE	cp	NULL	eq_ref	PRIMARY,idx_state,idx_approved,idx_package	PRIMARY	4	usr_web1030_2.cc.companyId	1	10.93	Using where
    1	SIMPLE	inv	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	21	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	40.74	Range checked for each record (index map: 0x1)

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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/company.php:304
    13	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:249
    12	JBusinessDirectoryModelSearch->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

24. Abfragezeit: 2.15 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.374 MB Zeilen zurückgegeben: 0

    select cp.id  
      from jqfh5_jbusinessdirectory_companies cp 
      left join jqfh5_jbusinessdirectory_company_category cc 
      on cp.id=cc.companyId 
      left join jqfh5_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
      left join jqfh5_jbusinessdirectory_invoices inv 
      on inv.company_id=cp.id 
      left join jqfh5_jbusinessdirectory_packages p 
      on (inv.package_id=p.id ) or (p.id=cp.package_id 
      and p.price=0) 
      where 1  
      and (cp.city like '%Oppenweiler%')   
      and cc.categoryId in  ( 93,92,1)  
      and ((inv.state= 1 
      and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id 
      and p.days = 0))) or p.price=0)  
      and cp.state=1 
      and cp.aproved=2 
      group by cp.id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cc	NULL	index	PRIMARY	PRIMARY	8	NULL	1002	30.00	Using where; Using index; Using temporary; filesort wurde genutzt
    1	SIMPLE	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cc.categoryId	1	100.00	Using index
    1	SIMPLE	cp	NULL	eq_ref	PRIMARY,idx_state,idx_approved,idx_package	PRIMARY	4	usr_web1030_2.cc.companyId	1	10.93	Using where
    1	SIMPLE	inv	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	21	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	40.74	Range checked for each record (index map: 0x1)

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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/company.php:304
    13	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:249
    12	JBusinessDirectoryModelSearch->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:50
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

25. Abfragezeit: 2.80 ms Nach letzter Abfrage: 1.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.446 MB Zeilen zurückgegeben: 1

    select cp.id  
      from jqfh5_jbusinessdirectory_companies cp 
      left join jqfh5_jbusinessdirectory_company_category cc 
      on cp.id=cc.companyId 
      left join jqfh5_jbusinessdirectory_categories cg 
      on cg.id=cc.categoryId 
      left join jqfh5_jbusinessdirectory_invoices inv 
      on inv.company_id=cp.id 
      left join jqfh5_jbusinessdirectory_packages p 
      on (inv.package_id=p.id ) or (p.id=cp.package_id 
      and p.price=0) 
      where 1  
      and (cp.city like '%Oppenweiler%')    
      and ((inv.state= 1 
      and (now() < (inv.start_date + INTERVAL p.days DAY) or (inv.package_id=p.id 
      and p.days = 0))) or p.price=0)  
      and cp.state=1 
      and cp.aproved=2 
      group by cp.id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cp	NULL	ref	PRIMARY,idx_state,idx_approved,idx_package	idx_state	2	const	743	11.08	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	cc	NULL	ref	PRIMARY	PRIMARY	4	usr_web1030_2.cp.id	10	100.00	Using index
    1	SIMPLE	cg	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web1030_2.cc.categoryId	1	100.00	Using index
    1	SIMPLE	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	Using join buffer (Block Nested Loop)
    1	SIMPLE	inv	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	21	100.00	Using where; Using join buffer (Block Nested Loop)

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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:304
    14	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:145
    13	JBusinessDirectoryModelSearch->getTotalCompaniesByNameAndCategory()	JROOT/components/com_jbusinessdirectory/models/search.php:161
    12	JBusinessDirectoryModelSearch->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:51
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

26. Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.495 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #16  #17  #27  #28  #29

    SELECT * 
      FROM jqfh5_jbusinessdirectory_applicationsettings fas
    				
      inner join  jqfh5_jbusinessdirectory_date_formats df 
      on fas.date_format_id=df.id
    				
      inner join  jqfh5_jbusinessdirectory_currencies c 
      on fas.currency_id=c.currency_id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fas	NULL	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	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

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (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/assets/utils.php:186
    14	getApplicationSettings()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:14
    13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:55
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

27. Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.503 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #16  #17  #26  #28  #29

    SELECT * 
      FROM jqfh5_jbusinessdirectory_applicationsettings fas
    				
      inner join  jqfh5_jbusinessdirectory_date_formats df 
      on fas.date_format_id=df.id
    				
      inner join  jqfh5_jbusinessdirectory_currencies c 
      on fas.currency_id=c.currency_id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fas	NULL	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	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

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:191
    14	getApplicationSettings()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:14
    13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:55
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

28. Abfragezeit: 0.16 ms Nach letzter Abfrage: 1.18 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.590 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #16  #17  #26  #27  #29

    SELECT * 
      FROM jqfh5_jbusinessdirectory_applicationsettings fas
    				
      inner join  jqfh5_jbusinessdirectory_date_formats df 
      on fas.date_format_id=df.id
    				
      inner join  jqfh5_jbusinessdirectory_currencies c 
      on fas.currency_id=c.currency_id

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fas	NULL	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	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

    Profil (Profile)

    Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    17	JDatabase->query()	JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:186
    16	getApplicationSettings()	JROOT/administrator/components/com_jbusinessdirectory/assets/utils.php:400
    15	JUtil::getApplicationSettings()	JROOT/components/com_jbusinessdirectory/include/companies-grid-view.php:13
    14	require_once JROOT/components/com_jbusinessdirectory/include/companies-grid-view.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:199
    13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:55
    10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:29
    8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:76
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

29. Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.599 MB Zeilen zurückgegeben: 1
    </