Flamenco
Bajnay Beáta - Aldebaran Kompánia

Bajnay Beáta - Aldebaran Kompánia kérelmezett

Az Aldebaran Kompánia különböző formákban tevékenykedik, legyen az színpadi táncos rendezvény, táncszínházi előadás vagy koncert. Magamra leginkább alkotó emberként és flamenco táncosként tekintek, de foglalkoztam kortárs- és versenytánccal is.

QR-kód

VCard

Nyitva

Kapcsolattartó személy

Bajnay Beáta

06302840906

Budapest, Pest

06302840906

Idézet

Térkép bezárása (X)

Térkép

Útvonalterv - gyerünk ide!

típus:

Tánctanár

Kategória:

Flamenco

kulcsszavak:

Általános információk

Bajnay Beáta - flamenco - Aldebaran Kompánia

2001 óta tanítok saját flamenco csoportokat. 2005 - ben elvégeztem a Magyar Táncpedagógusok Országos Szövetsége által szervezett kortárs / modern tánc csoportvezetői tanfolyamot. Egy évre rá saját együttest alapítottam tanítványaimból, Aldebaran Kompánia néven, azóta különböző formákban működünk, legyen az színpadi táncos rendezvény, táncszínházi előadás vagy koncert. Magamra leginkább flamenco táncosként tekintek, de foglalkoztam kortárs- és versenytánccal is. Az önálló, általam koreografált előadásokkal (Fabula Rasa, Tükör rezgés) felléptünk többek között a II. Zágrábi Flamenco Fesztiválon, a Bethlen Téri Színházban, Pécsi Nyári Színház, és a békéscsabai Jókai Színházban is. A Caminando flamenco zenekari felállással koncerteztünk többek között az A38 hajón is. Közben megkezdtem évenkénti tanulmányi útjaimat Spanyolországba, hogy flamenco tudásomat gyarapítsam. Folyamatosan fellépek flamenco táncosként a Caminando flamenco és Sobre Fuego flamenco formációval (2013 Antré Fesztivál szakmai- és különdíj) és készítek koreográfiákat a csoportjaim és egész estés előadásokat (Fabula Rasa, Tükör rezgés) együttesem számára. A békéscsabai Jókai Színházban bemutatott Bernarda Alba háza előadással (rendező: Béres László) két fesztivál különdíjat is elnyertünk 2015-ben, a Városmajori Színházi szemle (Nyári Fesztivál) és a Vidéki Színházak Fesztivál zsűrijének különdíját. A Bernarda koreográfiája előtt is kísérleteztem már azzal hogyan lehet beilleszteni a színház eszköztárába a flamenco táncot. Ezek közül talán a legsikeresebb koreográfia a Figaro házassága című előadásban volt, amelyet a gyergyószentmiklósi Figura Stúdió Színház mutatott be 2007-ben, Anger Zsolt rendezésében.

2016-ban végeztem a Premier Művészeti Szakiskola Táncművészet Tagozat, kortárs,-modern tánc I. szakán. 2017 óta szervezek workshopokat Virgina Delgado számára Budapesten és 2018. május 24-én egy koncertet a Flamenco Experience 6 együttes számára, ahol táncosként is közreműködtem. 2018. tavasza óta tartok kurzusokat a németországi Nürnbergben az ottani flamenco közösségnek.

A Változatlanaság hullámhossza (munkacím: Zárványok, avagy a borostyán lét) címet viselő legutóbbi táncszínházi előadásunk munkabemutatója 2018. október 12-én volt a Bethlen Téri Színházban. Az átalakított és prózai részekkel kiegészített verzió premierje 2020. szeptember 20-án volt a Várkert Bazárban.

Nyitvatartás

GMT +01:00

Hétfő

10:00 - 20:30

Kedd

10:00 - 20:30

Szerda

10:00 - 20:30

Csütörtök

10:00 - 20:30

Péntek

10:00 - 20:00

Szombat

10:00 - 12:30

Vasárnap

Zárva

A csoportos táncórák hétköznap 18.00 és 21.00 óra között vannak, a korlátozás ideje alatt 17.30-19.00 közötti időszakban. Magánórák megbeszélés szerint. Hétvége: külön megbeszélés alapján egyeztetendő.

Terembérlés:

Van

Szalagavató tánc:

Igen

Esküvői táncoktatás:

Igen

Galéria

Videó

Üzenet küldése

Bajnay Beáta - Aldebaran Kompánia

üzenet:

Vállalati kapcsolat

Keresztnév

Vezetéknév

E-mail cím

Telefon

Küldj egy példányt

A Küldés gombra kattintva vagy megérintésével elfogadom a (z) Általános szerződési feltételek elemet, valamint a hívások és szöveges üzenetek fogadását.

Vállalkozás igénylése

LNG_CLAIMED_COMPANY

Bajnay Beáta - Aldebaran Kompánia

0 Vélemény

LNG_CLAIM_COMPANY_DESCRIPTION

Vállalati kapcsolat

Keresztnév

Vezetéknév

E-mail cím

Telefon

Ezennel kijelentem, hogy jogom van a vállalkozás képviseletére

A Küldés gombra kattintva vagy megérintésével elfogadom a (z) Általános szerződési feltételek elemet, valamint a hívások és szöveges üzenetek fogadását.

Ajánlatkérés

Keresztnév

Vezetéknév

E-mail cím

Telefon

Üzenet szövege

Megerősítem, hogy elmúltam 18 éves.

A folytatással elfogadom a Általános szerződési feltételek.

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1729006049,
                "last": 1729006049,
                "now": 1729006049
            },
            "token": "7B3IA6QVgfcXywYfgNNf3aCHPXrDw8fl"
        },
        "registry": {},
        "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
        },
        "company_yelp_id": null
    }
}

Profilinformációk

Memóriahasználat

Adatbázis lekérdezések

91 naplózott lekérdezés 42.47 ms

17 duplikátum található!

13 duplikátum: #11 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91

2 duplikátum: #30 #31

2 duplikátum: #78 #79

Lekérdezés ideje: 0.27 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 4.041 MB Visszaadott sorok: 0

SELECT `data`

  FROM `tk_session`

  WHERE `session_id` = X'6361367231343634626a63316a31636a65647137306962326534'

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.05 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	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
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.21 ms Utolsó lekérdezés után: 0.71 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 4.136 MB Visszaadott sorok: 0

SELECT `session_id`

  FROM `tk_session`

  WHERE `session_id` = X'6361367231343634626a63316a31636a65647137306962326534' 
  LIMIT 1

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	Using index

Profil

Status	Duration
Starting	0.04 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
Executing	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[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.65 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 4.141 MB

INSERT INTO `tk_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6361367231343634626a63316a31636a65647137306962326534', 1, 1729006049, 0, '', 0)

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `tk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6361367231343634626a63316a31636a65647137306962326534', 1, 1729006049, 0, '', 0)

Profil

Status	Duration
Starting	0.05 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 for update	0.01 ms
Update	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.45 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[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.22 ms Utolsó lekérdezés után: 3.88 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 4.686 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.04 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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.27 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 4.698 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.08 ms
checking permissions	0.00 ms
Opening tables	0.02 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.04 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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: 0.79 ms Utolsó lekérdezés után: 37.53 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.075 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.08 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.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.37 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: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.36 ms Utolsó lekérdezés után: 0.45 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.397 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.07 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 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.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.03 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
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.04 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.404 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.02 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.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.42 ms Utolsó lekérdezés után: 0.24 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.145 MB Visszaadott sorok: 0

SELECT * 
  FROM tk_jbusinessdirectory_categories c 
  where c.type=1 
  and c.alias = 'bajnay-beata-aldebaran-kompania' 
  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.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 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.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
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.51 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.150 MB Visszaadott sorok: 1

SELECT * 
  FROM `tk_jbusinessdirectory_companies` c 
  where c.alias = 'bajnay-beata-aldebaran-kompania' 
  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.05 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.07 ms
Preparing	0.02 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
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
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.46 ms Utolsó lekérdezés után: 0.99 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 9.224 MB Visszaadott sorok: 1

Duplikált lekérdezések: #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91

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.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.06 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.02 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/helixultimate/src/Platform/Helper.php:54
10	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/helixultimate.php:215
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: 0.95 ms Utolsó lekérdezés után: 0.59 ms Memória lekérdezése: 0.005 MB memória a lekérdezés előtt: 9.248 MB

UPDATE `tk_extensions`

  SET `params` = '{\"mediaversion\":\"7aac3684d50e2a65d8475e56ae26bc9d\"}'

  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\":\"7aac3684d50e2a65d8475e56ae26bc9d\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.10 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.47 ms
closing tables	0.01 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
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: 0.68 ms Utolsó lekérdezés után: 32.97 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 12.580 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.07 ms
checking permissions	0.01 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.00 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.04 ms
closing tables	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
Removing tmp table	0.08 ms
closing tables	0.00 ms
Unlocking tables	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
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/companies/view.html.php:84
10	JBusinessDirectoryViewCompanies->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.33 ms Utolsó lekérdezés után: 0.49 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 12.674 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.07 ms
checking permissions	0.01 ms
Opening tables	0.01 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.07 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
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/companies/view.html.php:84
10	JBusinessDirectoryViewCompanies->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.99 ms Utolsó lekérdezés után: 4.97 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 13.677 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.10 ms
checking permissions	0.01 ms
closing tables	0.01 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.20 ms
closing tables	0.02 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.10 ms
closing tables	0.00 ms
Unlocking tables	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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:25
16	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
14	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:85
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.16 ms Utolsó lekérdezés után: 0.25 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 13.808 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.06 ms
Opening tables	0.00 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:110
14	JTableCompany->getCompany()	JROOT/components/com_jbusinessdirectory/models/companies.php:86
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.01 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 13.819 MB Visszaadott sorok: 1

select bc.*, GROUP_CONCAT(DISTINCT ct.name separator ', ') as typeName, GROUP_CONCAT(DISTINCT ct.company_view separator ',') as companyView, cr.country_name,
				GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',IFNULL(cg.icon,''),'|', IFNULL(cg.color,'') 
  ORDER BY cg.lft separator '#|') as categories,  
				cr.country_name,GROUP_CONCAT( DISTINCT cpt.picture_path) as pictures,
				ccm.name as mainCategory, ccm.alias as mainCategoryAlias, ccm.markerLocation as categoryMarker, ccm.id as mainCategoryId
				
  from tk_jbusinessdirectory_companies bc 
				
  left join tk_jbusinessdirectory_company_types ct 
  on find_in_set(ct.id,bc.typeId)
				
  left join tk_jbusinessdirectory_company_category cc 
  on bc.id=cc.companyId 
				
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
				
  left join tk_jbusinessdirectory_categories ccm 
  on ccm.id=bc.mainSubcategory 
  and ccm.published=1
				
  left join tk_jbusinessdirectory_countries as cr 
  on cr.id = bc.countryId 
				
  left join tk_jbusinessdirectory_company_pictures cpt 
  on cpt.companyId=bc.id 
  and cpt.picture_enable = 1
				
  where bc.id=46 
  group by bc.id 
  order by name

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bc	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ct	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	7	Using where
1	SIMPLE	cc	ref	PRIMARY,idx_category	idx_category	4	const	1	Using index
1	SIMPLE	cg	eq_ref	PRIMARY	PRIMARY	4	rvybpapt_tanck.cc.categoryId	1	Using where
1	SIMPLE	ccm	eq_ref	PRIMARY,idx_state	idx_state	5	const,const	1	Using where
1	SIMPLE	cr	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	cpt	ALL	idx_companyId,idx_picture_enable	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	55	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.14 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.08 ms
Executing	0.00 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.02 ms
Removing tmp table	0.00 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Removing tmp table	0.00 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.02 ms
Starting cleanup	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:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:128
14	JTableCompany->getCompany()	JROOT/components/com_jbusinessdirectory/models/companies.php:86
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.64 ms Utolsó lekérdezés után: 0.64 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 13.887 MB Visszaadott sorok: 48

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_packages`

Magyarázat

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.17 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.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
checking permissions	0.08 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.06 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:20
17	JTablePackage->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
15	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:706
14	JBusinessDirectoryModelCompanies->getPackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:93
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.27 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 13.963 MB Visszaadott sorok: 1

select id, package_id 
  from tk_jbusinessdirectory_companies 
  where id= 46

Magyarázat

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.03 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.03 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.02 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.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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/package.php:231
15	JTablePackage->getCurrentActivePackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:707
14	JBusinessDirectoryModelCompanies->getPackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:93
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.09 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 13.973 MB Visszaadott sorok: 3

select * , p.id as pck_id, inv.id as invoice_id,  max(p.ordering) as ordering, GROUP_CONCAT(pf.feature) as featuresS 
				
  from tk_jbusinessdirectory_packages p
				
  left join tk_jbusinessdirectory_orders inv 
  on p.id=inv.package_id 
  and inv.company_id=46 
				
  left join tk_jbusinessdirectory_package_fields pf 
  on p.id=pf.package_id
				
  where p.status=1  
  and (
							(
								(inv.state= 1 
  and (
									(
										(( now() between inv.start_date 
  and inv.end_date) or p.expiration_type=1)
										or
										(now() between inv.start_trial_date 
  and inv.end_trial_date)
									)
								))
							)
							or (
								((p.expiration_type=1 
  and p.price=0) or (p.id = 4 
  and p.price=0)))
						) 
				
  group by p.id
				
  order by p.price desc, p.ordering desc

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	index	PRIMARY,idx_status,idx_price	PRIMARY	4	NULL	4	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	inv	ref	idx_company,idx_package	idx_company	4	const	1	Using where
1	SIMPLE	pf	ref	idx_package_id	idx_package_id	5	rvybpapt_tanck.p.id	9

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting for group	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.45 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 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.01 ms
Removing tmp table	0.00 ms
Freeing items	0.04 ms
Updating status	0.00 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/administrator/components/com_jbusinessdirectory/tables/package.php:261
15	JTablePackage->getCurrentActivePackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:707
14	JBusinessDirectoryModelCompanies->getPackage()	JROOT/components/com_jbusinessdirectory/models/companies.php:93
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.46 ms Utolsó lekérdezés után: 0.28 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 14.005 MB Visszaadott sorok: 13

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_providers`

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.15 ms
After opening tables	0.00 ms
System lock	0.02 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.04 ms
closing tables	0.00 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
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
19	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:17
18	JTableCompanyServiceProviders->__construct()	JROOT/libraries/src/Table/Table.php:328
17	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
16	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1361
15	JBusinessDirectoryModelCompanies->getWorkingHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1422
14	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/companies.php:96
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.41 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.034 MB Visszaadott sorok: 7

select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, 
                  GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
                  
  from tk_jbusinessdirectory_company_provider_hours as cph
                  
  where cph.provider_id = 46 
  and cph.type = 0 
  and cph.item_type = 1
                  
  group by cph.weekday
                  
  order by cph.weekday

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cph	ref	idx_provider_id,idx_item_type,idx_type	idx_provider_id	4	const	7	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.02 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Removing tmp table	0.00 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.02 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/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62
16	JTableCompanyServiceProviders->getStaffTimetable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1362
15	JBusinessDirectoryModelCompanies->getWorkingHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1422
14	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/companies.php:96
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.29 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.054 MB Visszaadott sorok: 0

select cph.*, GROUP_CONCAT(start_hour) as startHours, GROUP_CONCAT(end_hour) as endHours, 
                  GROUP_CONCAT(id) as periodIds, GROUP_CONCAT(status) as statuses
                  
  from tk_jbusinessdirectory_company_provider_hours as cph
                  
  where cph.provider_id = 46 
  and cph.type = 1 
  and cph.item_type = 1
                  
  group by cph.weekday
                  
  order by cph.weekday

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cph	ref\|filter	idx_provider_id,idx_item_type,idx_type	idx_type\|idx_provider_id	2\|4	const	1 (10%)	Using where; Fájlrendezés használata; Using rowid filter

Profil

Status	Duration
Starting	0.05 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.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.02 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Removing tmp table	0.00 ms
End of update loop	0.00 ms
Removing tmp table	0.00 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.00 ms
Starting cleanup	0.02 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/administrator/components/com_jbusinessdirectory/tables/companyserviceproviders.php:62
16	JTableCompanyServiceProviders->getStaffTimetable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1404
15	JBusinessDirectoryModelCompanies->getBreakHours()	JROOT/components/com_jbusinessdirectory/models/companies.php:1423
14	JBusinessDirectoryModelCompanies->getWorkingDays()	JROOT/components/com_jbusinessdirectory/models/companies.php:96
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.46 ms Utolsó lekérdezés után: 1.35 ms Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 14.272 MB Visszaadott sorok: 22

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_categories`

Magyarázat

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.15 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 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.02 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.06 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:28
16	JBusinessTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
14	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:113
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.23 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.313 MB Visszaadott sorok: 1

select * 
  from tk_jbusinessdirectory_categories c
				 
  where c.id=286

Magyarázat

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

Profil

Status	Duration
Starting	0.08 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.00 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.00 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/administrator/components/com_jbusinessdirectory/tables/category.php:50
14	JBusinessTableCategory->getCategoryById()	JROOT/components/com_jbusinessdirectory/models/companies.php:117
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.26 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.331 MB Visszaadott sorok: 0

select * 
  from  tk_jbusinessdirectory_company_attachments 
  where type=1  
  and status=1  
  and object_id=46 
  ORDER BY ordering asc, name,path

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_attachments	ref\|filter	idx_type,idx_object,idx_status	idx_object\|idx_type	5\|2	const	1 (50%)	Using where; Fájlrendezés használata; Using rowid filter

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/attachments.php:38
14	JBusinessDirectoryAttachments::getAttachments()	JROOT/components/com_jbusinessdirectory/models/companies.php:167
13	JBusinessDirectoryModelCompanies->loadCompanyData()	JROOT/components/com_jbusinessdirectory/models/companies.php:69
12	JBusinessDirectoryModelCompanies->getCompany()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:95
10	JBusinessDirectoryViewCompanies->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.43 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.337 MB Visszaadott sorok: 5

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_attributes`

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.13 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.05 ms
closing tables	0.01 ms
Executing	0.02 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
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/companyattributes.php:19
15	JTableCompanyAttributes->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:497
12	JBusinessDirectoryModelCompanies->getCompanyAttributes()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:102
10	JBusinessDirectoryViewCompanies->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.72 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.356 MB Visszaadott sorok: 3

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,
				  GROUP_CONCAT(DISTINCT ca.value 
  ORDER BY ca.value) as attributeValue
				  
  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
		          
  left join tk_jbusinessdirectory_company_attributes AS ca 
  on ca.attribute_id = a.id 
  and ca.company_id=46
		          
		          
  where a.status = 1 
  and a.attribute_type=1
				  
  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	ref	idx_status,idx_attribute_type	idx_attribute_type	1	const	3	Using where; 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
1	SIMPLE	ca	ref	company_UNIQUE,idx_company_id,idx_attribute_id	company_UNIQUE	8	const,rvybpapt_tanck.a.id	1	Using index

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.03 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.06 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting for group	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.02 ms
Removing tmp table	0.05 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.01 ms
Removing tmp table	0.00 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.01 ms
Removing tmp table	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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:52
13	JTableCompanyAttributes->getCompanyAttributes()	JROOT/components/com_jbusinessdirectory/models/companies.php:506
12	JBusinessDirectoryModelCompanies->getCompanyAttributes()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:102
10	JBusinessDirectoryViewCompanies->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.40 ms Utolsó lekérdezés után: 0.24 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.442 MB Visszaadott sorok: 9

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_contact`

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.12 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
closing tables	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
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/companycontact.php:21
15	TableCompanyContact->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:563
12	JBusinessDirectoryModelCompanies->getCompanyContactsWithEmail()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:103
10	JBusinessDirectoryViewCompanies->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.23 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.465 MB Visszaadott sorok: 1

Duplikált lekérdezések: #31

select * 
  from tk_jbusinessdirectory_company_contact 
  where companyId=46 
  order by contact_department

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_contact	ref	R_13	R_13	4	const	1	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.04 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.03 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.00 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
Unlocking tables	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companycontact.php:40
13	TableCompanyContact->getAllCompanyContacts()	JROOT/components/com_jbusinessdirectory/models/companies.php:564
12	JBusinessDirectoryModelCompanies->getCompanyContactsWithEmail()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:103
10	JBusinessDirectoryViewCompanies->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.22 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.473 MB Visszaadott sorok: 1

Duplikált lekérdezések: #30

select * 
  from tk_jbusinessdirectory_company_contact 
  where companyId=46 
  order by contact_department

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_contact	ref	R_13	R_13	4	const	1	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.03 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.01 ms
Preparing	0.03 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.00 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
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/companycontact.php:40
13	TableCompanyContact->getAllCompanyContacts()	JROOT/components/com_jbusinessdirectory/models/companies.php:520
12	JBusinessDirectoryModelCompanies->getCompanyContacts()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:104
10	JBusinessDirectoryViewCompanies->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.39 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.492 MB Visszaadott sorok: 5

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_testimonials`

Magyarázat

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.12 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.02 ms
closing tables	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
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/companytestimonials.php:19
15	TableCompanyTestimonials->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:533
12	JBusinessDirectoryModelCompanies->getCompanyTestimonials()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:105
10	JBusinessDirectoryViewCompanies->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.21 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 14.515 MB Visszaadott sorok: 1

select * 
  from tk_jbusinessdirectory_company_testimonials 
  where companyId=46 
  order by testimonial_title

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_testimonials	ref	idx_companyId	idx_companyId	4	const	1	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.03 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.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.00 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
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/companytestimonials.php:30
13	TableCompanyTestimonials->getAllCompanyTestimonials()	JROOT/components/com_jbusinessdirectory/models/companies.php:534
12	JBusinessDirectoryModelCompanies->getCompanyTestimonials()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:105
10	JBusinessDirectoryViewCompanies->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.24 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.524 MB Visszaadott sorok: 1

select DISTINCT contact_department 
  from tk_jbusinessdirectory_company_contact 
  where companyId=46 
  order by contact_department

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_contact	ref	R_13	R_13	4	const	1	Using where; Using temporary; Fájlrendezés használata

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.02 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.01 ms
Creating tmp table	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/companycontact.php:47
13	TableCompanyContact->getAllCompanyContactsDepartment()	JROOT/components/com_jbusinessdirectory/models/companies.php:578
12	JBusinessDirectoryModelCompanies->getCompanyDepartments()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:106
10	JBusinessDirectoryViewCompanies->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.21 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.529 MB Visszaadott sorok: 16

SELECT *
				
  FROM tk_jbusinessdirectory_company_pictures
				
  WHERE picture_enable =1 
  and companyId =46
				
  ORDER BY id

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_pictures	index	idx_companyId,idx_picture_enable	PRIMARY	4	NULL	55	Using where

Profil

Status	Duration
Starting	0.04 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.01 ms
Sorting result	0.00 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_jbusinessdirectory/models/companies.php:455
12	JBusinessDirectoryModelCompanies->getCompanyImages()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:107
10	JBusinessDirectoryViewCompanies->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: 0.19 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.557 MB Visszaadott sorok: 4

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_videos`

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.16 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.02 ms
closing tables	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
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.03 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/companyvideos.php:19
15	JTableCompanyVideos->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:461
12	JBusinessDirectoryModelCompanies->getCompanyVideos()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:110
10	JBusinessDirectoryViewCompanies->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.19 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.573 MB Visszaadott sorok: 5

select * 
  from tk_jbusinessdirectory_company_videos 
  where companyId=46

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_videos	ALL	idx_companyId	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	14	Using where

Profil

Status	Duration
Starting	0.03 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.01 ms
Optimizing	0.01 ms
Statistics	0.02 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/companyvideos.php:38
13	JTableCompanyVideos->getCompanyVideos()	JROOT/components/com_jbusinessdirectory/models/companies.php:462
12	JBusinessDirectoryModelCompanies->getCompanyVideos()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:110
10	JBusinessDirectoryViewCompanies->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: 610.03 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.590 MB Visszaadott sorok: 3

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_sounds`

Magyarázat

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.17 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.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.03 ms
closing tables	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
Removing tmp table	0.06 ms
closing tables	0.00 ms
Unlocking tables	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
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/companysounds.php:19
15	JTableCompanySounds->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:479
12	JBusinessDirectoryModelCompanies->getCompanySounds()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:111
10	JBusinessDirectoryViewCompanies->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.27 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.604 MB Visszaadott sorok: 0

select * 
  from tk_jbusinessdirectory_company_sounds 
  where company_id= 46 
  order by id asc

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_sounds	ref	idx_company_id	idx_company_id	5	const	1	Using where

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.02 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.04 ms
Preparing	0.01 ms
Sorting result	0.00 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.00 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/companysounds.php:38
13	JTableCompanySounds->getCompanySounds()	JROOT/components/com_jbusinessdirectory/models/companies.php:480
12	JBusinessDirectoryModelCompanies->getCompanySounds()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:111
10	JBusinessDirectoryViewCompanies->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.58 ms Utolsó lekérdezés után: 0.95 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.749 MB Visszaadott sorok: 61

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_offers`

Magyarázat

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.14 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
checking permissions	0.09 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.06 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/offer.php:20
15	JTableOffer->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:587
12	JBusinessDirectoryModelCompanies->getCompanyOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:112
10	JBusinessDirectoryViewCompanies->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.84 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: 14.850 MB Visszaadott sorok: 0

select co.id, co.price , co.specialPrice, co.subject, co.short_description, co.address, co.city, co.county, co.province, co.area, co.latitude, co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url, co.quantity, co.min_purchase, co.max_purchase,
					op.picture_info,op.picture_path,op.picture_title, co.currencyId, co.price_text,co.time_zone, co.add_to_price_list, co.enable_offer_selling,
					GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color 
  ORDER BY cg.name separator '#|') as categories,
					GROUP_CONCAT(DISTINCT cg.id) as categoryIds,
					sum(os.qty) as stock_quantity
					
  from
					tk_jbusinessdirectory_company_offers co
					
  left join  tk_jbusinessdirectory_company_offer_pictures op 
  on co.id=op.offerId
					
  and
						(op.id in (
							select  min(op1.id) as min 
  from tk_jbusinessdirectory_company_offers co1
							
  left join  tk_jbusinessdirectory_company_offer_pictures op1 
  on co1.id=op1.offerId
							
  where op1.picture_enable=1
							
  group by co1.id
						)
					)
					
  left join tk_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId
					
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					
  left join tk_jbusinessdirectory_offer_stock as os 
  on os.offer_id = co.id
					
  where co.companyId=46 
  and co.state=1 
  and (co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) 
  and  (co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00'or co.publish_end_date is null) 
					
  and (co.approved = 1)  
  and co.item_type = 1 
  and ((co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) 
  and ((co.publish_start_date=DATE(now()) 
  and time(co.publish_start_time)<=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_start_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_start_time='00:00:00' or co.publish_start_time is null))
						 
  and ((co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00' or co.publish_end_date is null ) 
  and ((co.publish_end_date=DATE(now()) 
  and time(co.publish_end_time)>=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_end_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_end_time='00:00:00' or co.publish_end_time is null) )
					
  group by co.id, op.id
					
  order by co.id desc

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	co	ref	idx_company,idx_approved,idx_search,idx_publish_time	idx_company	4	const	1	Using where; Using temporary; Fájlrendezés használata
1	PRIMARY	op	ALL	idx_offer	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	PRIMARY	cc	ref	PRIMARY	PRIMARY	4	rvybpapt_tanck.co.id	1	Using index
1	PRIMARY	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	rvybpapt_tanck.cc.categoryId	1	Using where
1	PRIMARY	os	ALL	idx_offer	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
2	DEPENDENT SUBQUERY	co1	index	PRIMARY,idx_alias,idx_company,idx_country,idx_approved,idx_type,idx_featured,idx_latitude,idx_longitude,idx_price,idx_specialPrice,idx_subject,idx_city,idx_county,idx_area,idx_province,idx_address,idx_user_id,idx_expiration_email_date,idx_search,idx_publish_time,idx_offer_type,idx_packages	PRIMARY	4	NULL	1	Using index
2	DEPENDENT SUBQUERY	op1	ref	idx_offer,idx_status	idx_status	1	const	1	Using where

Profil

Status	Duration
Starting	0.17 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.04 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Removing tmp table	0.00 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.00 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.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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:219
13	JTableOffer->getCompanyOffers()	JROOT/components/com_jbusinessdirectory/models/companies.php:588
12	JBusinessDirectoryModelCompanies->getCompanyOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:112
10	JBusinessDirectoryViewCompanies->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.60 ms Utolsó lekérdezés után: 0.91 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 14.971 MB Visszaadott sorok: 56

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_events`

Magyarázat

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.14 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.09 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.02 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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/event.php:19
15	JTableEvent->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:678
12	JBusinessDirectoryModelCompanies->getCompanyEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:113
10	JBusinessDirectoryViewCompanies->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.88 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: 15.063 MB Visszaadott sorok: 0

select co.*, op.picture_path, et.name as eventType, cg.markerLocation as categoryMarker
					
  from tk_jbusinessdirectory_company_events co
					
  left join  tk_jbusinessdirectory_company_event_pictures op 
  on co.id=op.eventId
					
  and (op.id in (
							select  min(op1.id) as min 
  from tk_jbusinessdirectory_company_events co1
							
  left join  tk_jbusinessdirectory_company_event_pictures op1 
  on co1.id=op1.eventId
							
  where op1.picture_enable=1 
  and company_id=46
							
  group by co1.id))
					
  left join  tk_jbusinessdirectory_company_event_types et 
  on co.type=et.id
					
  left join tk_jbusinessdirectory_company_event_category cc 
  on co.id=cc.eventId
					
  left join tk_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					
  where co.state=1 
  and (co.end_date>=DATE(now()) or co.end_date='0000-00-00') 
  and company_id=46 
  and (co.approved = 1)
					
  group by co.id	
					
  order by co.start_date 
  LIMIT 0, 6

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	co	ref	idx_company	idx_company	5	const	1	Using where; Using temporary; Fájlrendezés használata
1	PRIMARY	op	ALL	idx_event	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
1	PRIMARY	et	eq_ref	PRIMARY	PRIMARY	4	rvybpapt_tanck.co.type	1	Using where
1	PRIMARY	cc	ref	PRIMARY	PRIMARY	4	rvybpapt_tanck.co.id	1	Using index
1	PRIMARY	cg	eq_ref	PRIMARY,idx_state	PRIMARY	4	rvybpapt_tanck.cc.categoryId	1	Using where
2	MATERIALIZED	co1	ref	PRIMARY,idx_company,idx_name,idx_alias,idx_countryId,idx_created,idx_recurring_id,idx_expiration_email_date,idx_user_id,idx_search,idx_type,idx_featured,idx_currency	idx_company	5	const	1	Using index; Using temporary
2	MATERIALIZED	op1	ALL	idx_event,idx_status	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.18 ms
Creating sort index	0.02 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Removing tmp table	0.00 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.00 ms
Freeing items	0.01 ms
Removing tmp table	0.03 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/event.php:699
13	JTableEvent->getCompanyEvents()	JROOT/components/com_jbusinessdirectory/models/companies.php:679
12	JBusinessDirectoryModelCompanies->getCompanyEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:113
10	JBusinessDirectoryViewCompanies->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.21 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 15.071 MB Visszaadott sorok: 70

SELECT id, name, event_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.04 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.00 ms
Statistics	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.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.00 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:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43
14	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5775
13	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/models/companies.php:683
12	JBusinessDirectoryModelCompanies->getCompanyEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:113
10	JBusinessDirectoryViewCompanies->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.00 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 15.093 MB Visszaadott sorok: 0

select DISTINCT cp.* 
  from tk_jbusinessdirectory_companies cp 
                    
  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 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_company_related rc 
  on rc.related_company_id=cp.id  
                    
  where rc.company_id=46   
  and (
									  (
										(inv.state= 1 
  and (
											(
												(now() > (inv.start_date) 
  and (now() < ( inv.start_date + INTERVAL p.days DAY) or p.expiration_type=1))
									 			or
												(now() > (inv.start_trial_date) 
  and now() < ( inv.start_trial_date + INTERVAL p.trial_days DAY)))
									 ))
									)
									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)   
  and cp.state = 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rc	ref	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary
1	SIMPLE	cp	eq_ref	PRIMARY,idx_state,idx_approved,idx_package,idx_publish_start_date,idx_publish_end_date	PRIMARY	4	rvybpapt_tanck.rc.related_company_id	1	Using where
1	SIMPLE	inv	ref	idx_company	idx_company	4	rvybpapt_tanck.rc.related_company_id	1
1	SIMPLE	p	ALL	PRIMARY,idx_status,idx_price	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.15 ms
Preparing	0.04 ms
Creating tmp table	0.07 ms
Executing	0.00 ms
Sending data	0.35 ms
Removing tmp table	0.03 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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1840
13	JTableCompany->getRelatedCompanies()	JROOT/components/com_jbusinessdirectory/models/companies.php:1249
12	JBusinessDirectoryModelCompanies->getRelatedCompanies()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:114
10	JBusinessDirectoryViewCompanies->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.49 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 15.105 MB Visszaadott sorok: 7

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_services_list`

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.13 ms
After opening tables	0.02 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
closing tables	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
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 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/companyserviceslist.php:19
15	JTableCompanyServicesList->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:281
12	JBusinessDirectoryModelCompanies->getServicesList()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:115
10	JBusinessDirectoryViewCompanies->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.25 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 15.125 MB Visszaadott sorok: 0

select * 
  from tk_jbusinessdirectory_company_services_list 
  where companyId=46 
  order by service_section, id

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tk_jbusinessdirectory_company_services_list	ref	idx_companyId	idx_companyId	4	const	1	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.05 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.03 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	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.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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/companyserviceslist.php:30
13	JTableCompanyServicesList->getPriceList()	JROOT/components/com_jbusinessdirectory/models/companies.php:282
12	JBusinessDirectoryModelCompanies->getServicesList()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:115
10	JBusinessDirectoryViewCompanies->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: 0.30 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 15.152 MB Visszaadott sorok: 2

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_company_event_associated_items`

Magyarázat

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.17 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.02 ms
closing tables	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
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.00 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/eventassociatedcompanies.php:19
15	JTableEventAssociatedCompanies->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1277
12	JBusinessDirectoryModelCompanies->getAssociatedEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:116
10	JBusinessDirectoryViewCompanies->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.92 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 15.167 MB Visszaadott sorok: 0

select DISTINCT ce.* 
                    
  from tk_jbusinessdirectory_company_events ce
                    
  left join tk_jbusinessdirectory_companies cp 
  on cp.id = ce.company_id
                    
  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 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)
                    
  WHERE ce.id IN (
                    select eac.event_id
                    
  from tk_jbusinessdirectory_company_events co
                    
  left join tk_jbusinessdirectory_company_event_associated_items eac  
                    
  on eac.event_id=co.id  
  where eac.company_id=46
                    ) 
  and ce.state = 1 
  and (ce.approved = 1)  
  and (
									(
										(inv.state= 1 
  and (
											(
												(( now() between inv.start_date 
  and inv.end_date) or p.expiration_type=1)
												or
												(now() between inv.start_trial_date 
  and inv.end_trial_date)
											)
										))
									)
									or (
										((p.expiration_type=1 
  and p.price=0) or (p.id = cp.package_id 
  and p.price=0)))
								)  
  and ce.end_date>= DATE(NOW()) 
  LIMIT 0, 6

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	ce	ALL	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using temporary
1	PRIMARY	cp	eq_ref	PRIMARY	PRIMARY	4	rvybpapt_tanck.ce.company_id	1	Using where
1	PRIMARY	inv	ref	idx_company	idx_company	4	rvybpapt_tanck.cp.id	1	Using where
1	PRIMARY	co	eq_ref	PRIMARY	PRIMARY	4	rvybpapt_tanck.ce.id	1	Using index
1	PRIMARY	eac	eq_ref	PRIMARY	PRIMARY	8	rvybpapt_tanck.ce.id,const	1	Using index
1	PRIMARY	p	ALL	PRIMARY,idx_status,idx_price	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.05 ms
Creating tmp table	0.05 ms
Executing	0.00 ms
Sending data	0.35 ms
Removing tmp table	0.04 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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/eventassociatedcompanies.php:235
13	JTableEventAssociatedCompanies->getAssociatedEventsDetails()	JROOT/components/com_jbusinessdirectory/models/companies.php:1279
12	JBusinessDirectoryModelCompanies->getAssociatedEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:116
10	JBusinessDirectoryViewCompanies->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.22 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 15.175 MB Visszaadott sorok: 70

SELECT id, name, offer_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.04 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.00 ms
Statistics	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.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/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43
14	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5775
13	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/models/companies.php:1280
12	JBusinessDirectoryModelCompanies->getAssociatedEvents()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:116
10	JBusinessDirectoryViewCompanies->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: 0.31 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 15.215 MB Visszaadott sorok: 9

SHOW FULL COLUMNS 
  FROM `tk_jbusinessdirectory_memberships`

Magyarázat

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.15 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.02 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
closing tables	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
Removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.00 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/memberships.php:21
15	TableMemberships->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/companies.php:341
13	JBusinessDirectoryModelCompanies->getTable()	JROOT/components/com_jbusinessdirectory/models/companies.php:1259
12	JBusinessDirectoryModelCompanies->getCompanyMemberships()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/companies/view.html.php:117
10	JBusinessDirectoryViewCompanies->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.34 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 15.238 MB Visszaadott sorok: 0

Bajnay Beáta - Aldebaran Kompánia kérelmezett

Térkép

Galéria

Videó

Főmenü

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

91 naplózott lekérdezés 42.47 ms

17 duplikátum található!

Bajnay Beáta - Aldebaran Kompánia kérelmezett

Bajnay Beáta - Aldebaran Kompánia

Térkép

A térképek észleltek!

Galéria

Videó

Főmenü

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

91 naplózott lekérdezés 42.47 ms

17 duplikátum található!