Rabljeni viličari : CATERPILLAR DP50

Joomla! Debug konzola

Sesija

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728295782,
                "last": 1728295782,
                "now": 1728295782
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__JPluginGJFields": {
        "DefaultParams": {
            "bruteMode": "0",
            "showDebug": "1",
            "vmCompatibility": "0",
            "ruleEnabled": "1",
            "textorfields": "1",
            "textparams": "",
            "basePath": "components/com_content/views/article/view.html.php",
            "overridePath": "com_content/views/article/view.html.php",
            "className": "",
            "option": "com_content",
            "scope": "site",
            "changePrivate": "0",
            "includes": ""
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedcategoryid": 14,
        "vmlastvisitedproductids": [
            2725
        ]
    }
}

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

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

#	Pozivatelj	Datoteka i broj linije
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

OBJAŠNJENJE što je nemoguće kod upita: INSERT INTO `ubnex_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3438343538396630313336633463343131666339393139363630646631353837', 1, 1728295782, 0, '', 0)

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.02 ms
update	0.14 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	1.34 ms
closing tables	0.05 ms
freeing items	0.13 ms
cleaning up	0.04 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.05 ms Nakon posljednjeg upita: 4.91 ms Memorija upita: 0.025 MB memorija prije upita: 1.481 MB Redaka vraćeno: 44

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

  FROM `ubnex_extensions`

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

Objašnjenje

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

Profil

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.24 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Isto kao i poziv u donjem retku.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.79 ms Nakon posljednjeg upita: 4.55 ms Memorija upita: 0.021 MB memorija prije upita: 1.511 MB Redaka vraćeno: 5

SELECT id, rules

  FROM `ubnex_viewlevels`

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_viewlevels	NULL	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	5	100.00	NULL

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.08 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.77 ms Nakon posljednjeg upita: 0.10 ms Memorija upita: 0.021 MB memorija prije upita: 1.523 MB Redaka vraćeno: 1

SELECT b.id

  FROM ubnex_usergroups AS a

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

  WHERE a.id = 1

Objašnjenje

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

Profil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.05 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.04 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.54 ms Nakon posljednjeg upita: 1.72 ms Memorija upita: 0.031 MB memorija prije upita: 1.544 MB Redaka vraćeno: 114

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

  FROM ubnex_extensions

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

  ORDER BY ordering

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_extensions	NULL	ALL	extension	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	305	0.33	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.77 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Isto kao i poziv u donjem retku.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.66 ms Nakon posljednjeg upita: 79.11 ms Memorija upita: 0.049 MB memorija prije upita: 2.742 MB Redaka vraćeno: 23

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

  FROM ubnex_menu AS m

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

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

  ORDER BY m.lft

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	138	5.58	Using where; Korištenje sortiranja datoteka
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	vilstroj_joomla_singlepage_new.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.39 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.06 ms
executing	0.51 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.03 ms
closing tables	0.04 ms
freeing items	0.09 ms
cleaning up	0.04 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
20	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Isto kao i poziv u donjem retku.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
17	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
16	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
15	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
13	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
12	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/mvcoverride/mvcoverride.php:1010
10	PlgSystemMVCOverride->_getIncludePaths()	JROOT/plugins/system/mvcoverride/mvcoverride.php:476
9	PlgSystemMVCOverride->_autoOverride()	JROOT/plugins/system/mvcoverride/mvcoverride.php:148
8	PlgSystemMVCOverride->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.99 ms Nakon posljednjeg upita: 0.80 ms Memorija upita: 0.081 MB memorija prije upita: 2.888 MB Redaka vraćeno: 7

Duplicirani upiti: #12

SELECT id, home, template, s.params

  FROM ubnex_template_styles as s

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

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

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	9	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	vilstroj_joomla_singlepage_new.e.element	1	70.00	Using index condition; Using where

Profil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.19 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.04 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.05 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/mvcoverride/mvcoverride.php:1010
10	PlgSystemMVCOverride->_getIncludePaths()	JROOT/plugins/system/mvcoverride/mvcoverride.php:476
9	PlgSystemMVCOverride->_autoOverride()	JROOT/plugins/system/mvcoverride/mvcoverride.php:148
8	PlgSystemMVCOverride->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.98 ms Nakon posljednjeg upita: 27.35 ms Memorija upita: 0.025 MB memorija prije upita: 2.954 MB Redaka vraćeno: 1

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

  FROM `ubnex_extensions`

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

Objašnjenje

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

Profil

Status	Duration
starting	0.23 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.06 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.07 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Isto kao i poziv u donjem retku.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.87 ms Nakon posljednjeg upita: 0.16 ms Memorija upita: 0.007 MB memorija prije upita: 2.947 MB

UPDATE `ubnex_extensions`

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

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

Objašnjenje

OBJAŠNJENJE što je nemoguće kod upita: UPDATE `ubnex_extensions` SET `params` = '{\"mediaversion\":\"cd9245279e4711f7f8d1ba8e634e4ace\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.10 ms
updating	0.11 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	1.22 ms
closing tables	0.04 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.96 ms Nakon posljednjeg upita: 3.74 ms Memorija upita: 0.082 MB memorija prije upita: 2.971 MB Redaka vraćeno: 7

Duplicirani upiti: #9

SELECT id, home, template, s.params

  FROM ubnex_template_styles as s

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

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

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	9	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	vilstroj_joomla_singlepage_new.e.element	1	70.00	Using index condition; Using where

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.24 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.04 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1593
9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.68 ms Nakon posljednjeg upita: 5.93 ms Memorija upita: 0.021 MB memorija prije upita: 3.083 MB Redaka vraćeno: 1

SELECT `template`

  FROM `ubnex_template_styles`

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

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	7	10.00	Using where

Profil

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.06 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.04 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Slijed poziva funkcija

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

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 4.68 ms Nakon posljednjeg upita: 92.29 ms Memorija upita: 0.023 MB memorija prije upita: 4.073 MB Redaka vraćeno: 1

SHOW TABLES LIKE "ubnex_virtuemart_configs"

Objašnjenje

OBJAŠNJENJE što je nemoguće kod upita: SHOW TABLES LIKE "ubnex_virtuemart_configs"

Profil

Status	Duration
starting	0.30 ms
Executing hook on transaction	0.02 ms
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	1.99 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.25 ms
preparing	0.07 ms
Creating tmp table	0.12 ms
executing	0.96 ms
checking permissions	0.38 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.03 ms
closing tables	0.04 ms
freeing items	0.14 ms
cleaning up	0.12 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:575
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:933
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.71 ms Nakon posljednjeg upita: 0.08 ms Memorija upita: 0.022 MB memorija prije upita: 4.080 MB Redaka vraćeno: 1

SELECT `config` 
  FROM `ubnex_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_configs	NULL	system	PRIMARY	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	1	100.00	NULL

Profil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.04 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.05 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:981
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.74 ms Nakon posljednjeg upita: 0.49 ms Memorija upita: 0.024 MB memorija prije upita: 4.132 MB Redaka vraćeno: 1

SELECT *

  FROM ubnex_languages

  WHERE published=1

  ORDER BY ordering ASC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_languages	NULL	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	2	50.00	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.10 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
15	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:77
14	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:64
13	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1002
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.36 ms Nakon posljednjeg upita: 0.30 ms Memorija upita: 0.029 MB memorija prije upita: 4.150 MB Redaka vraćeno: 42

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `ubnex_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_customfilters','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_assets	NULL	ALL	idx_asset_name	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	133	33.83	Using where

Profil

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.23 ms
preparing	0.04 ms
executing	0.39 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.05 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1342
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1003
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.01 ms Nakon posljednjeg upita: 2.22 ms Memorija upita: 0.022 MB memorija prije upita: 4.243 MB Redaka vraćeno: 1

SELECT `id` 
  FROM `ubnex_menu` 
  WHERE `home`="1" 
  and (language="*" or language = "hr-HR" ) 
  ORDER BY `language` DESC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_menu	NULL	ALL	idx_language	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	138	7.03	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.20 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:814
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.40 ms Nakon posljednjeg upita: 0.09 ms Memorija upita: 0.023 MB memorija prije upita: 4.251 MB Redaka vraćeno: 2

SELECT * 
  FROM `ubnex_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "hr-HR" ) 
  AND ( access="1" )  
  ORDER BY `language` DESC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_menu	NULL	ALL	idx_client_id_parent_id_alias_language,idx_language	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	138	0.72	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.56 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.15 ms
cleaning up	0.05 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1229
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:821
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.68 ms Nakon posljednjeg upita: 0.18 ms Memorija upita: 0.022 MB memorija prije upita: 4.264 MB Redaka vraćeno: 1

SELECT l.virtuemart_product_id  
  FROM `ubnex_virtuemart_products_hr_hr` as l  
  WHERE l.slug = "caterpillar-dp50"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	const	slug	slug	578	const	1	100.00	NULL

Profil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.05 ms
optimizing	0.05 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.04 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1165
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1115
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:671
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.36 ms Nakon posljednjeg upita: 42.01 ms Memorija upita: 0.024 MB memorija prije upita: 4.839 MB Redaka vraćeno: 1

SELECT * 
  FROM `ubnex_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_shoppergroups	NULL	ref	virtuemart_vendor_id,shared,published	published	1	const	3	25.00	Using where

Profil

Status	Duration
starting	0.39 ms
Executing hook on transaction	0.03 ms
starting	0.03 ms
checking permissions	0.03 ms
Opening tables	0.10 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.12 ms
preparing	0.11 ms
executing	0.10 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.07 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1395
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.71 ms Nakon posljednjeg upita: 0.14 ms Memorija upita: 0.025 MB memorija prije upita: 4.869 MB Redaka vraćeno: 1

SELECT `ubnex_virtuemart_shoppergroups`.*  
  FROM `ubnex_virtuemart_shoppergroups`  
  WHERE `ubnex_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

Objašnjenje

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

Profil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.04 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.04 ms
executing	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1022
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1395
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.01 ms Nakon posljednjeg upita: 2.06 ms Memorija upita: 0.023 MB memorija prije upita: 4.908 MB Redaka vraćeno: 1

SELECT `ubnex_virtuemart_products`.* ,`ubnex_virtuemart_products_hr_hr`.*  
  FROM `ubnex_virtuemart_products` 
  INNER JOIN `ubnex_virtuemart_products_hr_hr` using (`virtuemart_product_id`) 
  WHERE `ubnex_virtuemart_products`.`virtuemart_product_id` = "2725"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ubnex_virtuemart_products_hr_hr	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.14 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.05 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1423
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.76 ms Nakon posljednjeg upita: 1.49 ms Memorija upita: 0.022 MB memorija prije upita: 4.940 MB Redaka vraćeno: 1

SELECT `virtuemart_media_id` 
  FROM `ubnex_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "2725" 
  ORDER BY `ordering`

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_medias	NULL	ref	virtuemart_product_id,ordering	ordering	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1428
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.66 ms Nakon posljednjeg upita: 0.31 ms Memorija upita: 0.022 MB memorija prije upita: 4.962 MB Redaka vraćeno: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `ubnex_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "2725"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.02 ms
end	0.02 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1431
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.94 ms Nakon posljednjeg upita: 0.13 ms Memorija upita: 0.023 MB memorija prije upita: 4.969 MB Redaka vraćeno: 0

SELECT * 
  FROM `ubnex_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "2725"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-10-07 10:09:42" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-10-07 10:09:42" ) ) 
  ORDER BY `product_price` DESC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_prices	NULL	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	5.00	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.04 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.07 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1246
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1446
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.64 ms Nakon posljednjeg upita: 0.32 ms Memorija upita: 0.022 MB memorija prije upita: 4.986 MB Redaka vraćeno: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `ubnex_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "2725"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.02 ms
end	0.02 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.67 ms Nakon posljednjeg upita: 0.06 ms Memorija upita: 0.023 MB memorija prije upita: 4.994 MB Redaka vraćeno: 1

SELECT * 
  FROM `ubnex_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 2725

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_categories	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.05 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1689
13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1666
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1466
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.83 ms Nakon posljednjeg upita: 0.87 ms Memorija upita: 0.023 MB memorija prije upita: 5.028 MB Redaka vraćeno: 1

SELECT `ubnex_virtuemart_categories`.* ,`ubnex_virtuemart_categories_hr_hr`.*  
  FROM `ubnex_virtuemart_categories` 
  INNER JOIN `ubnex_virtuemart_categories_hr_hr` using (`virtuemart_category_id`) 
  WHERE `ubnex_virtuemart_categories`.`virtuemart_category_id` = "14"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ubnex_virtuemart_categories_hr_hr	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1670
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1466
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.34 ms Nakon posljednjeg upita: 3.61 ms Memorija upita: 0.031 MB memorija prije upita: 5.127 MB Redaka vraćeno: 15

SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
		
  FROM `ubnex_virtuemart_customs` AS c 
  LEFT JOIN `ubnex_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE field.`virtuemart_product_id` IN (2725) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	field	NULL	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_product_id	4	const	14	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,published	PRIMARY	4	vilstroj_joomla_singlepage_new.field.virtuemart_custom_id	1	98.11	Using index condition; Using where

Profil

Status	Duration
starting	0.24 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.05 ms
executing	0.37 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:150
12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2619
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.17 ms Nakon posljednjeg upita: 28.79 ms Memorija upita: 0.025 MB memorija prije upita: 5.211 MB Redaka vraćeno: 1

SELECT *  
  FROM `ubnex_virtuemart_currencies` AS c
			
  LEFT JOIN `ubnex_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency
			
  WHERE v.virtuemart_vendor_id = "1"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v	NULL	system	PRIMARY,vendor_currency	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.34 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.13 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.11 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2626
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.73 ms Nakon posljednjeg upita: 1.57 ms Memorija upita: 0.025 MB memorija prije upita: 5.249 MB Redaka vraćeno: 1

SELECT `ubnex_virtuemart_currencies`.*  
  FROM `ubnex_virtuemart_currencies`  
  WHERE `ubnex_virtuemart_currencies`.`virtuemart_currency_id` = "47"

Objašnjenje

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

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.04 ms
executing	0.06 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1022
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2626
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 7.80 ms Nakon posljednjeg upita: 11.73 ms Memorija upita: 0.036 MB memorija prije upita: 5.368 MB Redaka vraćeno: 31

SHOW FULL COLUMNS  
  FROM `ubnex_virtuemart_userfields`

Objašnjenje

OBJAŠNJENJE što je nemoguće kod upita: SHOW FULL COLUMNS FROM `ubnex_virtuemart_userfields`

Profil

Status	Duration
starting	0.38 ms
Executing hook on transaction	0.03 ms
starting	1.95 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
Opening tables	2.32 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.06 ms
statistics	0.22 ms
preparing	0.07 ms
Creating tmp table	0.11 ms
executing	0.14 ms
checking permissions	0.12 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.08 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.09 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.07 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.10 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.14 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.04 ms
closing tables	0.05 ms
freeing items	0.14 ms
cleaning up	0.10 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:662
23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:219
21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434
20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396
19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602
18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:52
17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554
16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:251
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2626
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.17 ms Nakon posljednjeg upita: 0.22 ms Memorija upita: 0.037 MB memorija prije upita: 5.407 MB Redaka vraćeno: 21

SELECT * 
  FROM `ubnex_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type') = 0  
  ORDER BY ordering

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_userfields	NULL	ref	published,account	account	1	const	22	89.29	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.03 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.33 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.05 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:501
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2626
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.71 ms Nakon posljednjeg upita: 0.29 ms Memorija upita: 0.025 MB memorija prije upita: 5.464 MB Redaka vraćeno: 2

SELECT `fieldtitle`, `fieldvalue` 
  FROM `ubnex_virtuemart_userfield_values` 
  WHERE `virtuemart_userfield_id` = 23 
  ORDER BY `ordering`

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_userfield_values	NULL	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	100.00	Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1037
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2626
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 2.73 ms Nakon posljednjeg upita: 3.09 ms Memorija upita: 0.096 MB memorija prije upita: 5.504 MB Redaka vraćeno: 245

SELECT * 
  FROM `ubnex_virtuemart_countries`
 
  WHERE `published` = 1

 
  ORDER BY country_name ASC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_countries	NULL	ALL	published	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	245	99.18	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.04 ms
executing	2.03 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.04 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
19	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
18	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146
17	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:848
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2626
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.14 ms Nakon posljednjeg upita: 4.94 ms Memorija upita: 0.033 MB memorija prije upita: 5.812 MB Redaka vraćeno: 14

SELECT * 
  FROM `ubnex_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `shipment`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_userfields	NULL	ref	published,shipment	shipment	1	const	14	89.29	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.23 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.26 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:507
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2626
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.04 ms Nakon posljednjeg upita: 3.99 ms Memorija upita: 0.024 MB memorija prije upita: 5.895 MB Redaka vraćeno: 4

SELECT c.* 
  FROM ubnex_virtuemart_calcs as c 
  LEFT JOIN ubnex_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id 
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-10-07 10:09:42" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-07 10:09:42" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cs	NULL	system	virtuemart_calc_id	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	0	0.00	const row not found
1	SIMPLE	c	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	3	43.75	Using where

Profil

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.08 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:184
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2626
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.98 ms Nakon posljednjeg upita: 12.20 ms Memorija upita: 0.023 MB memorija prije upita: 6.011 MB Redaka vraćeno: 1

SELECT `ubnex_virtuemart_medias`.*  
  FROM `ubnex_virtuemart_medias`  
  WHERE `ubnex_virtuemart_medias`.`virtuemart_media_id` = "3137"

Objašnjenje

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

Profil

Status	Duration
starting	0.31 ms
Executing hook on transaction	0.03 ms
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:421
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1187
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:137
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 14.26 ms Nakon posljednjeg upita: 0.57 ms Memorija upita: 0.022 MB memorija prije upita: 6.026 MB Redaka vraćeno: 1

SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering 
  FROM `ubnex_virtuemart_products` as p 
  LEFT JOIN `ubnex_virtuemart_products_hr_hr` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `ubnex_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `ubnex_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
  WHERE ( `pc`.`virtuemart_category_id` = 14 
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="2725"  
  AND `pc`.ordering <= "0"  
  ORDER BY `pc`.`ordering` DESC, `product_name` DESC 
  LIMIT 1

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps	NULL	system	virtuemart_product_id	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	0	0.00	const row not found
1	SIMPLE	pc	NULL	ALL	virtuemart_product_id,ordering	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	671	9.99	Using where; Using temporary; Korištenje sortiranja datoteka
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	vilstroj_joomla_singlepage_new.pc.virtuemart_product_id	1	97.33	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	vilstroj_joomla_singlepage_new.pc.virtuemart_product_id	1	100.00	NULL

Profil

Status	Duration
starting	0.25 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.19 ms
preparing	0.07 ms
Creating tmp table	0.10 ms
executing	12.88 ms
end	0.16 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.07 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1986
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 11.45 ms Nakon posljednjeg upita: 0.12 ms Memorija upita: 0.022 MB memorija prije upita: 6.033 MB Redaka vraćeno: 1

SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering 
  FROM `ubnex_virtuemart_products` as p 
  LEFT JOIN `ubnex_virtuemart_products_hr_hr` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `ubnex_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `ubnex_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
  WHERE ( `pc`.`virtuemart_category_id` = 14 
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="2725" 
  AND p.`virtuemart_product_id`!="2238" 
  AND `pc`.ordering >= "0"  
  ORDER BY `pc`.`ordering` ASC, `product_name` ASC 
  LIMIT 1

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps	NULL	system	virtuemart_product_id	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	0	0.00	const row not found
1	SIMPLE	pc	NULL	ALL	virtuemart_product_id,ordering	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	671	9.99	Using where; Using temporary; Korištenje sortiranja datoteka
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	vilstroj_joomla_singlepage_new.pc.virtuemart_product_id	1	97.33	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	vilstroj_joomla_singlepage_new.pc.virtuemart_product_id	1	100.00	NULL

Profil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.16 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	10.43 ms
end	0.09 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.09 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1986
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.81 ms Nakon posljednjeg upita: 8.57 ms Memorija upita: 0.022 MB memorija prije upita: 6.140 MB Redaka vraćeno: 0

SELECT `virtuemart_media_id` 
  FROM `ubnex_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "14" 
  ORDER BY `ordering`

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.23 ms
Executing hook on transaction	0.03 ms
starting	0.04 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
init	0.03 ms
System lock	0.05 ms
optimizing	0.05 ms
statistics	0.04 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.05 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:87
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:195
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.78 ms Nakon posljednjeg upita: 0.09 ms Memorija upita: 0.022 MB memorija prije upita: 6.143 MB Redaka vraćeno: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  ubnex_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 14

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	category_parent_id,category_child_id	category_child_id	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.09 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
11	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:716
10	VirtueMartModelCategory->getParentsList()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:196
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.71 ms Nakon posljednjeg upita: 0.10 ms Memorija upita: 0.022 MB memorija prije upita: 6.151 MB Redaka vraćeno: 1

SELECT l.virtuemart_category_id, l.category_name  
  FROM `ubnex_virtuemart_categories_hr_hr` as l  
  WHERE l.virtuemart_category_id = 14

Objašnjenje

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

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:735
10	VirtueMartModelCategory->getParentsList()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:196
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.28 ms Nakon posljednjeg upita: 36.48 ms Memorija upita: 0.023 MB memorija prije upita: 6.397 MB Redaka vraćeno: 1

SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM ubnex_virtuemart_shipmentmethods as i 
 
  LEFT JOIN `ubnex_virtuemart_shipmentmethods_hr_hr` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
 
  LEFT JOIN `ubnex_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `ubnex_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE i.`published` = "1" 
  AND j.`element` = "weight_countries"
	    						
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_shipmentmethod_id` 
  ORDER BY i.`ordering`

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	system	shipment_jplugin_id	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	1	100.00	NULL
1	SIMPLE	s	NULL	system	virtuemart_shipmentmethod_id	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	0	0.00	const row not found
1	SIMPLE	l	NULL	system	PRIMARY	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	1	100.00	NULL
1	SIMPLE	j	NULL	const	PRIMARY,element_clientid,element_folder_clientid	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.34 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.16 ms
preparing	0.04 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.08 ms
freeing items	0.08 ms
cleaning up	0.04 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526
13	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:424
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:340
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.01 ms Nakon posljednjeg upita: 10.53 ms Memorija upita: 0.028 MB memorija prije upita: 6.998 MB Redaka vraćeno: 1

SELECT `ubnex_virtuemart_products`.* ,`ubnex_virtuemart_products_hr_hr`.*  
  FROM `ubnex_virtuemart_products` 
  INNER JOIN `ubnex_virtuemart_products_hr_hr` using (`virtuemart_product_id`) 
  WHERE `ubnex_virtuemart_products`.`virtuemart_product_id` = "2238"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ubnex_virtuemart_products_hr_hr	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.06 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
24	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1423
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:285
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.57 ms Nakon posljednjeg upita: 0.25 ms Memorija upita: 0.028 MB memorija prije upita: 7.013 MB Redaka vraćeno: 3

SELECT `virtuemart_media_id` 
  FROM `ubnex_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "2238" 
  ORDER BY `ordering`

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_medias	NULL	ref	virtuemart_product_id,ordering	ordering	4	const	3	100.00	NULL

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.05 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
24	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1428
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:285
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.46 ms Nakon posljednjeg upita: 0.12 ms Memorija upita: 0.027 MB memorija prije upita: 7.029 MB Redaka vraćeno: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `ubnex_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "2238"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
24	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1431
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:285
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.74 ms Nakon posljednjeg upita: 0.10 ms Memorija upita: 0.028 MB memorija prije upita: 7.038 MB Redaka vraćeno: 0

SELECT * 
  FROM `ubnex_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "2238"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-10-07 10:09:42" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-10-07 10:09:42" ) ) 
  ORDER BY `product_price` DESC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_prices	NULL	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	5.00	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.03 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.04 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
25	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1246
24	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1446
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:285
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.51 ms Nakon posljednjeg upita: 0.16 ms Memorija upita: 0.027 MB memorija prije upita: 7.050 MB Redaka vraćeno: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `ubnex_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "2238"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.03 ms
executing	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
24	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:285
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.51 ms Nakon posljednjeg upita: 0.08 ms Memorija upita: 0.028 MB memorija prije upita: 7.061 MB Redaka vraćeno: 1

SELECT * 
  FROM `ubnex_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 2238

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_categories	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1689
25	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1666
24	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1466
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:285
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.93 ms Nakon posljednjeg upita: 0.66 ms Memorija upita: 0.028 MB memorija prije upita: 7.107 MB Redaka vraćeno: 1

SELECT `ubnex_virtuemart_products`.* ,`ubnex_virtuemart_products_hr_hr`.*  
  FROM `ubnex_virtuemart_products` 
  INNER JOIN `ubnex_virtuemart_products_hr_hr` using (`virtuemart_product_id`) 
  WHERE `ubnex_virtuemart_products`.`virtuemart_product_id` = "2798"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ubnex_virtuemart_products_hr_hr	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
24	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1423
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:291
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.64 ms Nakon posljednjeg upita: 0.26 ms Memorija upita: 0.028 MB memorija prije upita: 7.121 MB Redaka vraćeno: 1

SELECT `virtuemart_media_id` 
  FROM `ubnex_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "2798" 
  ORDER BY `ordering`

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_medias	NULL	ref	virtuemart_product_id,ordering	ordering	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
24	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1428
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:291
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.44 ms Nakon posljednjeg upita: 0.14 ms Memorija upita: 0.027 MB memorija prije upita: 7.137 MB Redaka vraćeno: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `ubnex_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "2798"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
24	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1431
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:291
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.72 ms Nakon posljednjeg upita: 0.09 ms Memorija upita: 0.028 MB memorija prije upita: 7.147 MB Redaka vraćeno: 0

SELECT * 
  FROM `ubnex_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "2798"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-10-07 10:09:42" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-10-07 10:09:42" ) ) 
  ORDER BY `product_price` DESC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_prices	NULL	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	5.00	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1227
25	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1246
24	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1446
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:291
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.51 ms Nakon posljednjeg upita: 0.17 ms Memorija upita: 0.027 MB memorija prije upita: 7.158 MB Redaka vraćeno: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `ubnex_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "2798"

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.05 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.02 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
24	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1450
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:291
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.48 ms Nakon posljednjeg upita: 0.07 ms Memorija upita: 0.028 MB memorija prije upita: 7.170 MB Redaka vraćeno: 1

SELECT * 
  FROM `ubnex_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 2798

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ubnex_virtuemart_product_categories	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1689
25	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1666
24	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1466
23	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1029
22	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:1028
21	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:211
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php:291
12	include JROOT/templates/flex/html/com_virtuemart/productdetails/vilstroj.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:368
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

41 Tipova upita zapisano, razvrstani su prema broju pojavljivanja.

ODABERI tablice:

3 × SELECT `virtuemart_media_id` 
  FROM `ubnex_virtuemart_product_medias`

3 × SELECT `virtuemart_manufacturer_id` 
  FROM `ubnex_virtuemart_product_manufacturers`

3 × SELECT `virtuemart_shoppergroup_id` 
  FROM `ubnex_virtuemart_product_shoppergroups`

3 × SELECT * 
  FROM `ubnex_virtuemart_product_categories`

3 × SELECT `ubnex_virtuemart_products`.* ,`ubnex_virtuemart_products_hr_hr`.*  
  FROM `ubnex_virtuemart_products` 
  INNER JOIN `ubnex_virtuemart_products_hr_hr` using (`virtuemart_product_id`)

3 × SELECT * 
  FROM `ubnex_virtuemart_product_prices`

2 × SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering 
  FROM `ubnex_virtuemart_products` as p 
  LEFT JOIN `ubnex_virtuemart_products_hr_hr` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
  LEFT JOIN `ubnex_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `ubnex_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`

2 × SELECT id, home, template, s.params 
  FROM ubnex_template_styles as s 
  LEFT JOIN ubnex_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

2 × SELECT * 
  FROM `ubnex_virtuemart_userfields`

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

1 × SELECT `ubnex_virtuemart_medias`.*  
  FROM `ubnex_virtuemart_medias`

1 × SELECT c.* 
  FROM ubnex_virtuemart_calcs as c 
  LEFT JOIN ubnex_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT `virtuemart_media_id` 
  FROM `ubnex_virtuemart_category_medias`

1 × SELECT `fieldtitle`, `fieldvalue` 
  FROM `ubnex_virtuemart_userfield_values`

1 × SELECT `ubnex_virtuemart_currencies`.*  
  FROM `ubnex_virtuemart_currencies`

1 × SELECT *  
  FROM `ubnex_virtuemart_currencies` AS c    
  LEFT JOIN `ubnex_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency

1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,   c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,   field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`   
  FROM `ubnex_virtuemart_customs` AS c 
  LEFT JOIN `ubnex_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT `ubnex_virtuemart_categories`.* ,`ubnex_virtuemart_categories_hr_hr`.*  
  FROM `ubnex_virtuemart_categories` 
  INNER JOIN `ubnex_virtuemart_categories_hr_hr` using (`virtuemart_category_id`)

1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  ubnex_virtuemart_category_categories AS `xref`

1 × SELECT l.virtuemart_category_id, l.category_name  
  FROM `ubnex_virtuemart_categories_hr_hr` as l

1 × SELECT * 
  FROM `ubnex_virtuemart_countries`

1 × SELECT `data` 
  FROM `ubnex_session`

1 × SELECT `session_id` 
  FROM `ubnex_session`

1 × SELECT `ubnex_virtuemart_shoppergroups`.*  
  FROM `ubnex_virtuemart_shoppergroups`

1 × SELECT * 
  FROM `ubnex_virtuemart_shoppergroups`

1 × SELECT l.virtuemart_product_id  
  FROM `ubnex_virtuemart_products_hr_hr` as l

```
1 × SELECT * 
  FROM `ubnex_menu`
```
```
1 × SELECT `id` 
  FROM `ubnex_menu`
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ubnex_assets`

```
1 × SELECT * 
  FROM ubnex_languages
```

1 × SELECT `config` 
  FROM `ubnex_virtuemart_configs`

1 × SELECT `template` 
  FROM `ubnex_template_styles`

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

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

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

1 × SELECT id, rules 
  FROM `ubnex_viewlevels

1 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,    j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM ubnex_virtuemart_shipmentmethods as i   
  LEFT JOIN `ubnex_virtuemart_shipmentmethods_hr_hr` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`   
  LEFT JOIN `ubnex_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`    
  LEFT 
  OUTER JOIN `ubnex_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`

OSTALE tablice:

1 × INSERT INTO `ubnex_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3438343538396630313336633463343131666339393139363630646631353837', 1, 1728295782, 0, '', 0

1 × UPDATE `ubnex_extensions` 
  SET `params` = '{\"mediaversion\":\"cd9245279e4711f7f8d1ba8e634e4ace\"}'

1 × SHOW TABLES LIKE "ubnex_virtuemart_configs

1 × SHOW FULL COLUMNS  
  FROM `ubnex_virtuemart_userfields

CATERPILLAR DP50

Joomla! Debug konzola

Sesija

Informacije profila

Vrijeme

Memorija

Korištenje Memorije

Upiti baze podataka

57 Upita zapisano 88.86 ms

2 duplikata pronađeno!

41 Tipova upita zapisano, razvrstani su prema broju pojavljivanja.

ODABERI tablice:

OSTALE tablice: