Tánctanár - Üzleti adatok

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1729559541,
                "last": 1729559543,
                "now": 1729559544
            },
            "token": "Hfld7jyH7ijTuNAG1oCYeBU9e4a1HRjX"
        },
        "registry": {
            "com_jbusinessdirectory": {
                "listing": {
                    "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
        },
        "menuId": "236",
        "categorySearch": null,
        "searchkeyword": "gyerek balett",
        "searchkeywordLocation": "",
        "typeSearch": 2,
        "citySearch": "",
        "starRating": "",
        "regionSearch": "",
        "countrySearch": "",
        "zipcode": "",
        "customAtrributes": "",
        "letter": "",
        "radius": 100,
        "provinceSearch": "",
        "areaSearch": "",
        "filter-by-fav": "",
        "filterParams": "",
        "location": "",
        "geo-latitude": "",
        "geo-longitude": "",
        "geo-country": "",
        "geolocation": "",
        "location-detected": "",
        "categories": "",
        "onlyLocal": 0,
        "categoryId": null,
        "listing-search": true,
        "menuItemId": "236",
        "showCustomMarkers": 1,
        "moreFilters": null,
        "lSearchType": 1
    }
}

Profilinformációk

Memóriahasználat

Adatbázis lekérdezések

46 naplózott lekérdezés 421.17 ms

18 duplikátum található!

13 duplikátum: #9 #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

3 duplikátum: #18 #22 #24

2 duplikátum: #27 #28

Lekérdezés ideje: 4.36 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 4.043 MB Visszaadott sorok: 1

SELECT `data`

  FROM `tk_session`

  WHERE `session_id` = X'366539636c33387073316c75613132746c353936747433366765'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_session	const	PRIMARY	PRIMARY	194	const	1

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Ugyanaz a hívás, mint egy sorral lejjebb.
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 6.37 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 4.670 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `tk_viewlevels`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_viewlevels	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	5

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.37 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 4.682 MB Visszaadott sorok: 2

SELECT b.id

  FROM tk_usergroups AS a

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

  WHERE a.id = 9

Magyarázat

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 7.33 ms Utolsó lekérdezés után: 187.30 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.059 MB Visszaadott sorok: 363

SELECT fas.*
	                  
  FROM tk_jbusinessdirectory_application_settings fas

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fas	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	363

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.39 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:67
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.53 ms Utolsó lekérdezés után: 0.54 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.382 MB Visszaadott sorok: 1

SELECT fas.*
	                  
  FROM tk_jbusinessdirectory_date_formats fas
	                
  WHERE fas.id ='1'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fas	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:78
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.27 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.389 MB Visszaadott sorok: 1

SELECT fas.*
	                  
  FROM tk_jbusinessdirectory_currencies fas
	                
  WHERE fas.currency_id ='59'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fas	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:87
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.36 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.129 MB Visszaadott sorok: 0

SELECT * 
  FROM tk_jbusinessdirectory_categories c 
  where c.type=1 
  and c.alias = 'tanctanarok' 
  LIMIT 0, 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_alias,idx_type	idx_alias	302	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/jbdrouter.php:225
10	JBDRouter->getCategoryParms()	JROOT/plugins/system/urltranslator/jbdrouter.php:146
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.39 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.134 MB Visszaadott sorok: 0

SELECT * 
  FROM `tk_jbusinessdirectory_companies` c 
  where c.alias = 'tanctanarok' 
  LIMIT 0, 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_alis,idx_alias	idx_alis	302	const	1	Using index condition

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/urltranslator/jbdrouter.php:181
10	JBDRouter->getBusinessListingParms()	JROOT/plugins/system/urltranslator/jbdrouter.php:149
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.40 ms Utolsó lekérdezés után: 1.49 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.252 MB Visszaadott sorok: 1

Duplikált lekérdezések: #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:216
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:245
8	PlgSystemHelixultimate->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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 13.30 ms Utolsó lekérdezés után: 0.64 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 9.275 MB

UPDATE `tk_extensions`

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

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

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `tk_extensions` SET `params` = '{\"mediaversion\":\"b61e513ed43a79ebaafc264826d91a84\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.08 ms
Updating	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	12.91 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 10.92 ms Utolsó lekérdezés után: 141.05 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 12.061 MB Visszaadott sorok: 62

SELECT *
	                  
  FROM tk_jbusinessdirectory_mobile_app_config

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_mobile_app_config	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	62

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:9419
16	JBusinessUtil::getMobileAppConfig()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:9438
15	JBusinessUtil::getMobileAppSettings()	JROOT/components/com_jbusinessdirectory/models/search.php:22
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:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 27.27 ms Utolsó lekérdezés után: 0.67 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 12.151 MB Visszaadott sorok: 5

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_default_attributes`

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `tk_jbusinessdirectory_default_attributes`

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.05 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.09 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:19
13	TableDefaultAttributes->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5774
11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:80
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 11.46 ms Utolsó lekérdezés után: 0.54 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.182 MB Visszaadott sorok: 70

SELECT id, name, listing_config as config 
  FROM tk_jbusinessdirectory_default_attributes

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_default_attributes	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	68

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43
12	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5775
11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:80
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 50.34 ms Utolsó lekérdezés után: 3.19 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 12.439 MB Visszaadott sorok: 83

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_companies`

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `tk_jbusinessdirectory_companies`

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.26 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.24 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.11 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
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:25
15	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:47
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:649
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 32.19 ms Utolsó lekérdezés után: 0.40 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 12.575 MB

insert into  tk_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) 
  values 
			('1','1','2024-10-22','gyerek balett','1')

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: insert into tk_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values ('1','1','2024-10-22','gyerek balett','1')

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	6.00 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	15.86 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:7631
13	JBusinessUtil::logSearch()	JROOT/components/com_jbusinessdirectory/models/search.php:666
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 27.43 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 12.582 MB

insert into  tk_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) 
  values 
			('3','1','2024-10-22','2','0')

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: insert into tk_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) values ('3','1','2024-10-22','2','0')

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	27.07 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:7631
13	JBusinessUtil::logSearch()	JROOT/components/com_jbusinessdirectory/models/search.php:666
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 10.18 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 12.607 MB


  SET SQL_BIG_SELECTS=1

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SET SQL_BIG_SELECTS=1

Profil

Status	Duration
Starting	0.08 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:6886
16	JBusinessUtil::setBigSqlSelects()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1147
15	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:953
14	JBusinessDirectoryModelSearch->getTotal()	JROOT/components/com_jbusinessdirectory/models/search.php:620
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:684
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 12.66 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.622 MB Visszaadott sorok: 0

Duplikált lekérdezések: #22 #24

select * 
  from 
					(select count(distinct cp.id) as nr_listings, cp.activity_radius, GROUP_CONCAT(DISTINCT pf.feature) as features, 
					GREATEST(if(FIND_IN_SET('featured_companies',GROUP_CONCAT(DISTINCT pf.feature)),1,0), featured) as featured,
					
					cp.id
					 

					
  from tk_jbusinessdirectory_companies cp

					
					
  left join tk_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId 
					
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1 
					
					
					
					
					
					
					
					
					
					
					
					
  left join tk_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)
					
  left join tk_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id 
					
  left join tk_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and inv.state= 1 
  and (NOW() between inv.start_date 
  and inv.end_date) 
  and p.status=1 
  and 1) or (p.price=0 
  and (p.expiration_type=1 or cp.package_id = p.id) 
  and p.status=1 
  and 1)
					
  left join tk_jbusinessdirectory_package_fields pf 
  on p.id= pf.package_id 
					
  where 1  
  and ((cp.name LIKE '%gyerek%' 
  and cp.name LIKE '%balett%') OR (cp.slogan LIKE '%gyerek%' 
  and cp.slogan LIKE '%balett%') OR (cg.name LIKE '%gyerek%' 
  and cg.name LIKE '%balett%') OR (cp.meta_description LIKE '%gyerek%' 
  and cp.meta_description LIKE '%balett%') OR (cp.short_description LIKE '%gyerek%' 
  and cp.short_description LIKE '%balett%') OR (cp.phone LIKE '%gyerek%' 
  and cp.phone LIKE '%balett%') OR (cp.address LIKE '%gyerek%' 
  and cp.address LIKE '%balett%') OR (cp.postalCode LIKE '%gyerek%' 
  and cp.postalCode LIKE '%balett%') OR (cp.city LIKE '%gyerek%' 
  and cp.city LIKE '%balett%') OR (cp.county LIKE '%gyerek%' 
  and cp.county LIKE '%balett%') OR   LOCATE('gyerek balett', cp.keywords)>0)    
  and find_in_set(2,cp.typeId)    
  and (
								(
									(inv.state= 1 
  and (
										(
											(( now() between inv.start_date 
  and inv.end_date))
											or
											(now() between inv.start_trial_date 
  and inv.end_trial_date)
										)
									))
								)
								or (
									(p.expiration_type=1 
  and p.price=0) or (p.id = cp.package_id 
  and p.price=0))
							)    
					      
  and cp.state=1 
  and (cp.approved = 2 or cp.approved= -1)   
  and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
  and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)  
					         
					
  group by cp.id
					
  having 1 
					) s
					
  where 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3276
2	DERIVED	cp	ALL	idx_state,idx_approved,idx_package,idx_publish_start_date,idx_publish_end_date	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	13	Using where; Using temporary; Fájlrendezés használata
2	DERIVED	cc	ref	PRIMARY,idx_category	idx_category	4	rvybpapt_tanck.cp.id	1	Using index
2	DERIVED	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	rvybpapt_tanck.cc.categoryId	1	Using where
2	DERIVED	ct	index	NULL	idx_only_for_admin	1	NULL	7	Using where; Using index; Using join buffer (flat, BNL join)
2	DERIVED	inv	ref	idx_company	idx_company	4	rvybpapt_tanck.cp.id	1
2	DERIVED	p	ALL	PRIMARY,idx_status,idx_price	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
2	DERIVED	pf	ref	idx_package_id	idx_package_id	5	rvybpapt_tanck.p.id	9	Using where

Profil

Status	Duration
Starting	0.29 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.14 ms
Optimizing	0.01 ms
Optimizing	0.07 ms
Statistics	0.15 ms
Statistics	0.02 ms
Preparing	0.09 ms
Creating tmp table	0.05 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
Executing	0.01 ms
Sending data	0.23 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Removing tmp table	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1154
15	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:953
14	JBusinessDirectoryModelSearch->getTotal()	JROOT/components/com_jbusinessdirectory/models/search.php:620
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:684
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 6.40 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.615 MB


  SET SESSION group_concat_max_len = 10000

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SET SESSION group_concat_max_len = 10000

Profil

Status	Duration
Starting	0.10 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:6867
15	JBusinessUtil::setGroupConcatLenght()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1110
14	JTableCompany->getCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:629
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:684
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 11.23 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.630 MB Visszaadott sorok: 0

select slec.* , companyName  ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
				 
  from (
					select 
					cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering
								,GROUP_CONCAT( DISTINCT cg.id) as categoryIds
					 
					 ,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name 
					
  from tk_jbusinessdirectory_companies cp
                    
					
  left join tk_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId 
			   	    
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1

			   	     
  left join tk_jbusinessdirectory_categories bcm 
  on bcm.id=cp.mainSubcategory 
  and bcm.published=1 
				    
					
  left join tk_jbusinessdirectory_company_reviews cr 
  on cr.itemId = cp.id  
  and cr.review_type = 1 
  and cr.approved=2  
					
					
					
					
					
					
					
					
					
					
  left join tk_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id

                    
  left join tk_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)
                    
                    
    					
  left join tk_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id
    					
  left join tk_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and inv.state= 1 
  and (NOW() between inv.start_date 
  and inv.end_date) 
  and p.status=1 
  and 1) or (p.price=0 
  and (p.expiration_type=1 or cp.package_id = p.id) 
  and p.status=1 
  and 1)
    					
  left join tk_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id
					
                    
					
  left join tk_jbusinessdirectory_bookmarks bk 
  on bk.item_id = cp.id 
  and bk.user_id = 0 
  and bk.item_type = 1
					
					
					
                    
  where 1 
  and  cp.state=1   
  and ((cp.name LIKE '%gyerek%' 
  and cp.name LIKE '%balett%') OR (cp.slogan LIKE '%gyerek%' 
  and cp.slogan LIKE '%balett%') OR (cg.name LIKE '%gyerek%' 
  and cg.name LIKE '%balett%') OR (cp.meta_description LIKE '%gyerek%' 
  and cp.meta_description LIKE '%balett%') OR (cp.short_description LIKE '%gyerek%' 
  and cp.short_description LIKE '%balett%') OR (cp.phone LIKE '%gyerek%' 
  and cp.phone LIKE '%balett%') OR (cp.address LIKE '%gyerek%' 
  and cp.address LIKE '%balett%') OR (cp.postalCode LIKE '%gyerek%' 
  and cp.postalCode LIKE '%balett%') OR (cp.city LIKE '%gyerek%' 
  and cp.city LIKE '%balett%') OR (cp.county LIKE '%gyerek%' 
  and cp.county LIKE '%balett%') OR   LOCATE('gyerek balett', cp.keywords)>0)    
  and find_in_set(2,cp.typeId)     
  and (
								(
									(inv.state= 1 
  and (
										(
											(( now() between inv.start_date 
  and inv.end_date))
											or
											(now() between inv.start_trial_date 
  and inv.end_trial_date)
										)
									))
								)
								or (
									(p.expiration_type=1 
  and p.price=0) or (p.id = cp.package_id 
  and p.price=0))
							) 
		       
  and (cp.approved = 2 or cp.approved= -1)   
  and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
  and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)   
		        
		  
					
  group by cp.id 
				) as slec 
				
  where 1  
				
  having 1 
                 
  order by featured desc, packageOrder desc, viewCount desc 
  LIMIT 0, 20

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3276	Fájlrendezés használata
2	DERIVED	cp	ALL	idx_state,idx_approved,idx_package,idx_publish_start_date,idx_publish_end_date	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	13	Using where; Using temporary; Fájlrendezés használata
2	DERIVED	cc	ref	PRIMARY,idx_category	idx_category	4	rvybpapt_tanck.cp.id	1	Using index
2	DERIVED	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	rvybpapt_tanck.cc.categoryId	1	Using where
2	DERIVED	cr	ref\|filter	idx_approved,idx_review_type,idx_item_id	idx_item_id\|idx_approved	4\|1	rvybpapt_tanck.cp.id	1 (50%)	Using where; Using rowid filter
2	DERIVED	ct	index	NULL	idx_only_for_admin	1	NULL	7	Using where; Using index; Using join buffer (flat, BNL join)
2	DERIVED	inv	ref	idx_company	idx_company	4	rvybpapt_tanck.cp.id	1
2	DERIVED	p	ALL	PRIMARY,idx_status,idx_price	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
2	DERIVED	pf	ref	idx_package_id	idx_package_id	5	rvybpapt_tanck.p.id	9	Using where

Profil

Status	Duration
Starting	0.28 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.17 ms
Optimizing	0.01 ms
Optimizing	0.08 ms
Statistics	0.17 ms
Statistics	0.02 ms
Preparing	0.10 ms
Creating tmp table	0.06 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Executing	0.00 ms
Sending data	0.24 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.00 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Removing tmp table	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1120
14	JTableCompany->getCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:629
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:684
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 10.97 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.643 MB Visszaadott sorok: 0

select slec.* , companyName  ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
				 
  from (
					select 
					cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering
								,GROUP_CONCAT( DISTINCT cg.id) as categoryIds
					 
					 ,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name 
					
  from tk_jbusinessdirectory_companies cp
                    
					
  left join tk_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId 
			   	    
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1

			   	     
  left join tk_jbusinessdirectory_categories bcm 
  on bcm.id=cp.mainSubcategory 
  and bcm.published=1 
				    
					
  left join tk_jbusinessdirectory_company_reviews cr 
  on cr.itemId = cp.id  
  and cr.review_type = 1 
  and cr.approved=2  
					
					
					
					
					
					
					
					
					
					
  left join tk_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id

                    
  left join tk_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)
                    
                    
    					
  left join tk_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id
    					
  left join tk_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and inv.state= 1 
  and (NOW() between inv.start_date 
  and inv.end_date) 
  and p.status=1 
  and 1) or (p.price=0 
  and (p.expiration_type=1 or cp.package_id = p.id) 
  and p.status=1 
  and 1)
    					
  left join tk_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id
					
                    
					
  left join tk_jbusinessdirectory_bookmarks bk 
  on bk.item_id = cp.id 
  and bk.user_id = 0 
  and bk.item_type = 1
					
					
					
                    
  where 1 
  and  cp.state=1   
  and ((cp.name LIKE '%gyerek%' 
  and cp.name LIKE '%balett%') OR (cp.slogan LIKE '%gyerek%' 
  and cp.slogan LIKE '%balett%') OR (cg.name LIKE '%gyerek%' 
  and cg.name LIKE '%balett%') OR (cp.meta_description LIKE '%gyerek%' 
  and cp.meta_description LIKE '%balett%') OR (cp.short_description LIKE '%gyerek%' 
  and cp.short_description LIKE '%balett%') OR (cp.phone LIKE '%gyerek%' 
  and cp.phone LIKE '%balett%') OR (cp.address LIKE '%gyerek%' 
  and cp.address LIKE '%balett%') OR (cp.postalCode LIKE '%gyerek%' 
  and cp.postalCode LIKE '%balett%') OR (cp.city LIKE '%gyerek%' 
  and cp.city LIKE '%balett%') OR (cp.county LIKE '%gyerek%' 
  and cp.county LIKE '%balett%') OR   LOCATE('gyerek balett', cp.keywords)>0)    
  and find_in_set(2,cp.typeId)     
  and (
								(
									(inv.state= 1 
  and (
										(
											(( now() between inv.start_date 
  and inv.end_date))
											or
											(now() between inv.start_trial_date 
  and inv.end_trial_date)
										)
									))
								)
								or (
									(p.expiration_type=1 
  and p.price=0) or (p.id = cp.package_id 
  and p.price=0))
							) 
		       
  and (cp.approved = 2 or cp.approved= -1)   
  and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
  and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)   
		        
		  
					
  group by cp.id 
				) as slec 
				
  where 1  
				
  having 1 
                 
  order by featured desc, packageOrder desc, viewCount desc

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3276	Fájlrendezés használata
2	DERIVED	cp	ALL	idx_state,idx_approved,idx_package,idx_publish_start_date,idx_publish_end_date	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	13	Using where; Using temporary; Fájlrendezés használata
2	DERIVED	cc	ref	PRIMARY,idx_category	idx_category	4	rvybpapt_tanck.cp.id	1	Using index
2	DERIVED	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	rvybpapt_tanck.cc.categoryId	1	Using where
2	DERIVED	cr	ref\|filter	idx_approved,idx_review_type,idx_item_id	idx_item_id\|idx_approved	4\|1	rvybpapt_tanck.cp.id	1 (50%)	Using where; Using rowid filter
2	DERIVED	ct	index	NULL	idx_only_for_admin	1	NULL	7	Using where; Using index; Using join buffer (flat, BNL join)
2	DERIVED	inv	ref	idx_company	idx_company	4	rvybpapt_tanck.cp.id	1
2	DERIVED	p	ALL	PRIMARY,idx_status,idx_price	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
2	DERIVED	pf	ref	idx_package_id	idx_package_id	5	rvybpapt_tanck.p.id	9	Using where

Profil

Status	Duration
Starting	0.29 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.18 ms
Optimizing	0.01 ms
Optimizing	0.08 ms
Statistics	0.19 ms
Statistics	0.02 ms
Preparing	0.10 ms
Creating tmp table	0.06 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.21 ms
Executing	0.01 ms
Sending data	0.24 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Removing tmp table	0.01 ms
Freeing items	0.03 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1133
14	JTableCompany->getCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:629
13	JBusinessDirectoryModelSearch->getCompanies()	JROOT/components/com_jbusinessdirectory/models/search.php:684
12	JBusinessDirectoryModelSearch->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:83
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 2.66 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.642 MB Visszaadott sorok: 0

Duplikált lekérdezések: #18 #24

select * 
  from 
					(select count(distinct cp.id) as nr_listings, cp.activity_radius, GROUP_CONCAT(DISTINCT pf.feature) as features, 
					GREATEST(if(FIND_IN_SET('featured_companies',GROUP_CONCAT(DISTINCT pf.feature)),1,0), featured) as featured,
					
					cp.id
					 

					
  from tk_jbusinessdirectory_companies cp

					
					
  left join tk_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId 
					
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1 
					
					
					
					
					
					
					
					
					
					
					
					
  left join tk_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)
					
  left join tk_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id 
					
  left join tk_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and inv.state= 1 
  and (NOW() between inv.start_date 
  and inv.end_date) 
  and p.status=1 
  and 1) or (p.price=0 
  and (p.expiration_type=1 or cp.package_id = p.id) 
  and p.status=1 
  and 1)
					
  left join tk_jbusinessdirectory_package_fields pf 
  on p.id= pf.package_id 
					
  where 1  
  and ((cp.name LIKE '%gyerek%' 
  and cp.name LIKE '%balett%') OR (cp.slogan LIKE '%gyerek%' 
  and cp.slogan LIKE '%balett%') OR (cg.name LIKE '%gyerek%' 
  and cg.name LIKE '%balett%') OR (cp.meta_description LIKE '%gyerek%' 
  and cp.meta_description LIKE '%balett%') OR (cp.short_description LIKE '%gyerek%' 
  and cp.short_description LIKE '%balett%') OR (cp.phone LIKE '%gyerek%' 
  and cp.phone LIKE '%balett%') OR (cp.address LIKE '%gyerek%' 
  and cp.address LIKE '%balett%') OR (cp.postalCode LIKE '%gyerek%' 
  and cp.postalCode LIKE '%balett%') OR (cp.city LIKE '%gyerek%' 
  and cp.city LIKE '%balett%') OR (cp.county LIKE '%gyerek%' 
  and cp.county LIKE '%balett%') OR   LOCATE('gyerek balett', cp.keywords)>0)    
  and find_in_set(2,cp.typeId)    
  and (
								(
									(inv.state= 1 
  and (
										(
											(( now() between inv.start_date 
  and inv.end_date))
											or
											(now() between inv.start_trial_date 
  and inv.end_trial_date)
										)
									))
								)
								or (
									(p.expiration_type=1 
  and p.price=0) or (p.id = cp.package_id 
  and p.price=0))
							)    
					      
  and cp.state=1 
  and (cp.approved = 2 or cp.approved= -1)   
  and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
  and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)  
					         
					
  group by cp.id
					
  having 1 
					) s
					
  where 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3276
2	DERIVED	cp	ALL	idx_state,idx_approved,idx_package,idx_publish_start_date,idx_publish_end_date	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	13	Using where; Using temporary; Fájlrendezés használata
2	DERIVED	cc	ref	PRIMARY,idx_category	idx_category	4	rvybpapt_tanck.cp.id	1	Using index
2	DERIVED	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	rvybpapt_tanck.cc.categoryId	1	Using where
2	DERIVED	ct	index	NULL	idx_only_for_admin	1	NULL	7	Using where; Using index; Using join buffer (flat, BNL join)
2	DERIVED	inv	ref	idx_company	idx_company	4	rvybpapt_tanck.cp.id	1
2	DERIVED	p	ALL	PRIMARY,idx_status,idx_price	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
2	DERIVED	pf	ref	idx_package_id	idx_package_id	5	rvybpapt_tanck.p.id	9	Using where

Profil

Status	Duration
Starting	0.27 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.15 ms
Optimizing	0.01 ms
Optimizing	0.07 ms
Statistics	0.14 ms
Statistics	0.01 ms
Preparing	0.09 ms
Creating tmp table	0.06 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
Executing	0.01 ms
Sending data	0.24 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Removing tmp table	0.01 ms
Freeing items	0.00 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Removing tmp table	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1154
13	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:953
12	JBusinessDirectoryModelSearch->getTotal()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:84
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 12.81 ms Utolsó lekérdezés után: 0.51 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 12.653 MB Visszaadott sorok: 18

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_attributes`

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `tk_jbusinessdirectory_attributes`

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.08 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.09 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
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/attribute.php:19
15	JTableAttribute->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:47
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:1807
12	JBusinessDirectoryModelSearch->getCustomAttributeValues()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:120
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 3.46 ms Utolsó lekérdezés után: 1.41 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.795 MB Visszaadott sorok: 0

Duplikált lekérdezések: #18 #22

select * 
  from 
					(select count(distinct cp.id) as nr_listings, cp.activity_radius, GROUP_CONCAT(DISTINCT pf.feature) as features, 
					GREATEST(if(FIND_IN_SET('featured_companies',GROUP_CONCAT(DISTINCT pf.feature)),1,0), featured) as featured,
					
					cp.id
					 

					
  from tk_jbusinessdirectory_companies cp

					
					
  left join tk_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId 
					
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1 
					
					
					
					
					
					
					
					
					
					
					
					
  left join tk_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)
					
  left join tk_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id 
					
  left join tk_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and inv.state= 1 
  and (NOW() between inv.start_date 
  and inv.end_date) 
  and p.status=1 
  and 1) or (p.price=0 
  and (p.expiration_type=1 or cp.package_id = p.id) 
  and p.status=1 
  and 1)
					
  left join tk_jbusinessdirectory_package_fields pf 
  on p.id= pf.package_id 
					
  where 1  
  and ((cp.name LIKE '%gyerek%' 
  and cp.name LIKE '%balett%') OR (cp.slogan LIKE '%gyerek%' 
  and cp.slogan LIKE '%balett%') OR (cg.name LIKE '%gyerek%' 
  and cg.name LIKE '%balett%') OR (cp.meta_description LIKE '%gyerek%' 
  and cp.meta_description LIKE '%balett%') OR (cp.short_description LIKE '%gyerek%' 
  and cp.short_description LIKE '%balett%') OR (cp.phone LIKE '%gyerek%' 
  and cp.phone LIKE '%balett%') OR (cp.address LIKE '%gyerek%' 
  and cp.address LIKE '%balett%') OR (cp.postalCode LIKE '%gyerek%' 
  and cp.postalCode LIKE '%balett%') OR (cp.city LIKE '%gyerek%' 
  and cp.city LIKE '%balett%') OR (cp.county LIKE '%gyerek%' 
  and cp.county LIKE '%balett%') OR   LOCATE('gyerek balett', cp.keywords)>0)    
  and find_in_set(2,cp.typeId)    
  and (
								(
									(inv.state= 1 
  and (
										(
											(( now() between inv.start_date 
  and inv.end_date))
											or
											(now() between inv.start_trial_date 
  and inv.end_trial_date)
										)
									))
								)
								or (
									(p.expiration_type=1 
  and p.price=0) or (p.id = cp.package_id 
  and p.price=0))
							)    
					      
  and cp.state=1 
  and (cp.approved = 2 or cp.approved= -1)   
  and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
  and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)  
					         
					
  group by cp.id
					
  having 1 
					) s
					
  where 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3276
2	DERIVED	cp	ALL	idx_state,idx_approved,idx_package,idx_publish_start_date,idx_publish_end_date	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	13	Using where; Using temporary; Fájlrendezés használata
2	DERIVED	cc	ref	PRIMARY,idx_category	idx_category	4	rvybpapt_tanck.cp.id	1	Using index
2	DERIVED	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	rvybpapt_tanck.cc.categoryId	1	Using where
2	DERIVED	ct	index	NULL	idx_only_for_admin	1	NULL	7	Using where; Using index; Using join buffer (flat, BNL join)
2	DERIVED	inv	ref	idx_company	idx_company	4	rvybpapt_tanck.cp.id	1
2	DERIVED	p	ALL	PRIMARY,idx_status,idx_price	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
2	DERIVED	pf	ref	idx_package_id	idx_package_id	5	rvybpapt_tanck.p.id	9	Using where

Profil

Status	Duration
Starting	0.28 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.14 ms
Optimizing	0.01 ms
Optimizing	0.07 ms
Statistics	0.15 ms
Statistics	0.02 ms
Preparing	0.09 ms
Creating tmp table	0.06 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.19 ms
Executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Removing tmp table	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1154
14	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:953
13	JBusinessDirectoryModelSearch->getTotal()	JROOT/components/com_jbusinessdirectory/models/search.php:966
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:148
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 3.47 ms Utolsó lekérdezés után: 0.17 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.797 MB Visszaadott sorok: 8

SELECT DISTINCT UPPER(
  LEFT(name, 1)) as letter 
  FROM tk_jbusinessdirectory_companies 
  WHERE approved=2 
  ORDER BY letter

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_companies	ALL	idx_approved	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	13	Using where; Using temporary; Fájlrendezés használata

Profil

Status	Duration
Starting	0.84 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1522
13	JTableCompany->getUsedLettersForActiveBusiness()	JROOT/components/com_jbusinessdirectory/models/search.php:2105
12	JBusinessDirectoryModelSearch->getUsedLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:150
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 2.48 ms Utolsó lekérdezés után: 0.44 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 12.805 MB Visszaadott sorok: 5

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_types`

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `tk_jbusinessdirectory_company_types`

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.26 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.05 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.09 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
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/companytypes.php:20
15	JTableCompanyTypes->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:47
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:1621
12	JBusinessDirectoryModelSearch->getType()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:162
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.61 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.822 MB Visszaadott sorok: 1

Duplikált lekérdezések: #28

select * 
  from tk_jbusinessdirectory_company_types 
  where id='2'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_types	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/companytypes.php:38
13	JTableCompanyTypes->getCompanyType()	JROOT/components/com_jbusinessdirectory/models/search.php:1622
12	JBusinessDirectoryModelSearch->getType()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:162
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 74.79 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.829 MB Visszaadott sorok: 1

Duplikált lekérdezések: #27

select * 
  from tk_jbusinessdirectory_company_types 
  where id='2'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_types	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/companytypes.php:38
13	JTableCompanyTypes->getCompanyType()	JROOT/components/com_jbusinessdirectory/models/search.php:2018
12	JBusinessDirectoryModelSearch->getCompanyType()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:164
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 19.87 ms Utolsó lekérdezés után: 2.53 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 13.048 MB Visszaadott sorok: 4

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM tk_modules AS m

  LEFT JOIN tk_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN tk_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 <= '2024-10-22 01:12:24') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-22 01:12:24') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 236 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mm	index	PRIMARY	PRIMARY	8	NULL	25	Using where; Using index; Using temporary; Fájlrendezés használata
1	SIMPLE	m	eq_ref	PRIMARY,published,newsfeeds	PRIMARY	4	rvybpapt_tanck.mm.moduleid	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	rvybpapt_tanck.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.38 ms
Creating sort index	0.04 ms
Removing tmp table	0.09 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Ugyanaz a hívás, mint egy sorral lejjebb.
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:441
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:72
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:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.25 ms Utolsó lekérdezés után: 7.96 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 13.916 MB Visszaadott sorok: 32

SELECT * 
  FROM tk_jbusinessdirectory_categories 
				  
  WHERE parent_id=1 
  AND published=1 
  AND type=1  
			      
  ORDER BY lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_categories	ALL	idx_parent,idx_state,idx_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	94	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.31 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusiness_listings_search/helper.php:21
17	modJBusinessDirectoryHelper::getMainCategories()	JROOT/modules/mod_jbusiness_listings_search/helper.php:241
16	modJBusinessDirectoryHelper::filterCategories()	JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php:73
15	include JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:216
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:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.79 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 14.103 MB Visszaadott sorok: 55

SELECT c.* 
  FROM tk_jbusinessdirectory_categories c
                   
  INNER JOIN  tk_jbusinessdirectory_categories  cc  
  ON c.parent_id = cc.id  
                   
  WHERE c.parent_id!=1 
  AND c.published=1  
  AND c.type=1
                   
  ORDER BY c.lft 
  LIMIT 0, 1000

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	idx_parent,idx_state,idx_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	94	Using where; Fájlrendezés használata
1	SIMPLE	cc	eq_ref	PRIMARY	PRIMARY	4	rvybpapt_tanck.c.parent_id	1	Using index

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.33 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusiness_listings_search/helper.php:31
17	modJBusinessDirectoryHelper::getSubCategories()	JROOT/modules/mod_jbusiness_listings_search/helper.php:242
16	modJBusinessDirectoryHelper::filterCategories()	JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php:73
15	include JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:216
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:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.61 ms Utolsó lekérdezés után: 2.56 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.235 MB Visszaadott sorok: 13

SELECT city, county 
                      
  FROM tk_jbusinessdirectory_companies
                      
  WHERE state = 1 
  AND city != ''
                        
                  
  ORDER BY county ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_companies	ALL	idx_state,idx_city	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	13	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusiness_listings_search/helper.php:100
16	modJBusinessDirectoryHelper::getCitiesRegions()	JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php:150
15	include JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:216
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:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.12 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.011 MB memória a lekérdezés előtt: 14.256 MB Visszaadott sorok: 2

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(DISTINCT ao.icon 
  ORDER BY ao.ordering asc SEPARATOR '|#')  optionsIcons,
				at.code as attributeTypeCode
				
  from tk_jbusinessdirectory_attributes a
				
  left join tk_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type
				
  left join tk_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id
				
  where a.status = 1 
				
  and a.id in (18,17)
				
  group by a.id
				
  order by a.ordering

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY,idx_status	idx_status	9	NULL	2	Using index condition; Using temporary; Fájlrendezés használata
1	SIMPLE	at	eq_ref	PRIMARY	PRIMARY	4	rvybpapt_tanck.a.type	1	Using where
1	SIMPLE	ao	ref	idx_attribute_id	idx_attribute_id	5	rvybpapt_tanck.a.id	1

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting for group	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.33 ms
Creating sort index	0.03 ms
Removing tmp table	0.09 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Removing tmp table	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/attribute.php:76
17	JTableAttribute->getAttributesConfiguration()	JROOT/modules/mod_jbusiness_listings_search/helper.php:225
16	modJBusinessDirectoryHelper::getCustomAttributes()	JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php:204
15	include JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:216
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:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.45 ms Utolsó lekérdezés után: 1.18 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 14.394 MB Visszaadott sorok: 1

select * 
  from tk_jbusinessdirectory_countries 
  where id = 97

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_countries	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:4973
18	JBusinessUtil::getCountry()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5033
17	JBusinessUtil::getCountryRestriction()	JROOT/modules/mod_jbusiness_listings_search/tmpl/default.php:19
16	require JROOT/modules/mod_jbusiness_listings_search/tmpl/default.php	JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php:244
15	include JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:216
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:198
10	JBusinessDirectoryViewSearch->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.87 ms Utolsó lekérdezés után: 10.06 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 14.539 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:119
9	HelixUltimate\Framework\Core\HelixUltimate->__construct()	JROOT/plugins/system/helixultimate/core/helixultimate.php:37
8	HelixUltimate->__construct()	JROOT/templates/j-network/index.php:17
7	require JROOT/templates/j-network/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.68 ms Utolsó lekérdezés után: 0.31 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 14.573 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:388
9	HelixUltimate\Framework\Platform\Helper::flushSettingsDataToJs()	JROOT/plugins/system/helixultimate/core/helixultimate.php:38
8	HelixUltimate->__construct()	JROOT/templates/j-network/index.php:17
7	require JROOT/templates/j-network/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 15.22 ms Utolsó lekérdezés után: 3.57 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.860 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #38 #39 #40 #41 #42 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
15	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
14	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/Classes/HelixultimateMenu.php:100
13	HelixUltimate\Framework\Core\Classes\HelixultimateMenu->__construct()	JROOT/plugins/system/helixultimate/core/classes/menu.php:40
12	HelixultimateMenu->__construct()	JROOT/templates/j-network/features/menu.php:44
11	HelixUltimateFeatureMenu->renderFeature()	JROOT/templates/j-network/headers/style-2/header.php:61
10	include JROOT/templates/j-network/headers/style-2/header.php	JROOT/libraries/src/Layout/FileLayout.php:125
9	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1604
8	HelixUltimate\Framework\Core\HelixUltimate->getHeaderStyle()	JROOT/templates/j-network/index.php:141
7	require JROOT/templates/j-network/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 15.71 ms Utolsó lekérdezés után: 1.95 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.910 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #39 #40 #41 #42 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	12.57 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
14	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
13	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/Classes/HelixultimateMenu.php:100
12	HelixUltimate\Framework\Core\Classes\HelixultimateMenu->__construct()	JROOT/plugins/system/helixultimate/core/classes/menu.php:40
11	HelixultimateMenu->__construct()	JROOT/templates/j-network/features/menu.php:44
10	HelixUltimateFeatureMenu->renderFeature()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:557
9	HelixUltimate\Framework\Core\HelixUltimate->include_features()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:575
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/j-network/index.php:142
7	require JROOT/templates/j-network/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 9.66 ms Utolsó lekérdezés után: 1.95 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 15.075 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #38 #40 #41 #42 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:74
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:700
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:596
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/j-network/index.php:142
7	require JROOT/templates/j-network/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 13.24 ms Utolsó lekérdezés után: 2.08 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 15.079 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #38 #39 #41 #42 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
17	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
16	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/layouts/frontend/modules.php:18
15	include JROOT/plugins/system/helixultimate/layouts/frontend/modules.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/rows.php:44
13	include JROOT/plugins/system/helixultimate/layouts/frontend/rows.php	JROOT/libraries/src/Layout/FileLayout.php:125
12	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/layouts/frontend/generate.php:74
11	include JROOT/plugins/system/helixultimate/layouts/frontend/generate.php	JROOT/libraries/src/Layout/FileLayout.php:125
10	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:700
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:596
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/j-network/index.php:142
7	require JROOT/templates/j-network/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.79 ms Utolsó lekérdezés után: 5.37 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 15.022 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #38 #39 #40 #42 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
14	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
13	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:390
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.39 ms Utolsó lekérdezés után: 0.28 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 15.058 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #38 #39 #40 #41 #43 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
15	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
14	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:119
13	HelixUltimate\Framework\Core\HelixUltimate->__construct()	JROOT/plugins/system/helixultimate/helixultimate.php:402
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.38 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 15.094 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #38 #39 #40 #41 #42 #44 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:425
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 15.102 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #38 #39 #40 #41 #42 #43 #45 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:426
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.38 ms Utolsó lekérdezés után: 0.25 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 15.110 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #46

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:427
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.44 ms Utolsó lekérdezés után: 1.09 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 15.173 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9 #35 #36 #37 #38 #39 #40 #41 #42 #43 #44 #45

SELECT *

  FROM `tk_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '9'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
9	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
8	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:563
7	PlgSystemHelixultimate->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

30 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

13 × SELECT * 
  FROM `tk_template_styles`

3 × select * 
  from       (select count(distinct cp.id) as nr_listings, cp.activity_radius, GROUP_CONCAT(DISTINCT pf.feature) as features,       GREATEST(if(FIND_IN_SET('featured_companies',GROUP_CONCAT(DISTINCT pf.feature)),1,0), featured) as featured,            cp.id              
  from tk_jbusinessdirectory_companies cp             
  left join tk_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId       
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1                                                                         
  left join tk_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)      
  left join tk_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id       
  left join tk_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and inv.state= 1 
  and (NOW() between inv.start_date 
  and inv.end_date) 
  and p.status=1 
  and 1) or (p.price=0 
  and (p.expiration_type=1 or cp.package_id = p.id) 
  and p.status=1 
  and 1)      
  left join tk_jbusinessdirectory_package_fields pf 
  on p.id= pf.package_id

2 × select slec.* , companyName  ,features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured      
  from (      select       cp.id, cp.featured, cp.name as companyName, cp.city, cp.review_score, cp.viewCount, cp.activity_radius, count(distinct cr.id) as nr_reviews, cp.ordering         ,GROUP_CONCAT( DISTINCT cg.id) as categoryIds              ,GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, p.name as package_name       
  from tk_jbusinessdirectory_companies cp                           
  left join tk_jbusinessdirectory_company_category cc 
  on cp.id=cc.companyId             
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1              
  left join tk_jbusinessdirectory_categories bcm 
  on bcm.id=cp.mainSubcategory 
  and bcm.published=1                
  left join tk_jbusinessdirectory_company_reviews cr 
  on cr.itemId = cp.id  
  and cr.review_type = 1 
  and cr.approved=2                                                              
  left join tk_jbusinessdirectory_countries cn 
  on cp.countryId=cn.id                      
  left join tk_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,cp.typeId)                                                    
  left join tk_jbusinessdirectory_orders inv 
  on inv.company_id=cp.id          
  left join tk_jbusinessdirectory_packages p 
  on (inv.package_id=p.id 
  and inv.state= 1 
  and (NOW() between inv.start_date 
  and inv.end_date) 
  and p.status=1 
  and 1) or (p.price=0 
  and (p.expiration_type=1 or cp.package_id = p.id) 
  and p.status=1 
  and 1)          
  left join tk_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id                                 
  left join tk_jbusinessdirectory_bookmarks bk 
  on bk.item_id = cp.id 
  and bk.user_id = 0 
  and bk.item_type = 1

2 × select * 
  from tk_jbusinessdirectory_company_types

1 × SELECT `data` 
  FROM `tk_session`

1 × SELECT id, rules 
  FROM `tk_viewlevels

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

1 × SELECT fas.*                    
  FROM tk_jbusinessdirectory_application_settings fa

1 × SELECT fas.*                    
  FROM tk_jbusinessdirectory_date_formats fas

1 × SELECT fas.*                    
  FROM tk_jbusinessdirectory_currencies fas

1 × SELECT * 
  FROM tk_jbusinessdirectory_categories c

1 × SELECT * 
  FROM `tk_jbusinessdirectory_companies` c

1 × SELECT *                    
  FROM tk_jbusinessdirectory_mobile_app_confi

1 × SELECT id, name, listing_config as config 
  FROM tk_jbusinessdirectory_default_attribute

1 × SELECT DISTINCT UPPER(
  LEFT(name, 1)) as letter 
  FROM tk_jbusinessdirectory_companies

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM tk_modules AS m 
  LEFT JOIN tk_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN tk_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM tk_jbusinessdirectory_categories

1 × SELECT c.* 
  FROM tk_jbusinessdirectory_categories c                    
  INNER JOIN  tk_jbusinessdirectory_categories  cc  
  ON c.parent_id = cc.id

1 × SELECT city, county                        
  FROM tk_jbusinessdirectory_companies

1 × 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(DISTINCT ao.icon 
  ORDER BY ao.ordering asc SEPARATOR '|#')  optionsIcons,     at.code as attributeTypeCode     
  from tk_jbusinessdirectory_attributes a     
  left join tk_jbusinessdirectory_attribute_types AS at 
  on at.id=a.type     
  left join tk_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id

1 × select * 
  from tk_jbusinessdirectory_countries

EGYÉB táblák:

1 × UPDATE `tk_extensions` 
  SET `params` = '{\"mediaversion\":\"b61e513ed43a79ebaafc264826d91a84\"}'

1 × SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_default_attributes

1 × SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_companies

1 × insert into  tk_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) 
  values     ('1','1','2024-10-22','gyerek balett','1'

1 × insert into  tk_jbusinessdirectory_search_logs (item_type, object_type, date, value, has_text) 
  values     ('3','1','2024-10-22','2','0'

```
1 × 
  SET SQL_BIG_SELECTS=
```

1 × 
  SET SESSION group_concat_max_len = 1000

1 × SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_attributes

1 × SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_types

Főmenü

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

46 naplózott lekérdezés 421.17 ms

18 duplikátum található!

30 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

EGYÉB táblák:

Tánctanár-kereső

A térképek észleltek!

Főmenü

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

46 naplózott lekérdezés 421.17 ms

18 duplikátum található!

30 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

EGYÉB táblák: