Dárkový poukaz 1000 Kč

Konzole ladění chyb Joomla!

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1787348087,
                "last": 1787348087,
                "now": 1787348087
            },
            "token": "llGk0oPtlDosTroNiQC4IpwQy9gTgKBE"
        },
        "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
        }
    },
    "__phocaCart": {
        "currency": 1
    }
}

Informace o profilu

Čas

Paměť

Čas: 22.15 ms / 22.15 ms Paměť: 1.997 MB / 2.34 MB Application: afterLoad

Čas: 122.98 ms / 145.13 ms Paměť: 10.562 MB / 12.91 MB Application: afterInitialise

Čas: 41.47 ms / 186.60 ms Paměť: 1.328 MB / 14.23 MB Application: afterRoute

Čas: 15.49 ms / 202.09 ms Paměť: 0.530 MB / 14.76 MB Application: beforeRenderComponent com_phocacart

Čas: 99.77 ms / 301.85 ms Paměť: 4.801 MB / 19.56 MB Application: afterRenderComponent com_phocacart

Čas: 4.11 ms / 305.96 ms Paměť: 0.134 MB / 19.70 MB Application: afterDispatch

Čas: 18.65 ms / 324.61 ms Paměť: 0.902 MB / 20.60 MB Application: beforeRenderModule mod_search (Search)

Čas: 1.52 ms / 326.14 ms Paměť: 0.039 MB / 20.64 MB Application: afterRenderModule mod_search (Search)

Čas: 0.02 ms / 326.16 ms Paměť: -0.005 MB / 20.63 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Čas: 11.15 ms / 337.31 ms Paměť: 0.228 MB / 20.86 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Čas: 0.05 ms / 337.36 ms Paměť: -0.005 MB / 20.86 MB Application: beforeRenderModule mod_custom (Odkazy)

Čas: 0.88 ms / 338.25 ms Paměť: 0.006 MB / 20.86 MB Application: afterRenderModule mod_custom (Odkazy)

Čas: 0.02 ms / 338.27 ms Paměť: -0.002 MB / 20.86 MB Application: beforeRenderModule mod_whosonline (Kdo je online)

Čas: 2.44 ms / 340.70 ms Paměť: 0.033 MB / 20.89 MB Application: afterRenderModule mod_whosonline (Kdo je online)

Čas: 0.05 ms / 340.75 ms Paměť: -0.002 MB / 20.89 MB Application: beforeRenderModule mod_phocacart_cart (OBJEDNÁNÍ POUKAZŮ)

Čas: 6.44 ms / 347.19 ms Paměť: 0.468 MB / 21.36 MB Application: afterRenderModule mod_phocacart_cart (OBJEDNÁNÍ POUKAZŮ)

Čas: 0.03 ms / 347.22 ms Paměť: -0.008 MB / 21.35 MB Application: beforeRenderModule mod_menu (SLUŽBY A CENY)

Čas: 5.19 ms / 352.40 ms Paměť: 0.077 MB / 21.43 MB Application: afterRenderModule mod_menu (SLUŽBY A CENY)

Čas: 0.08 ms / 352.49 ms Paměť: -0.004 MB / 21.42 MB Application: beforeRenderModule mod_search (Top Search)

Čas: 1.01 ms / 353.49 ms Paměť: 0.009 MB / 21.43 MB Application: afterRenderModule mod_search (Top Search)

Čas: 6.27 ms / 359.76 ms Paměť: 0.426 MB / 21.86 MB Application: afterRender

Celkem dotazů do databáze: 86.09 ms

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

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Stejné jako volání na řádku níže.
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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	Volající	Soubor a číslo řádku
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

VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `n53zh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6236613537646138333531633363363934623466623935646431386230346637', 1, 1787348087, 0, '', 0)

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.05 ms
update	0.21 ms
Waiting for query cache lock	0.02 ms
update	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
Waiting for query cache lock	0.02 ms
Unlocking tables	0.08 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.65 ms Po posledním dotazu: 2.75 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 4.384 MB Vráceno řádků: 39

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

  FROM `n53zh_extensions`

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_extensions	ref	extension	extension	82	const	38	Using index condition; Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.08 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.06 ms
statistics	0.17 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.62 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.06 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Stejné jako volání na řádku níže.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.76 ms Po posledním dotazu: 2.59 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.673 MB Vráceno řádků: 5

SELECT id, rules

  FROM `n53zh_viewlevels`

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_viewlevels	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	5

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.93 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.685 MB Vráceno řádků: 2

SELECT b.id

  FROM n53zh_usergroups AS a

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

  WHERE a.id = 9

Vysvětlení

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	3	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Unlocking tables	0.04 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.23 ms Po posledním dotazu: 0.52 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 4.756 MB Vráceno řádků: 98

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

  FROM n53zh_extensions

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

  ORDER BY ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_extensions	ref	extension	extension	82	const	125	Using index condition; Using where; Použití filesort

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.17 ms
preparing	0.06 ms
executing	0.02 ms
Sorting result	1.46 ms
Sending data	0.87 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.05 ms
updating status	0.04 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Stejné jako volání na řádku níže.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.35 ms Po posledním dotazu: 17.43 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 6.737 MB Vráceno řádků: 1

Duplicitní dotazy: #9

SELECT `template`

  FROM `n53zh_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	8	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.08 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.06 ms
statistics	0.17 ms
preparing	0.08 ms
executing	0.03 ms
Sending data	0.22 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.07 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:1273
12	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:206
11	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:1407
10	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/components/com_sppagebuilder/builder/classes/addon.php:28
9	require_once JROOT/components/com_sppagebuilder/builder/classes/addon.php	JROOT/components/com_sppagebuilder/helpers/autoload.php:42
8	BuilderAutoload::loadClasses()	JROOT/plugins/system/sppagebuilder/sppagebuilder.php:29
7	require_once JROOT/plugins/system/sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.73 ms Po posledním dotazu: 56.52 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 12.301 MB Vráceno řádků: 1

Duplicitní dotazy: #8

SELECT `template`

  FROM `n53zh_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	8	Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.06 ms
statistics	0.14 ms
preparing	0.06 ms
executing	0.03 ms
Sending data	0.19 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.06 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 17.59 ms Po posledním dotazu: 7.63 ms Dotaz paměti: 0.107 MB Paměť před dotazem: 13.121 MB Vráceno řádků: 56

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM n53zh_menu AS m

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

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

  ORDER BY m.lft

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	2	Using index condition; Using where; Použití filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d67524_auto.m.component_id	1	Using where

Profil

Status	Duration
starting	0.90 ms
checking permissions	0.03 ms
checking permissions	0.10 ms
Opening tables	0.21 ms
After opening tables	0.03 ms
System lock	0.05 ms
Table lock	0.05 ms
init	0.13 ms
optimizing	0.12 ms
statistics	0.40 ms
preparing	0.20 ms
executing	0.06 ms
Sorting result	4.51 ms
Sending data	2.99 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.08 ms
freeing items	0.05 ms
updating status	0.05 ms
cleaning up	0.07 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Stejné jako volání na řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.10 ms Po posledním dotazu: 13.32 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 14.188 MB Vráceno řádků: 0

SELECT a.title, a.alias, a.id, a.parent_id 
  FROM n53zh_phocacart_categories AS a 
  WHERE a.id = 2 
  ORDER BY a.ordering 
  LIMIT 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.04 ms
Opening tables	0.11 ms
After opening tables	0.04 ms
System lock	0.43 ms
Table lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.04 ms
end	0.02 ms
query end	0.06 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
freeing items	0.04 ms
updating status	0.06 ms
cleaning up	0.05 ms

Stack volání

#	Volající	Soubor a číslo řádku
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_phocacart/libraries/phocacart/category/category.php:152
10	PhocacartCategory::getCategoryById()	JROOT/components/com_phocacart/router.php:599
9	PhocacartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.50 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 14.196 MB Vráceno řádků: 1

SELECT `alias`,`catid`

  FROM `n53zh_phocacart_products`

  WHERE `id` = 2

Vysvětlení

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.12 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.04 ms
Unlocking tables	0.05 ms
executing	0.04 ms
Sending data	0.04 ms
end	0.08 ms
query end	0.05 ms
closing tables	0.06 ms
Unlocking tables	0.06 ms
freeing items	0.05 ms
updating status	0.06 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/components/com_phocacart/router.php:615
9	PhocacartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.49 ms Po posledním dotazu: 1.41 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 14.271 MB Vráceno řádků: 1

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

  FROM `n53zh_extensions`

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.04 ms
Opening tables	0.11 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.32 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.12 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.05 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Stejné jako volání na řádku níže.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 6.89 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 14.262 MB

UPDATE `n53zh_extensions`

  SET `params` = '{\"mediaversion\":\"9252f9c745dd96c335d3fef32f45aa7d\"}'

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

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: UPDATE `n53zh_extensions` SET `params` = '{\"mediaversion\":\"9252f9c745dd96c335d3fef32f45aa7d\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.45 ms
updating	0.15 ms
end	0.03 ms
Waiting for query cache lock	5.54 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
Waiting for query cache lock	0.02 ms
Unlocking tables	0.05 ms
freeing items	0.03 ms
updating status	0.08 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.86 ms Po posledním dotazu: 1.99 ms Dotaz paměti: 0.019 MB Paměť před dotazem: 14.562 MB Vráceno řádků: 1

SELECT *

  FROM n53zh_languages

  WHERE published=1

  ORDER BY ordering ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_languages	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	2	Using where; Použití filesort

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sorting result	0.08 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.52 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.019 MB Paměť před dotazem: 14.573 MB Vráceno řádků: 9

SELECT id, home, template, s.params

  FROM n53zh_template_styles as s

  LEFT JOIN n53zh_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	4	Using index condition; Using where
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	d67524_auto.e.element	2	Using index condition; Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.19 ms
preparing	0.08 ms
executing	0.02 ms
Sending data	0.28 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.06 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.57 ms Po posledním dotazu: 13.99 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 16.268 MB Vráceno řádků: 1

SELECT c.id, c.title, c.alias, c.description, c.parent_id 
  FROM n53zh_phocacart_categories AS c 
  LEFT JOIN n53zh_phocacart_product_categories AS pc 
  ON pc.category_id = c.id 
  LEFT JOIN n53zh_phocacart_products AS a 
  ON a.id = pc.product_id 
  LEFT JOIN n53zh_phocacart_item_groups AS ga 
  ON a.id = ga.item_id 
  AND ga.type = 3 
  LEFT JOIN n53zh_phocacart_item_groups AS gc 
  ON c.id = gc.item_id 
  AND gc.type = 2 
  WHERE  c.published = 1 
  AND  c.type IN (0,1) 
  AND  c.id= 1 
  AND  c.access IN (1,1,5) 
  AND  a.access IN (1,1,5) 
  AND  (ga.group_id IN (1) OR ga.group_id IS NULL) 
  AND  (gc.group_id IN (1) OR gc.group_id IS NULL) 
  ORDER BY c.ordering 
  LIMIT 0, 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,cat_idx,idx_access,idx_published	PRIMARY	4	const	1
1	SIMPLE	pc	index	idx_category	ordering	4	NULL	5	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,idx_access	PRIMARY	4	d67524_auto.pc.product_id	1	Using where
1	SIMPLE	ga	ref	idx_itemgroup	idx_itemgroup	4	d67524_auto.pc.product_id	1	Using where
1	SIMPLE	gc	ALL	idx_itemgroup	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	11	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.09 ms
optimizing	0.06 ms
statistics	0.20 ms
preparing	0.02 ms
Unlocking tables	0.10 ms
executing	0.02 ms
Sending data	0.20 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.06 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocacart/models/item.php:278
11	PhocaCartModelItem->getCategory()	JROOT/components/com_phocacart/views/item/view.html.php:42
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.79 ms Po posledním dotazu: 0.64 ms Dotaz paměti: 0.041 MB Paměť před dotazem: 16.332 MB Vráceno řádků: 1

SELECT i.id,i.title,i.alias,i.description,i.features,i.metatitle,i.metadesc,i.metakey,i.metadata,i.type,i.image,i.weight,i.height,i.width,i.length,i.min_multiple_quantity,i.min_quantity_calculation,i.volume,i.description_long,i.price,i.price_original,i.stockstatus_a_id,i.stockstatus_n_id,i.stock_calculation,i.min_quantity,i.stock,i.sales,i.featured,i.external_id,i.unit_amount,i.unit_unit,i.video,i.external_link,i.external_text,i.external_link2,i.external_text2,i.public_download_file,i.public_download_text,i.public_play_file,i.public_play_text,i.sku,i.upc,i.ean,i.jan,i.isbn,i.mpn,i.serial_number,i.points_needed,i.points_received,i.date,i.date_update,i.delivery_date,i.gift_types, pc.ordering, c.id AS catid, c.title AS cattitle, c.alias AS catalias, m.id as manufacturerid, m.title as manufacturertitle, m.link as manufacturerlink, t.id as taxid, t.tax_rate as taxrate, t.calculation_type as taxcalculationtype, t.title as taxtitle, MIN(ppg.price) as group_price, MAX(pptg.points_received) as group_points_received 
  FROM n53zh_phocacart_products AS i 
  LEFT JOIN n53zh_phocacart_product_categories AS pc 
  ON pc.product_id = i.id 
  LEFT JOIN n53zh_phocacart_categories AS c 
  ON c.id = pc.category_id 
  LEFT JOIN n53zh_phocacart_manufacturers AS m 
  ON m.id = i.manufacturer_id 
  LEFT JOIN n53zh_phocacart_taxes AS t 
  ON t.id = i.tax_id 
  LEFT JOIN n53zh_phocacart_item_groups AS ga 
  ON i.id = ga.item_id 
  AND ga.type = 3 
  LEFT JOIN n53zh_phocacart_item_groups AS gc 
  ON c.id = gc.item_id 
  AND gc.type = 2 
  LEFT JOIN n53zh_phocacart_product_price_groups AS ppg 
  ON i.id = ppg.product_id 
  AND ppg.group_id IN (SELECT group_id 
  FROM n53zh_phocacart_item_groups 
  WHERE item_id = i.id 
  AND group_id IN (1) 
  AND type = 3) 
  LEFT JOIN n53zh_phocacart_product_point_groups AS pptg 
  ON i.id = pptg.product_id 
  AND pptg.group_id IN (SELECT group_id 
  FROM n53zh_phocacart_item_groups 
  WHERE item_id = i.id 
  AND group_id IN (1) 
  AND type = 3) 
  WHERE  pc.category_id= 1 
  AND  pc.category_id= c.id 
  AND  i.published = 1 
  AND  c.published = 1 
  AND  i.id = 2 
  AND  c.type IN (0,1) 
  AND  c.access IN (1,1,5) 
  AND  i.access IN (1,1,5) 
  AND  (ga.group_id IN (1) OR ga.group_id IS NULL) 
  AND  (gc.group_id IN (1) OR gc.group_id IS NULL) 
  GROUP BY i.id 
  ORDER BY pc.ordering 
  LIMIT 0, 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	i	const	PRIMARY,product_idx,idx_access	PRIMARY	4	const	1
1	PRIMARY	pc	const	idx_category	idx_category	8	const,const	1
1	PRIMARY	c	const	PRIMARY,cat_idx,idx_access,idx_published	PRIMARY	4	const	1
1	PRIMARY	m	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	PRIMARY	t	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	ga	ref	idx_itemgroup	idx_itemgroup	4	const	3	Using where
1	PRIMARY	gc	ALL	idx_itemgroup	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	11	Using where; Using join buffer (flat, BNL join)
1	PRIMARY	ppg	ref	idx_product	idx_product	4	const	1	Using where
1	PRIMARY	pptg	ref	idx_product	idx_product	4	const	1	Using where
3	DEPENDENT SUBQUERY	n53zh_phocacart_item_groups	ref	idx_itemgroup	idx_itemgroup	8	const,const	3	Using index condition; Using where
2	DEPENDENT SUBQUERY	n53zh_phocacart_item_groups	ref	idx_itemgroup	idx_itemgroup	8	const,const	3	Using index condition; Using where

Profil

Status	Duration
starting	0.45 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.22 ms
After opening tables	0.05 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.30 ms
optimizing	0.14 ms
statistics	0.47 ms
preparing	0.04 ms
Unlocking tables	0.11 ms
optimizing	0.05 ms
statistics	0.10 ms
preparing	0.07 ms
optimizing	0.05 ms
statistics	0.12 ms
preparing	0.15 ms
executing	0.15 ms
Sending data	0.30 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.05 ms
freeing items	0.06 ms
updating status	0.07 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocacart/models/item.php:33
11	PhocaCartModelItem->getItem()	JROOT/components/com_phocacart/views/item/view.html.php:44
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.18 ms Po posledním dotazu: 1.23 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 16.414 MB Vráceno řádků: 0

SELECT i.image 
  FROM n53zh_phocacart_product_images AS i 
  LEFT JOIN n53zh_phocacart_products AS p 
  ON p.id = i.product_id 
  WHERE p.id = 2 
  ORDER BY i.image

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index; Použití filesort
1	SIMPLE	i	ref	idx_product	idx_product	4	const	1	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.04 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.03 ms
Unlocking tables	0.05 ms
executing	0.03 ms
Sorting result	0.08 ms
Sending data	0.05 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.08 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocacart/libraries/phocacart/image/image.php:111
11	PhocacartImage::getAdditionalImages()	JROOT/components/com_phocacart/views/item/view.html.php:120
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.72 ms Po posledním dotazu: 1.25 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 16.495 MB Vráceno řádků: 0

SELECT DISTINCT a.id as id, a.title as title, a.image as image, a.alias as alias, a.description, a.description_long, SUBSTRING_INDEX(GROUP_CONCAT(c.id 
  ORDER BY c.parent_id), ',', 1) as catid, SUBSTRING_INDEX(GROUP_CONCAT(c.title 
  ORDER BY c.parent_id), ',', 1) as cattitle, SUBSTRING_INDEX(GROUP_CONCAT(c.alias 
  ORDER BY c.parent_id), ',', 1) as catalias,  GROUP_CONCAT(c2.id) AS catid2, GROUP_CONCAT(c2.alias) AS catalias2, GROUP_CONCAT(c2.title) AS cattitle2 
  FROM n53zh_phocacart_products AS a 
  LEFT JOIN n53zh_phocacart_product_related AS t 
  ON a.id = t.product_b 
  LEFT JOIN n53zh_phocacart_product_categories AS pc 
  ON pc.product_id = a.id 
  LEFT JOIN n53zh_phocacart_categories AS c 
  ON c.id = pc.category_id 
  LEFT JOIN n53zh_phocacart_categories AS c2 
  ON c2.id = pc.category_id 
  and pc.category_id = 1 
  LEFT JOIN n53zh_phocacart_item_groups AS ga 
  ON a.id = ga.item_id 
  AND ga.type = 3 
  LEFT JOIN n53zh_phocacart_item_groups AS gc 
  ON c.id = gc.item_id 
  AND gc.type = 2 
  WHERE t.product_a = 2 
  AND  c.type IN (0,1) 
  AND  c.access IN (1,1,5) 
  AND  a.access IN (1,1,5) 
  AND  (ga.group_id IN (1) OR ga.group_id IS NULL) 
  AND  (gc.group_id IN (1) OR gc.group_id IS NULL) 
  AND  c.published = 1 
  AND  a.published = 1 
  GROUP BY a.id, a.title, a.alias, a.image, a.description, a.description_long

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	product_a,product_b	product_a	4	const	1	Using temporary; Použití filesort
1	SIMPLE	a	eq_ref	PRIMARY,product_idx,idx_access	PRIMARY	4	d67524_auto.t.product_b	1	Using where
1	SIMPLE	pc	ref	idx_category	idx_category	4	d67524_auto.t.product_b	1	Using index
1	SIMPLE	c	eq_ref	PRIMARY,cat_idx,idx_access,idx_published	PRIMARY	4	d67524_auto.pc.category_id	1	Using where
1	SIMPLE	c2	const	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	ga	ref	idx_itemgroup	idx_itemgroup	4	d67524_auto.t.product_b	1	Using where
1	SIMPLE	gc	ref	idx_itemgroup	idx_itemgroup	4	d67524_auto.pc.category_id	1	Using where

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.03 ms
System lock	0.04 ms
Table lock	0.03 ms
init	0.11 ms
optimizing	0.07 ms
statistics	0.25 ms
preparing	0.13 ms
executing	0.03 ms
Creating tmp table	0.51 ms
Copying to tmp table	0.11 ms
Sorting result	0.11 ms
Sending data	0.06 ms
end	0.03 ms
removing tmp table	0.11 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
removing tmp table	0.02 ms
freeing items	0.02 ms
removing tmp table	0.02 ms
freeing items	0.05 ms
removing tmp table	0.02 ms
freeing items	0.02 ms
removing tmp table	0.02 ms
freeing items	0.02 ms
removing tmp table	0.02 ms
freeing items	0.02 ms
removing tmp table	0.02 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocacart/libraries/phocacart/related/related.php:162
11	PhocacartRelated::getRelatedItemsById()	JROOT/components/com_phocacart/views/item/view.html.php:121
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.96 ms Po posledním dotazu: 0.79 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 16.552 MB Vráceno řádků: 0

SELECT a.id, a.title, a.alias, a.type, a.display_format, a.link_ext, a.link_cat, a.icon_class 
  FROM n53zh_phocacart_tags AS a 
  LEFT JOIN n53zh_phocacart_tags_related AS r 
  ON a.id = r.tag_id 
  WHERE a.type = 0 
  AND r.item_id = 2 
  ORDER BY a.id

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	PRIMARY	PRIMARY	4	NULL	1	Using where
1	SIMPLE	r	eq_ref	i_file_id	i_file_id	8	const,d67524_auto.a.id	1	Using index

Profil

Status	Duration
starting	1.18 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.02 ms
Sorting result	0.02 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocacart/libraries/phocacart/tag/tag.php:43
12	PhocacartTag::getTags()	JROOT/administrator/components/com_phocacart/libraries/phocacart/tag/tag.php:359
11	PhocacartTag::getTagsRendered()	JROOT/components/com_phocacart/views/item/view.html.php:122
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.93 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 16.558 MB Vráceno řádků: 0

SELECT a.id, a.title, a.alias, a.type, a.display_format, a.link_ext, a.link_cat, a.icon_class 
  FROM n53zh_phocacart_tags AS a 
  LEFT JOIN n53zh_phocacart_taglabels_related AS r 
  ON a.id = r.tag_id 
  WHERE a.type = 1 
  AND r.item_id = 2 
  ORDER BY a.id

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	PRIMARY	PRIMARY	4	NULL	1	Using where
1	SIMPLE	r	eq_ref	i_file_id	i_file_id	8	const,d67524_auto.a.id	1	Using index

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.02 ms
Sorting result	0.02 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocacart/libraries/phocacart/tag/tag.php:121
12	PhocacartTag::getTagLabels()	JROOT/administrator/components/com_phocacart/libraries/phocacart/tag/tag.php:362
11	PhocacartTag::getTagsRendered()	JROOT/components/com_phocacart/views/item/view.html.php:123
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.89 ms Po posledním dotazu: 1.59 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 16.750 MB Vráceno řádků: 0

SELECT a.id, a.title, a.alias, a.required, a.type 
  FROM n53zh_phocacart_attributes AS a 
  WHERE a.product_id = 2 
  ORDER BY a.ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_product	idx_product	4	const	1	Using where; Použití filesort

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.02 ms
Sorting result	0.07 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocacart/libraries/phocacart/attribute/attribute.php:27
12	PhocacartAttribute::getAttributesById()	JROOT/administrator/components/com_phocacart/libraries/phocacart/attribute/attribute.php:824
11	PhocacartAttribute::getAttributesAndOptions()	JROOT/components/com_phocacart/views/item/view.html.php:129
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.47 ms Po posledním dotazu: 0.64 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 16.806 MB Vráceno řádků: 0

SELECT s.id, s.title, s.alias, s.value, s.alias_value, s.image, s.image_medium, s.image_small, s.color, g.id as groupid, g.title as grouptitle 
  FROM n53zh_phocacart_specifications AS s 
  LEFT JOIN n53zh_phocacart_specification_groups AS g 
  ON g.id = s.group_id 
  WHERE s.product_id = 2 
  ORDER by g.ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_product	idx_product	4	const	1	Using temporary; Použití filesort
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d67524_auto.s.group_id	1

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.02 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.02 ms
Creating tmp table	0.29 ms
Copying to tmp table	0.06 ms
Sorting result	0.05 ms
Sending data	0.05 ms
end	0.02 ms
removing tmp table	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocacart/libraries/phocacart/specification/specification.php:269
11	PhocacartSpecification::getSpecificationGroupsAndSpecifications()	JROOT/components/com_phocacart/views/item/view.html.php:131
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.95 ms Po posledním dotazu: 0.46 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 16.821 MB Vráceno řádků: 0

SELECT a.id, a.product_id, a.user_id, a.name, a.rating, a.review, a.date, a.published 
  FROM n53zh_phocacart_reviews AS a 
  WHERE a.product_id = 2 
  AND a.published = 1 
  GROUP BY a.id

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	NULL	PRIMARY	4	NULL	1	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.02 ms
Sorting result	0.02 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocacart/libraries/phocacart/review/review.php:32
11	PhocacartReview::getReviewsByProduct()	JROOT/components/com_phocacart/views/item/view.html.php:132
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.88 ms Po posledním dotazu: 2.60 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 17.057 MB Vráceno řádků: 1

SELECT alias

  FROM n53zh_phocacart_products

  WHERE id=2

Vysvětlení

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
Unlocking tables	0.03 ms
executing	0.04 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_phocacart/router.php:147
17	PhocacartRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_phocacart/views/item/view.html.php:144
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.82 ms Po posledním dotazu: 0.04 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 17.067 MB Vráceno řádků: 1

SELECT a.title, a.alias, a.id, a.parent_id 
  FROM n53zh_phocacart_categories AS a 
  WHERE a.id = 1 
  ORDER BY a.ordering 
  LIMIT 1

Vysvětlení

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.04 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.05 ms
updating status	0.04 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_phocacart/libraries/phocacart/category/category.php:152
18	PhocacartCategory::getCategoryById()	JROOT/components/com_phocacart/router.php:181
17	PhocacartRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_phocacart/views/item/view.html.php:144
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.98 ms Po posledním dotazu: 8.19 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 17.560 MB Vráceno řádků: 16

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

  FROM n53zh_modules AS m

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

  LEFT JOIN n53zh_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-21 21:34:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-21 21:34:47') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 486 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	6	Using index condition; Using where; Použití filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	d67524_auto.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_folder_clientid	402	d67524_auto.m.module	11	Using index condition; Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.10 ms
statistics	0.17 ms
preparing	0.09 ms
executing	0.02 ms
Sorting result	0.46 ms
Sending data	1.36 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.07 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Stejné jako volání na řádku níže.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
13	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/administrator/components/com_phocacart/libraries/phocacart/render/media.php:164
12	PhocacartRenderMedia->__construct()	JROOT/administrator/components/com_phocacart/libraries/phocacart/render/media.php:223
11	PhocacartRenderMedia::getInstance()	JROOT/components/com_phocacart/views/item/view.html.php:160
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.91 ms Po posledním dotazu: 0.66 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 17.601 MB Vráceno řádků: 1

SELECT a.id 
  FROM n53zh_phocacart_currencies AS a 
  WHERE a.exchange_rate = 1 
  ORDER BY a.id

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	NULL	PRIMARY	4	NULL	1	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.05 ms
System lock	0.03 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.05 ms
executing	0.02 ms
Sorting result	0.03 ms
Sending data	0.11 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.05 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_phocacart/libraries/phocacart/currency/currency.php:132
14	PhocacartCurrency::getDefaultCurrency()	JROOT/administrator/components/com_phocacart/libraries/phocacart/currency/currency.php:66
13	PhocacartCurrency::getCurrency()	JROOT/administrator/components/com_phocacart/libraries/phocacart/render/media.php:178
12	PhocacartRenderMedia->__construct()	JROOT/administrator/components/com_phocacart/libraries/phocacart/render/media.php:223
11	PhocacartRenderMedia::getInstance()	JROOT/components/com_phocacart/views/item/view.html.php:160
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.79 ms Po posledním dotazu: 0.04 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 17.609 MB Vráceno řádků: 1

SELECT a.* 
  FROM n53zh_phocacart_currencies AS a 
  WHERE a.id = 1 
  ORDER BY a.id

Vysvětlení

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_phocacart/libraries/phocacart/currency/currency.php:84
13	PhocacartCurrency::getCurrency()	JROOT/administrator/components/com_phocacart/libraries/phocacart/render/media.php:178
12	PhocacartRenderMedia->__construct()	JROOT/administrator/components/com_phocacart/libraries/phocacart/render/media.php:223
11	PhocacartRenderMedia::getInstance()	JROOT/components/com_phocacart/views/item/view.html.php:160
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 5.96 ms Po posledním dotazu: 9.82 ms Dotaz paměti: 0.041 MB Paměť před dotazem: 17.933 MB Vráceno řádků: 90

SHOW FULL COLUMNS 
  FROM `n53zh_phocacart_products`

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `n53zh_phocacart_products`

Profil

Status	Duration
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.76 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.40 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
closing tables	0.03 ms
executing	0.02 ms
Sending data	0.21 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
removing tmp table	0.12 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
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_phocacart/tables/phocacartitem.php:19
13	TablePhocaCartItem->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_phocacart/models/item.php:334
11	PhocaCartModelItem->hit()	JROOT/components/com_phocacart/views/item/view.html.php:221
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.07 ms Po posledním dotazu: 1.13 ms Dotaz paměti: 0.042 MB Paměť před dotazem: 18.062 MB Vráceno řádků: 1

SELECT *

  FROM n53zh_phocacart_products

  WHERE `id` = '2'

Vysvětlení

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.05 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.10 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	0.02 ms
Sending data	0.13 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.05 ms
freeing items	0.03 ms
updating status	0.06 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_phocacart/models/item.php:335
11	PhocaCartModelItem->hit()	JROOT/components/com_phocacart/views/item/view.html.php:221
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.01 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.007 MB Paměť před dotazem: 18.069 MB

UPDATE n53zh_phocacart_products

  SET `hits` = (`hits` + 1)

  WHERE `id` = '2'

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: UPDATE n53zh_phocacart_products SET `hits` = (`hits` + 1) WHERE `id` = '2'

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.09 ms
updating	0.18 ms
end	0.02 ms
Waiting for query cache lock	0.02 ms
end	0.03 ms
query end	1.22 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.06 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_phocacart/models/item.php:336
11	PhocaCartModelItem->hit()	JROOT/components/com_phocacart/views/item/view.html.php:221
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.01 ms Po posledním dotazu: 7.44 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 18.671 MB Vráceno řádků: 1

SELECT a.id 
  FROM n53zh_phocacart_currencies AS a 
  WHERE a.id = 1 
  AND a.published = 1 
  ORDER BY a.id

Vysvětlení

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

Profil

Status	Duration
starting	0.24 ms
checking permissions	0.08 ms
Opening tables	0.10 ms
After opening tables	0.02 ms
System lock	0.06 ms
Table lock	0.07 ms
init	0.12 ms
optimizing	0.08 ms
statistics	0.22 ms
preparing	0.04 ms
Unlocking tables	0.03 ms
executing	0.08 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.07 ms
closing tables	0.06 ms
Unlocking tables	0.08 ms
freeing items	0.07 ms
updating status	0.08 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_phocacart/libraries/phocacart/currency/currency.php:109
17	PhocacartCurrency::isCurrencyValid()	JROOT/administrator/components/com_phocacart/libraries/phocacart/currency/currency.php:59
16	PhocacartCurrency::getCurrency()	JROOT/administrator/components/com_phocacart/libraries/phocacart/price/price.php:93
15	PhocacartPrice->setCurrency()	JROOT/administrator/components/com_phocacart/libraries/phocacart/price/price.php:29
14	PhocacartPrice->__construct()	JROOT/components/com_phocacart/views/item/tmpl/default.php:190
13	include JROOT/components/com_phocacart/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_phocacart/views/item/view.html.php:252
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.64 ms Po posledním dotazu: 4.77 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 19.027 MB Vráceno řádků: 1

SELECT enabled

  FROM `n53zh_extensions`

  WHERE `element` = 'com_sppagebuilder' 
  AND `type` = 'component'

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.28 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.08 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:306
21	PlgContentSppagebuilder->isSppagebuilderEnabled()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:49
20	PlgContentSppagebuilder->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Stejné jako volání na řádku níže.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_phocacart/views/item/tmpl/default.php:229
13	include JROOT/components/com_phocacart/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_phocacart/views/item/view.html.php:252
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.28 ms Po posledním dotazu: 6.72 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 19.749 MB Vráceno řádků: 1

SELECT s.id, s.title, s.title_feed, s.image, s.link, s.link_target 
  FROM n53zh_phocacart_stock_statuses AS s 
  LEFT JOIN n53zh_phocacart_products AS p 
  ON s.id = p.stockstatus_a_id 
  WHERE s.id = 2 
  GROUP BY s.id 
  ORDER BY s.id

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	p	ref	stockstatus_a_id	stockstatus_a_id	4	const	5	Using index

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.05 ms
Unlocking tables	0.05 ms
executing	0.03 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocacart/libraries/phocacart/stock/stock.php:39
16	PhocacartStock::getStockStatusData()	JROOT/administrator/components/com_phocacart/libraries/phocacart/stock/stock.php:125
15	PhocacartStock::getStockStatus()	JROOT/administrator/components/com_phocacart/libraries/phocacart/stock/stock.php:436
14	PhocacartStock::getStockItemsChangedByAttributes()	JROOT/components/com_phocacart/views/item/tmpl/default.php:273
13	include JROOT/components/com_phocacart/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_phocacart/views/item/view.html.php:252
10	PhocaCartViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocacart/controller.php:44
8	PhocaCartController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocacart/phocacart.php:14
6	require_once JROOT/components/com_phocacart/phocacart.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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.17 ms Po posledním dotazu: 40.03 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 20.906 MB Vráceno řádků: 49

SELECT guest, client_id

  FROM n53zh_session

  WHERE client_id = 0

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	n53zh_session	ref	client_id_guest	client_id_guest	2	const	48	Using index

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.05 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.06 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:45
11	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
10	include JROOT/modules/mod_whosonline/mod_whosonline.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

33 zaznamenaných typů dotazu, řazeno dle výskytu

VYBRANÉ tabulky:

2 × SELECT `template` 
  FROM `n53zh_template_styles`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `n53zh_extensions`

2 × SELECT a.title, a.alias, a.id, a.parent_id 
  FROM n53zh_phocacart_categories AS a

2 × SELECT a.id 
  FROM n53zh_phocacart_currencies AS a

1 × SELECT `data` 
  FROM `n53zh_session`

1 × SELECT a.id, a.title, a.alias, a.type, a.display_format, a.link_ext, a.link_cat, a.icon_class 
  FROM n53zh_phocacart_tags AS a 
  LEFT JOIN n53zh_phocacart_taglabels_related AS r 
  ON a.id = r.tag_id

1 × SELECT s.id, s.title, s.title_feed, s.image, s.link, s.link_target 
  FROM n53zh_phocacart_stock_statuses AS s 
  LEFT JOIN n53zh_phocacart_products AS p 
  ON s.id = p.stockstatus_a_id

1 × SELECT enabled 
  FROM `n53zh_extensions`

1 × SELECT * 
  FROM n53zh_phocacart_products

1 × SELECT a.* 
  FROM n53zh_phocacart_currencies AS a

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

1 × SELECT alias 
  FROM n53zh_phocacart_products

1 × SELECT a.id, a.product_id, a.user_id, a.name, a.rating, a.review, a.date, a.published 
  FROM n53zh_phocacart_reviews AS a

1 × SELECT s.id, s.title, s.alias, s.value, s.alias_value, s.image, s.image_medium, s.image_small, s.color, g.id as groupid, g.title as grouptitle 
  FROM n53zh_phocacart_specifications AS s 
  LEFT JOIN n53zh_phocacart_specification_groups AS g 
  ON g.id = s.group_id

1 × SELECT a.id, a.title, a.alias, a.required, a.type 
  FROM n53zh_phocacart_attributes AS a

1 × SELECT i.image 
  FROM n53zh_phocacart_product_images AS i 
  LEFT JOIN n53zh_phocacart_products AS p 
  ON p.id = i.product_id

1 × SELECT a.id, a.title, a.alias, a.type, a.display_format, a.link_ext, a.link_cat, a.icon_class 
  FROM n53zh_phocacart_tags AS a 
  LEFT JOIN n53zh_phocacart_tags_related AS r 
  ON a.id = r.tag_id

1 × SELECT DISTINCT a.id as id, a.title as title, a.image as image, a.alias as alias, a.description, a.description_long, SUBSTRING_INDEX(GROUP_CONCAT(c.id 
  ORDER BY c.parent_id), ',', 1) as catid, SUBSTRING_INDEX(GROUP_CONCAT(c.title 
  ORDER BY c.parent_id), ',', 1) as cattitle, SUBSTRING_INDEX(GROUP_CONCAT(c.alias 
  ORDER BY c.parent_id), ',', 1) as catalias,  GROUP_CONCAT(c2.id) AS catid2, GROUP_CONCAT(c2.alias) AS catalias2, GROUP_CONCAT(c2.title) AS cattitle2 
  FROM n53zh_phocacart_products AS a 
  LEFT JOIN n53zh_phocacart_product_related AS t 
  ON a.id = t.product_b 
  LEFT JOIN n53zh_phocacart_product_categories AS pc 
  ON pc.product_id = a.id 
  LEFT JOIN n53zh_phocacart_categories AS c 
  ON c.id = pc.category_id 
  LEFT JOIN n53zh_phocacart_categories AS c2 
  ON c2.id = pc.category_id 
  and pc.category_id = 1 
  LEFT JOIN n53zh_phocacart_item_groups AS ga 
  ON a.id = ga.item_id 
  AND ga.type = 3 
  LEFT JOIN n53zh_phocacart_item_groups AS gc 
  ON c.id = gc.item_id 
  AND gc.type = 2

1 × SELECT `session_id` 
  FROM `n53zh_session`

1 × SELECT i.id,i.title,i.alias,i.description,i.features,i.metatitle,i.metadesc,i.metakey,i.metadata,i.type,i.image,i.weight,i.height,i.width,i.length,i.min_multiple_quantity,i.min_quantity_calculation,i.volume,i.description_long,i.price,i.price_original,i.stockstatus_a_id,i.stockstatus_n_id,i.stock_calculation,i.min_quantity,i.stock,i.sales,i.featured,i.external_id,i.unit_amount,i.unit_unit,i.video,i.external_link,i.external_text,i.external_link2,i.external_text2,i.public_download_file,i.public_download_text,i.public_play_file,i.public_play_text,i.sku,i.upc,i.ean,i.jan,i.isbn,i.mpn,i.serial_number,i.points_needed,i.points_received,i.date,i.date_update,i.delivery_date,i.gift_types, pc.ordering, c.id AS catid, c.title AS cattitle, c.alias AS catalias, m.id as manufacturerid, m.title as manufacturertitle, m.link as manufacturerlink, t.id as taxid, t.tax_rate as taxrate, t.calculation_type as taxcalculationtype, t.title as taxtitle, MIN(ppg.price) as group_price, MAX(pptg.points_received) as group_points_received 
  FROM n53zh_phocacart_products AS i 
  LEFT JOIN n53zh_phocacart_product_categories AS pc 
  ON pc.product_id = i.id 
  LEFT JOIN n53zh_phocacart_categories AS c 
  ON c.id = pc.category_id 
  LEFT JOIN n53zh_phocacart_manufacturers AS m 
  ON m.id = i.manufacturer_id 
  LEFT JOIN n53zh_phocacart_taxes AS t 
  ON t.id = i.tax_id 
  LEFT JOIN n53zh_phocacart_item_groups AS ga 
  ON i.id = ga.item_id 
  AND ga.type = 3 
  LEFT JOIN n53zh_phocacart_item_groups AS gc 
  ON c.id = gc.item_id 
  AND gc.type = 2 
  LEFT JOIN n53zh_phocacart_product_price_groups AS ppg 
  ON i.id = ppg.product_id 
  AND ppg.group_id IN (SELECT group_id 
  FROM n53zh_phocacart_item_groups

1 × SELECT c.id, c.title, c.alias, c.description, c.parent_id 
  FROM n53zh_phocacart_categories AS c 
  LEFT JOIN n53zh_phocacart_product_categories AS pc 
  ON pc.category_id = c.id 
  LEFT JOIN n53zh_phocacart_products AS a 
  ON a.id = pc.product_id 
  LEFT JOIN n53zh_phocacart_item_groups AS ga 
  ON a.id = ga.item_id 
  AND ga.type = 3 
  LEFT JOIN n53zh_phocacart_item_groups AS gc 
  ON c.id = gc.item_id 
  AND gc.type = 2

1 × SELECT id, home, template, s.params 
  FROM n53zh_template_styles as s 
  LEFT JOIN n53zh_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM n53zh_languages
```

1 × SELECT `alias`,`catid` 
  FROM `n53zh_phocacart_products`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM n53zh_menu AS m 
  LEFT JOIN n53zh_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM n53zh_extensions

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

1 × SELECT id, rules 
  FROM `n53zh_viewlevels

1 × SELECT guest, client_id 
  FROM n53zh_session

OSTATNÍ tabulky:

1 × INSERT INTO `n53zh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6236613537646138333531633363363934623466623935646431386230346637', 1, 1787348087, 0, '', 0

1 × UPDATE `n53zh_extensions` 
  SET `params` = '{\"mediaversion\":\"9252f9c745dd96c335d3fef32f45aa7d\"}'

1 × SHOW FULL COLUMNS 
  FROM `n53zh_phocacart_products

1 × UPDATE n53zh_phocacart_products 
  SET `hits` = (`hits` + 1)

Dárkový poukaz 1000 Kč

OBJEDNÁNÍ POUKAZŮ

SLUŽBY A CENY

Konzole ladění chyb Joomla!

Sezení

Informace o profilu

Čas

Paměť

Využití paměti

Dotazy do databáze

37 zaznamenaných dotazů 86.09 ms

Nalezeno 2 duplikátů!

33 zaznamenaných typů dotazu, řazeno dle výskytu

VYBRANÉ tabulky:

OSTATNÍ tabulky: