Internetový obchod firmy Just Doors.

Prodej standardních sekčních vrat, vchodových dveří, pohonů. Nízké ceny produktů DoorHan, které jsou dodávány po celé České republice.

11 230,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2375x2030 mm Máme skladem 26 ks Zvolte možnost

11 979,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2500x2030 mm Máme skladem 12 ks Zvolte možnost

12 728,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2750x2030 mm Máme skladem 27 ks Zvolte možnost

13 477,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 3000x2030 mm Máme skladem 18 ks Zvolte možnost

11 480,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2375x2150 mm Máme skladem 15 ks Zvolte možnost

12 229,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2500x2150 mm Máme skladem 19 ks Zvolte možnost

12 977,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2750x2150 mm Máme skladem 21 ks Zvolte možnost

13 726,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 3000x2150 mm Máme skladem 31 ks Zvolte možnost

11 729,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2375x2280 mm Máme skladem 27 ks Zvolte možnost

12 479,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2500x2280 mm Máme skladem 32 ks Zvolte možnost

13 227,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 2750x2280 mm Máme skladem 21 ks Zvolte možnost

13 976,00 CZK za ks Sekční garážová vrata DoorHan DIY pro otvor š x v: 3000x2280 mm Máme skladem 15 ks Zvolte možnost

Péče o zákazníky

Váš Účet

Joomla! konzole ladění chyb

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1575973987,
                "last": 1575973987,
                "now": 1575973987
            },
            "token": "H2DygrUXAigmgBQKim31lr5oYKbJKBE4"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": "56"
            }
        },
        "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
        }
    }
}

Informace o profilu

Čas

Paměť

Čas: 33.66 ms / 33.66 ms Paměť: 0.650 MB / 1.02 MB Application: afterLoad

Čas: 208.90 ms / 242.56 ms Paměť: 3.083 MB / 4.10 MB Application: afterInitialise

Čas: 170.83 ms / 413.38 ms Paměť: 1.003 MB / 5.11 MB Application: afterRoute

Čas: 0.40 ms / 413.79 ms Paměť: 0.006 MB / 5.11 MB Application: beforeRenderComponent com_hikashop

Čas: 414.74 ms / 828.53 ms Paměť: 2.721 MB / 7.83 MB Application: afterRenderComponent com_hikashop

Čas: 15.09 ms / 843.61 ms Paměť: 0.028 MB / 7.86 MB Application: afterDispatch

Čas: 23.87 ms / 867.48 ms Paměť: 0.366 MB / 8.23 MB Application: beforeRenderModule mod_menu (Péče o zákazníky)

Čas: 7.69 ms / 875.17 ms Paměť: 0.046 MB / 8.27 MB Application: afterRenderModule mod_menu (Péče o zákazníky)

Čas: 0.85 ms / 876.02 ms Paměť: 0.000 MB / 8.27 MB Application: beforeRenderModule mod_menu (Váš Účet)

Čas: 1.75 ms / 877.77 ms Paměť: 0.023 MB / 8.30 MB Application: afterRenderModule mod_menu (Váš Účet)

Čas: 16.05 ms / 893.82 ms Paměť: 0.053 MB / 8.35 MB Application: beforeRenderModule mod_search (Search)

Čas: 2.38 ms / 896.20 ms Paměť: 0.018 MB / 8.37 MB Application: afterRenderModule mod_search (Search)

Čas: 0.44 ms / 896.64 ms Paměť: 0.000 MB / 8.35 MB Application: beforeRenderModule mod_hikashop_cart (Koš)

Čas: 14.01 ms / 910.65 ms Paměť: 0.112 MB / 8.46 MB Application: afterRenderModule mod_hikashop_cart (Koš)

Čas: 1.14 ms / 911.79 ms Paměť: 0.000 MB / 8.45 MB Application: beforeRenderModule mod_bdthemes_logo (Logo Module)

Čas: 2.31 ms / 914.10 ms Paměť: 0.006 MB / 8.45 MB Application: afterRenderModule mod_bdthemes_logo (Logo Module)

Čas: 0.92 ms / 915.02 ms Paměť: 0.020 MB / 8.47 MB Application: beforeRenderModule mod_menu (Main Menu)

Čas: 65.06 ms / 980.08 ms Paměť: 0.241 MB / 8.71 MB Application: afterRenderModule mod_menu (Main Menu)

Čas: 29.94 ms / 1010.03 ms Paměť: 0.028 MB / 8.74 MB Application: beforeRenderModule mod_menu (Offcanvas menu)

Čas: 8.15 ms / 1018.18 ms Paměť: 0.015 MB / 8.76 MB Application: afterRenderModule mod_menu (Offcanvas menu)

Čas: 31.28 ms / 1049.46 ms Paměť: 0.252 MB / 9.01 MB Application: afterRender

Celkem dotazů do databáze: 87.12 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j346_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í v řá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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j346_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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.02 ms
Update	0.14 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	2.04 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.11 ms
Reset for next command	0.01 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[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.26 ms Po posledním dotazu: 15.77 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.736 MB Vráceno řádků: 5

SELECT id, rules

  FROM `j346_viewlevels`

Vysvětlení

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.53 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.11 ms
Reset for next command	0.01 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.42 ms Po posledním dotazu: 0.17 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.748 MB Vráceno řádků: 2

SELECT b.id

  FROM j346_usergroups AS a

  LEFT JOIN j346_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.26 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.08 ms
Executing	0.00 ms
Sending data	0.19 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.05 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.17 ms Po posledním dotazu: 97.45 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.225 MB Vráceno řádků: 2

SHOW FULL COLUMNS 
  FROM `j346_gsd_config`

Vysvětlení

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

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.52 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.08 ms
Opening tables	0.37 ms
After opening tables	0.01 ms
Checking permissions	0.08 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Removing tmp table	0.18 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.20 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:26
10	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/helpers/helper.php:326
8	GSDHelper::getParams()	JROOT/plugins/system/gsd/gsd.php:59
7	plgSystemGSD->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:625
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:196
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.64 ms Po posledním dotazu: 1.21 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 3.238 MB Vráceno řádků: 1

SELECT *

  FROM j346_gsd_config

  WHERE `name` = 'config'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/helpers/helper.php:327
8	GSDHelper::getParams()	JROOT/plugins/system/gsd/gsd.php:59
7	plgSystemGSD->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:625
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:196
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.68 ms Po posledním dotazu: 30.25 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 4.099 MB Vráceno řádků: 1

SELECT count(1)

  FROM `j346_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0

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.07 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.01 ms
Executing	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
8	plgSystemARKtypography->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:626
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:196
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: 8.10 ms Po posledním dotazu: 23.95 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 4.324 MB

UPDATE `j346_extensions`

  SET `params` = '{\"mediaversion\":\"4f43ef11f9e0596263563502f813158b\"}'

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

Vysvětlení

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

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.01 ms
Opening tables	2.23 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.17 ms
Updating	0.47 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	2.58 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.07 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.14 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/bdthemes_shortcodes/bdthemes_shortcodes.php:62
8	plgSystemBdthemes_Shortcodes->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.04 ms Po posledním dotazu: 139.79 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 5.103 MB Vráceno řádků: 1

SELECT params

  FROM `j346_extensions`

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

Vysvětlení

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

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.16 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.49 ms Po posledním dotazu: 28.60 ms Dotaz paměti: 0.061 MB Paměť před dotazem: 5.954 MB Vráceno řádků: 310

SELECT * 
  FROM j346_hikashop_config

Vysvětlení

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

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.36 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.38 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.25 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
9	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1099
8	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2845
7	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/hikashop.php:16
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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: 9.78 ms Po posledním dotazu: 24.47 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 6.270 MB Vráceno řádků: 1

SELECT * 
  FROM j346_menu 
  WHERE id = '191' 
  LIMIT 0, 1

Vysvětlení

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

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	1.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.34 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.11 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2140
17	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/menus.php:20
16	hikashopMenusClass->get()	JROOT/administrator/components/com_hikashop/helpers/module.php:231
15	hikashopModuleHelper->_getParams()	JROOT/administrator/components/com_hikashop/helpers/module.php:14
14	hikashopModuleHelper->initialize()	JROOT/components/com_hikashop/views/product/view.html.php:61
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.24 ms Po posledním dotazu: 77.71 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 6.545 MB Vráceno řádků: 0

Duplicitní dotazy: #50

SELECT cart.cart_id 
  FROM j346_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = '43bc159c485c1223b1f625a651ac4b23')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Použití filesort

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.43 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.11 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
16	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:132
15	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:467
14	hikashop_getZone()	JROOT/components/com_hikashop/views/product/view.html.php:424
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.40 ms Po posledním dotazu: 6.40 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 6.558 MB Vráceno řádků: 1

SELECT a.*,b.* 
  FROM j346_hikashop_category AS a 
  LEFT JOIN j346_hikashop_file AS b 
  ON a.category_id = b.file_ref_id 
  AND b.file_type = 'category' 
  WHERE a.category_id = 2 
  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
1	SIMPLE	b	ref	file_type	file_type	767	const	8	Using where

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.53 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.12 ms
Reset for next command	0.00 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_hikashop/classes/category.php:35
14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/product/view.html.php:477
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.75 ms Po posledním dotazu: 2.35 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 6.573 MB Vráceno řádků: 1

SELECT a.id 
  FROM j346_menu AS a 
  INNER JOIN `j346_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' 
  AND a.language IN ('*', '', 'cs-CZ')

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	6	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	just-doorscz02.b.menutype	8	Using where

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.01 ms
Opening tables	0.51 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.30 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
16	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/classes/menus.php:206
15	hikashopMenusClass->getCheckoutURL()	JROOT/administrator/components/com_hikashop/helpers/cart.php:254
14	hikashopCartHelper->getJS()	JROOT/components/com_hikashop/views/product/view.html.php:650
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.60 ms Po posledním dotazu: 79.33 ms Dotaz paměti: 0.050 MB Paměť před dotazem: 6.972 MB Vráceno řádků: 12

SELECT DISTINCT b.* 
  FROM j346_hikashop_product_category AS a 
  LEFT JOIN j346_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE (b.product_published = 1) 
  AND (b.product_type = 'main') 
  AND (a.category_id IN (2)) 
  ORDER BY a.ordering ASC 
  LIMIT 0, 12

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	category_id,product_id	category_id	4	const	22	Using where; Using temporary; Použití filesort
1	SIMPLE	b	eq_ref	PRIMARY,product_main_index	PRIMARY	4	just-doorscz02.a.product_id	1	Using where

Profil

Status	Duration
Starting	0.17 ms
Checking permissions	0.01 ms
Opening tables	0.75 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.12 ms
Optimizing	0.05 ms
Statistics	0.21 ms
Preparing	0.04 ms
Creating tmp table	0.12 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	1.97 ms
Creating sort index	0.52 ms
Removing tmp table	0.96 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.09 ms
Reset for next command	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:722
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.70 ms Po posledním dotazu: 2.35 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 7.041 MB Vráceno řádků: 12

SELECT * 
  FROM j346_hikashop_file 
  WHERE file_ref_id IN (35,40,45,50,56,61,66,71,76,81,86,91) 
  AND file_type IN ('product','file') 
  ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC

Vysvětlení

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

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.03 ms
Statistics	0.24 ms
Preparing	0.02 ms
Sorting result	0.06 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.51 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.13 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1735
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.98 ms Po posledním dotazu: 0.19 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.065 MB Vráceno řádků: 24

SELECT variant_product_id 
  FROM j346_hikashop_variant 
  WHERE variant_product_id IN (35,40,45,50,56,61,66,71,76,81,86,91)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j346_hikashop_variant	range	variant_product_id	variant_product_id	4	NULL	14	Using where; Using index

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.44 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1756
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.40 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 7.072 MB Vráceno řádků: 60

SELECT product_id 
  FROM j346_hikashop_product_related 
  WHERE product_related_type = 'options' 
  AND product_id IN (35,40,45,50,56,61,66,71,76,81,86,91)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j346_hikashop_product_related	index	PRIMARY	PRIMARY	775	NULL	157	Using where; Using index

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.60 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1772
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.15 ms Po posledním dotazu: 0.18 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 7.083 MB Vráceno řádků: 60

SELECT product_parent_id, product_id 
  FROM j346_hikashop_product 
  WHERE product_parent_id IN ('35','40','45','50','56','61','66','71','76','81','86','91') 
  AND product_published = 1 
  AND product_type = 'variant' 
  AND product_sale_start < 1575973988 
  AND (product_sale_end > 1575973988 OR product_sale_end = 0)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j346_hikashop_product	ref	product_parent_id,product_main_index	product_main_index	767	const	73	Using index condition; Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.20 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.49 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:973
17	hikashopCurrencyClass->_loadProductVariants()	JROOT/administrator/components/com_hikashop/classes/currency.php:512
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1787
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.42 ms Po posledním dotazu: 0.26 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 7.132 MB Vráceno řádků: 0

SELECT * 
  FROM j346_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND (discount_quota > discount_used_times OR discount_quota = 0) 
  AND discount_start < 1575973988 
  AND (discount_end > 1575973988 OR discount_end = 0) 
  AND ( (discount_product_id IN ('','0','35','40','45','50','56','61','66','71','76','81','86','91')) OR (discount_product_id LIKE '%,35,%') OR (discount_product_id LIKE '%,40,%') OR (discount_product_id LIKE '%,45,%') OR (discount_product_id LIKE '%,50,%') OR (discount_product_id LIKE '%,56,%') OR (discount_product_id LIKE '%,61,%') OR (discount_product_id LIKE '%,66,%') OR (discount_product_id LIKE '%,71,%') OR (discount_product_id LIKE '%,76,%') OR (discount_product_id LIKE '%,81,%') OR (discount_product_id LIKE '%,86,%') OR (discount_product_id LIKE '%,91,%') OR (discount_product_id LIKE '%,38,%') OR (discount_product_id LIKE '%,41,%') OR (discount_product_id LIKE '%,42,%') OR (discount_product_id LIKE '%,43,%') OR (discount_product_id LIKE '%,44,%') OR (discount_product_id LIKE '%,84,%') OR (discount_product_id LIKE '%,36,%') OR (discount_product_id LIKE '%,37,%') OR (discount_product_id LIKE '%,58,%') OR (discount_product_id LIKE '%,64,%') OR (discount_product_id LIKE '%,93,%') OR (discount_product_id LIKE '%,94,%') OR (discount_product_id LIKE '%,39,%') OR (discount_product_id LIKE '%,62,%') OR (discount_product_id LIKE '%,63,%') OR (discount_product_id LIKE '%,67,%') OR (discount_product_id LIKE '%,82,%') OR (discount_product_id LIKE '%,87,%') OR (discount_product_id LIKE '%,88,%') OR (discount_product_id LIKE '%,95,%') OR (discount_product_id LIKE '%,46,%') OR (discount_product_id LIKE '%,47,%') OR (discount_product_id LIKE '%,48,%') OR (discount_product_id LIKE '%,51,%') OR (discount_product_id LIKE '%,53,%') OR (discount_product_id LIKE '%,57,%') OR (discount_product_id LIKE '%,59,%') OR (discount_product_id LIKE '%,68,%') OR (discount_product_id LIKE '%,69,%') OR (discount_product_id LIKE '%,70,%') OR (discount_product_id LIKE '%,75,%') OR (discount_product_id LIKE '%,79,%') OR (discount_product_id LIKE '%,80,%') OR (discount_product_id LIKE '%,83,%') OR (discount_product_id LIKE '%,85,%') OR (discount_product_id LIKE '%,89,%') OR (discount_product_id LIKE '%,92,%') OR (discount_product_id LIKE '%,118,%') OR (discount_product_id LIKE '%,122,%') OR (discount_product_id LIKE '%,49,%') OR (discount_product_id LIKE '%,52,%') OR (discount_product_id LIKE '%,54,%') OR (discount_product_id LIKE '%,60,%') OR (discount_product_id LIKE '%,65,%') OR (discount_product_id LIKE '%,72,%') OR (discount_product_id LIKE '%,73,%') OR (discount_product_id LIKE '%,74,%') OR (discount_product_id LIKE '%,77,%') OR (discount_product_id LIKE '%,78,%') OR (discount_product_id LIKE '%,90,%') OR (discount_product_id LIKE '%,117,%') OR (discount_product_id LIKE '%,119,%') OR (discount_product_id LIKE '%,120,%') OR (discount_product_id LIKE '%,121,%') OR (discount_product_id LIKE '%,123,%') OR (discount_product_id LIKE '%,124,%') OR (discount_product_id LIKE '%,125,%') OR (discount_product_id LIKE '%,126,%') OR (discount_product_id LIKE '%,127,%') OR (discount_product_id LIKE '%,128,%') ) 
  AND (discount_flat_amount != 0 OR discount_percent_amount != 0) 
  AND (discount_flat_amount = 0 OR discount_currency_id =46) 
  AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')

Vysvětlení

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

Profil

Status	Duration
Starting	0.43 ms
Checking permissions	0.01 ms
Opening tables	0.31 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.16 ms
Optimizing	0.07 ms
Statistics	0.02 ms
Preparing	0.05 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 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_hikashop/classes/currency.php:554
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1787
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.72 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 7.141 MB Vráceno řádků: 3

SELECT currency_id 
  FROM j346_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 46

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j346_hikashop_currency	ALL	PRIMARY	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	182	Using where

Profil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.19 ms
After opening tables	0.93 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:469
17	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:562
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1787
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.22 ms Po posledním dotazu: 0.31 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.144 MB Vráceno řádků: 0

SELECT a.*, 
  CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id 
  FROM j346_hikashop_price AS a 
  WHERE a.price_product_id IN (35,40,45,50,56,61,66,71,76,81,86,91) 
  AND a.price_currency_id IN (1,2,46) 
  AND a.price_start_date < 1575973988 
  AND (a.price_end_date < 1 OR a.price_end_date > 1575973988) 
  AND (a.price_access = 'all' OR a.price_access LIKE '%,9,%' OR ISNULL(a.price_access)) 
  AND (a.price_users = '' OR a.price_users LIKE '%,0,%') 
  ORDER BY a.price_site_id ASC, a.price_value DESC

Vysvětlení

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

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.34 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.12 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 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_hikashop/classes/currency.php:585
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1787
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.30 ms Po posledním dotazu: 0.14 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 7.156 MB Vráceno řádků: 60

SELECT * 
  FROM j346_hikashop_price 
  WHERE price_product_id IN (38,36,37,39,117,41,42,43,44,118,46,47,48,49,119,51,53,52,54,120,58,57,59,60,121,64,62,63,122,65,67,68,69,70,123,75,72,73,74,124,79,80,77,78,125,84,82,83,85,126,87,88,89,90,127,93,94,95,92,128) 
  AND price_currency_id IN (1,2,46) 
  AND (price_access = 'all' OR price_access LIKE '%,9,%' OR ISNULL(price_access)) 
  AND (price_users = '' OR price_users LIKE '%,0,%')

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j346_hikashop_price	ALL	price_product_id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	105	Using where

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.10 ms
Optimizing	0.03 ms
Statistics	0.19 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.21 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.01 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_hikashop/classes/currency.php:764
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1787
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.54 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 7.220 MB Vráceno řádků: 1

SELECT * 
  FROM j346_hikashop_currency 
  WHERE currency_id IN (46)

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1862
18	hikashopCurrencyClass->getCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:2260
17	hikashopCurrencyClass->getRounding()	JROOT/administrator/components/com_hikashop/classes/currency.php:839
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1787
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.26 ms Po posledním dotazu: 4.09 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 7.236 MB Vráceno řádků: 1

SELECT b.*,c.* 
  FROM j346_hikashop_category AS a 
  LEFT JOIN j346_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN j346_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey 
  WHERE a.category_id = 11 
  AND b.taxation_published=1 
  AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
  AND b.taxation_date_start <= 1575973988 
  AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1575973988) 
  ORDER BY b.taxation_id ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,category_namekey	PRIMARY	4	const	1
1	SIMPLE	b	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	86	Using where; Použití filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	767	just-doorscz02.b.tax_namekey	1

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	1.15 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.13 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.18 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.13 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:195
18	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
17	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:840
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1787
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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: 0.14 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 7.247 MB Vráceno řádků: 1

SELECT * 
  FROM j346_hikashop_zone 
  WHERE zone_id = 56

Vysvětlení

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

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.64 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.10 ms
Reset for next command	0.00 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_hikashop/classes/currency.php:216
18	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
17	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:840
16	hikashopCurrencyClass->getProductsPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:474
15	hikashopCurrencyClass->getListingPrices()	JROOT/administrator/components/com_hikashop/classes/product.php:1787
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.04 ms Po posledním dotazu: 0.92 ms Dotaz paměti: 0.051 MB Paměť před dotazem: 7.319 MB Vráceno řádků: 24

SELECT c.*, pc.*  
  FROM j346_hikashop_category AS c  
  LEFT JOIN j346_hikashop_product_category AS pc 
  ON c.category_id = pc.category_id  
  WHERE pc.product_id IN (35,40,45,50,56,61,66,71,76,81,86,91);

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	category_id,product_id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	70	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	just-doorscz02.pc.category_id	1

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.07 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.34 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/product.php:1822
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.60 ms Po posledním dotazu: 0.44 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 7.391 MB Vráceno řádků: 3

Duplicitní dotazy: #42

SELECT hk_parent.* 
  FROM j346_hikashop_category AS hk_cat  
  LEFT JOIN j346_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)  
  WHERE  hk_cat.category_id IN (14,2)  
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hk_cat	range	PRIMARY	PRIMARY	4	NULL	2	Using index condition; Using temporary; Použití filesort
1	SIMPLE	hk_parent	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	21	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.17 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.08 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.45 ms
Creating sort index	0.12 ms
Removing tmp table	0.20 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.10 ms
Reset for next command	0.01 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_hikashop/classes/category.php:740
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/badge.php:114
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.59 ms Po posledním dotazu: 0.15 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.409 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 26) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78411794) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.21 ms
Checking permissions	0.01 ms
Opening tables	0.43 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.10 ms
Optimizing	0.06 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.87 ms Po posledním dotazu: 0.21 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.418 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 12) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78410897) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.14 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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: 0.13 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.427 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 27) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78409396) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.60 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.08 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.39 ms Po posledním dotazu: 0.19 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 7.443 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 18) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78408935) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.06 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.34 ms Po posledním dotazu: 0.15 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.453 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 15) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78345593) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.07 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.31 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.462 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 19) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78344246) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.06 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.31 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.471 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 21) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78255665) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.06 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.30 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.480 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 31) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78254920) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.06 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.31 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.489 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 27) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78253298) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.06 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.30 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.499 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 32) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78252910) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.06 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.30 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.508 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 21) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78252588) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.06 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.29 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.517 MB Vráceno řádků: 0

SELECT a.* 
  FROM j346_hikashop_badge AS a 
  WHERE a.badge_start <= 1575973988 
  AND (a.badge_end >= 1575973988 OR a.badge_end = 0) 
  AND a.badge_published = 1 
  AND (a.badge_quantity = '' OR a.badge_quantity = 15) 
  AND (a.badge_new_period = 0 OR a.badge_new_period >= 78252104) 
  AND (badge_discount_id = '0' OR badge_discount_id = '') 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%')) OR (badge_category_childs = 1 
  AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '14' OR badge_category_id LIKE '%,14,%'))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC

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.06 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/badge.php:151
15	hikashopBadgeClass->loadBadges()	JROOT/administrator/components/com_hikashop/classes/product.php:1838
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.99 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 7.524 MB Vráceno řádků: 3

Duplicitní dotazy: #29

SELECT hk_parent.* 
  FROM j346_hikashop_category AS hk_cat  
  LEFT JOIN j346_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)  
  WHERE  hk_cat.category_id IN (14,2)  
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hk_cat	range	PRIMARY	PRIMARY	4	NULL	2	Using index condition; Using temporary; Použití filesort
1	SIMPLE	hk_parent	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	21	Using where; Using join buffer (flat, BNL join)

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:740
17	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:320
16	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:156
15	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/classes/product.php:1846
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.78 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.563 MB Vráceno řádků: 0

SELECT * 
  FROM j346_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_display` LIKE '%;front\_listing=1;%' 
  AND a.field_table='product'  
  AND ((((field_with_sub_categories = 0 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,14,%' OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories = 1 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,14,%'))) 
  AND field_products="") OR (field_products LIKE '%,35,%' OR field_products LIKE '%,40,%' OR field_products LIKE '%,45,%' OR field_products LIKE '%,50,%' OR field_products LIKE '%,56,%' OR field_products LIKE '%,61,%' OR field_products LIKE '%,66,%' OR field_products LIKE '%,71,%' OR field_products LIKE '%,76,%' OR field_products LIKE '%,81,%' OR field_products LIKE '%,86,%' OR field_products LIKE '%,91,%')) 
  ORDER BY a.`field_ordering` ASC

Vysvětlení

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

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.00 ms
Opening tables	0.33 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.00 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_hikashop/classes/field.php:137
16	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:157
15	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/classes/product.php:1846
14	hikashopProductClass->loadProductsListingData()	JROOT/components/com_hikashop/views/product/view.html.php:739
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.50 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 7.560 MB Vráceno řádků: 1

SELECT COUNT( DISTINCT b.product_id ) 
  FROM j346_hikashop_product_category AS a 
  LEFT JOIN j346_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE (b.product_published = 1) 
  AND (b.product_type = 'main') 
  AND (a.category_id IN (2)) 
  ORDER BY a.ordering ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	category_id,product_id	category_id	4	const	22
1	SIMPLE	b	eq_ref	PRIMARY,product_main_index	PRIMARY	4	just-doorscz02.a.product_id	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/views/product/view.html.php:767
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.25 ms Po posledním dotazu: 6.93 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 7.578 MB Vráceno řádků: 2

SELECT hk_parent.* 
  FROM j346_hikashop_category AS hk_cat  
  LEFT JOIN j346_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)  
  WHERE  hk_cat.category_id = 2 
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hk_cat	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Použití filesort
1	SIMPLE	hk_parent	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	21	Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.32 ms
Creating sort index	0.08 ms
Removing tmp table	0.12 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.00 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_hikashop/classes/category.php:740
16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:419
15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:156
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:795
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.44 ms Po posledním dotazu: 0.25 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 7.591 MB Vráceno řádků: 0

SELECT * 
  FROM j346_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='category'  
  AND ((field_with_sub_categories = 0 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories = 1 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) 
  ORDER BY a.`field_ordering` ASC

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:137
15	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:157
14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:795
13	ProductViewProduct->listing()	JROOT/components/com_hikashop/views/product/view.html.php:28
12	ProductViewProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
11	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1978
10	hikashopController->display()	JROOT/components/com_hikashop/controllers/product.php:46
9	productController->listing()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1956
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.81 ms Po posledním dotazu: 132.05 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 7.847 MB Vráceno řádků: 0

SELECT * 
  FROM ( SELECT * 
  FROM j346_tagmeta_rules 
  WHERE ( ( ('/hikashop-menu-for-categories-listing' REGEXP BINARY url)>0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) 
  AND (request_only<>0) ) OR ( ('/hikashop-menu-for-categories-listing' REGEXP BINARY url)>0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) 
  AND (request_only<>0) ) OR ( ('https://vrata-praha.cz/hikashop-menu-for-categories-listing' REGEXP BINARY url)>0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) 
  AND (request_only=0) ) OR ( ('https://vrata-praha.cz/hikashop-menu-for-categories-listing' REGEXP BINARY url)>0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) 
  AND (request_only=0) ) OR ( ('/hikashop-menu-for-categories-listing' REGEXP url)>0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) 
  AND (request_only<>0) ) OR ( ('/hikashop-menu-for-categories-listing' REGEXP url)>0 
  AND (case_sensitive=0) 
  AND (decode_url=0) 
  AND (request_only<>0) ) OR ( ('https://vrata-praha.cz/hikashop-menu-for-categories-listing' REGEXP url)>0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) 
  AND (request_only=0) ) OR ( ('https://vrata-praha.cz/hikashop-menu-for-categories-listing' REGEXP url)>0 
  AND (case_sensitive=0) 
  AND (decode_url=0) 
  AND (request_only=0) ) ) 
  AND published=1 
  ORDER BY ordering ) AS A 
  WHERE A.skip='' OR ( ('https://vrata-praha.cz/hikashop-menu-for-categories-listing' REGEXP BINARY A.skip)=0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) ) OR ( ('https://vrata-praha.cz/hikashop-menu-for-categories-listing' REGEXP BINARY A.skip)=0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) ) OR ( ('https://vrata-praha.cz/hikashop-menu-for-categories-listing' REGEXP A.skip)=0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) ) OR ( ('https://vrata-praha.cz/hikashop-menu-for-categories-listing' REGEXP A.skip)=0 
  AND (case_sensitive=0) 
  AND (decode_url=0) )

Vysvětlení

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

Profil

Status	Duration
Starting	0.42 ms
Checking permissions	0.01 ms
Opening tables	0.57 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	1.33 ms
Optimizing	0.21 ms
Statistics	0.05 ms
Preparing	0.12 ms
Executing	0.01 ms
Sending data	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Removing tmp table	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.18 ms
Reset for next command	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/tagmeta/tagmeta.php:1038
7	plgSystemTagMeta->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.10 ms Po posledním dotazu: 0.29 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 7.850 MB Vráceno řádků: 0

SELECT id,placeholder

  FROM `j346_gdpr_checkbox`

Vysvětlení

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

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.52 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/gdpr/gdpr.php:1091
7	plgSystemGdpr->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.58 ms Po posledním dotazu: 25.67 ms Dotaz paměti: 0.044 MB Paměť před dotazem: 8.106 MB Vráceno řádků: 22

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

  FROM j346_modules AS m

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

  LEFT JOIN j346_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 <= '2019-12-10 10:33:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-10 10:33:08') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 191 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	51	Using index condition; Using where; Použití filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	just-doorscz02.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	just-doorscz02.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.31 ms
Checking permissions	0.01 ms
Opening tables	0.97 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.09 ms
Optimizing	0.07 ms
Statistics	0.17 ms
Preparing	0.09 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.19 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.17 ms
Reset for next command	0.01 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í v řá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:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/holax/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/holax/layouts/theme.config.php:28
10	include JROOT/templates/holax/layouts/theme.config.php	JROOT/templates/holax/layouts/theme.php:9
9	include JROOT/templates/holax/layouts/theme.php	JROOT/templates/holax/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/holax/index.php:16
7	require JROOT/templates/holax/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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.31 ms Po posledním dotazu: 36.06 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 8.470 MB Vráceno řádků: 0

Duplicitní dotazy: #13

SELECT cart.cart_id 
  FROM j346_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = '43bc159c485c1223b1f625a651ac4b23')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Použití filesort

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	1.08 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
21	hikashopCartClass->getCurrentCartId()	JROOT/components/com_hikashop/views/product/view.html.php:2280
20	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:784
18	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
17	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/holax/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
14	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/holax/warp/systems/joomla/layouts/widgets.php:10
13	include JROOT/templates/holax/warp/systems/joomla/layouts/widgets.php	JROOT/templates/holax/warp/src/Warp/Helper/TemplateHelper.php:49
12	Warp\Helper\TemplateHelper->render()	JROOT/templates/holax/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
11	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/holax/layouts/header.php:24
10	bdt_headerStyle()	JROOT/templates/holax/layouts/theme.php:52
9	include JROOT/templates/holax/layouts/theme.php	JROOT/templates/holax/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/holax/index.php:16
7	require JROOT/templates/holax/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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.38 ms Po posledním dotazu: 0.45 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 8.484 MB Vráceno řádků: 17

SELECT a.id 
  FROM j346_menu AS a 
  INNER JOIN `j346_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=%' 
  AND a.language IN ('*', '', 'cs-CZ')

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	6	Using where
1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	just-doorscz02.b.menutype	8	Using where

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.19 ms
Preparing	0.04 ms
Executing	0.00 ms
Sending data	0.42 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.14 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
23	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
22	hikashopMenusClass->loadAMenuItemId()	JROOT/components/com_hikashop/views/product/view.html.php:2471
21	ProductViewProduct->legacyCartInit()	JROOT/components/com_hikashop/views/product/view.html.php:2386
20	ProductViewProduct->cart()	JROOT/components/com_hikashop/views/product/view.html.php:28
19	ProductViewProduct->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:784
18	hikashop_getLayout()	JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:67
17	include JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/holax/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
14	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/holax/warp/systems/joomla/layouts/widgets.php:10
13	include JROOT/templates/holax/warp/systems/joomla/layouts/widgets.php	JROOT/templates/holax/warp/src/Warp/Helper/TemplateHelper.php:49
12	Warp\Helper\TemplateHelper->render()	JROOT/templates/holax/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
11	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/holax/layouts/header.php:24
10	bdt_headerStyle()	JROOT/templates/holax/layouts/theme.php:52
9	include JROOT/templates/holax/layouts/theme.php	JROOT/templates/holax/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/holax/index.php:16
7	require JROOT/templates/holax/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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.37 ms Po posledním dotazu: 135.26 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 8.831 MB Vráceno řádků: 3

SHOW FULL COLUMNS 
  FROM `j346_tawkwidget`

Vysvětlení

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Closing tables	0.00 ms
Opening tables	0.47 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.08 ms
Opening tables	0.23 ms
After opening tables	0.01 ms
Checking permissions	0.08 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.17 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.16 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/plugins/system/tawkwidget/tables/tawkwidget.php:18
16	TawkWidgetTableTawkWidget->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/tawkwidget/models/tawkwidget.php:22
14	TawkWidgetModelTawkWidget->getTable()	JROOT/plugins/system/tawkwidget/models/tawkwidget.php:30
13	TawkWidgetModelTawkWidget->getWidget()	JROOT/plugins/system/tawkwidget/tawkwidget.php:21
12	plgSystemTawkwidget->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.54 ms Po posledním dotazu: 0.25 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 8.846 MB Vráceno řádků: 1

SELECT *

  FROM j346_tawkwidget

  WHERE `id` = '1'

Vysvětlení

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

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.04 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.91 ms
Reset for next command	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/tawkwidget/models/tawkwidget.php:31
13	TawkWidgetModelTawkWidget->getWidget()	JROOT/plugins/system/tawkwidget/tawkwidget.php:21
12	plgSystemTawkwidget->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.]

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

VYBRANÉ tabulky:

12 × SELECT a.* 
  FROM j346_hikashop_badge AS a

3 × SELECT hk_parent.* 
  FROM j346_hikashop_category AS hk_cat  
  LEFT JOIN j346_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)

2 × SELECT cart.cart_id 
  FROM j346_hikashop_cart AS cart

2 × SELECT * 
  FROM j346_hikashop_field as a

2 × SELECT a.id 
  FROM j346_menu AS a 
  INNER JOIN `j346_menu_types` as b 
  on a.menutype = b.menutype

1 × SELECT * 
  FROM j346_hikashop_price

1 × SELECT * 
  FROM j346_hikashop_currency

1 × SELECT b.*,c.* 
  FROM j346_hikashop_category AS a 
  LEFT JOIN j346_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN j346_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey

1 × SELECT * 
  FROM j346_hikashop_zone

1 × SELECT `data` 
  FROM `j346_session`

1 × SELECT c.*, pc.*  
  FROM j346_hikashop_category AS c  
  LEFT JOIN j346_hikashop_product_category AS pc 
  ON c.category_id = pc.category_id

1 × SELECT currency_id 
  FROM j346_hikashop_currency

1 × SELECT COUNT( DISTINCT b.product_id ) 
  FROM j346_hikashop_product_category AS a 
  LEFT JOIN j346_hikashop_product AS b 
  ON a.product_id=b.product_id

1 × SELECT * 
  FROM ( SELECT * 
  FROM j346_tagmeta_rules

1 × SELECT id,placeholder 
  FROM `j346_gdpr_checkbox

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

1 × SELECT a.*, 
  CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id 
  FROM j346_hikashop_price AS a

1 × SELECT product_parent_id, product_id 
  FROM j346_hikashop_product

1 × SELECT * 
  FROM j346_hikashop_discount

1 × SELECT `session_id` 
  FROM `j346_session`

1 × SELECT product_id 
  FROM j346_hikashop_product_related

1 × SELECT variant_product_id 
  FROM j346_hikashop_variant

1 × SELECT * 
  FROM j346_hikashop_file

1 × SELECT DISTINCT b.* 
  FROM j346_hikashop_product_category AS a 
  LEFT JOIN j346_hikashop_product AS b 
  ON a.product_id=b.product_id

1 × SELECT a.*,b.* 
  FROM j346_hikashop_category AS a 
  LEFT JOIN j346_hikashop_file AS b 
  ON a.category_id = b.file_ref_id 
  AND b.file_type = 'category'

```
1 × SELECT * 
  FROM j346_menu
```

1 × SELECT * 
  FROM j346_hikashop_confi

1 × SELECT params 
  FROM `j346_extensions`

1 × SELECT count(1) 
  FROM `j346_session`

```
1 × SELECT * 
  FROM j346_gsd_config
```

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

1 × SELECT id, rules 
  FROM `j346_viewlevels

```
1 × SELECT * 
  FROM j346_tawkwidget
```

JINÉ tabulky:

1 × INSERT INTO `j346_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3433626331353963343835633132323362316636323561363531616334623233', 1, 1575973987, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `j346_gsd_config

1 × UPDATE `j346_extensions` 
  SET `params` = '{\"mediaversion\":\"4f43ef11f9e0596263563502f813158b\"}'

1 × SHOW FULL COLUMNS 
  FROM `j346_tawkwidget

Internetový obchod firmy Just Doors.

Péče o zákazníky

Váš Účet

Joomla! konzole ladění chyb

Sezení

Informace o profilu

Čas

Paměť

Využití paměti

Dotazy do databáze

53 zaznamenaných dotazů 87.12 ms

Nalezeno 4 duplikátů!

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

VYBRANÉ tabulky:

JINÉ tabulky: