Name: Kutyajáték húzós kosár labda, 7,5x20cm
SKU: DBKF-XEH25216541
Price: 1752 HUF
Availability: InStock

(A kép csak illusztráció!)

Cikkszám:

DBKF-XEH25216541

Bruttó ár / db:

1 752 Ft

Kategória:

Játék kutyáknak

1 752 Ft

Megosztom ...

Csatlakozz hozzánk, kövess minket!

Keress minket

+36 30 747 8504

info@blackcicus.hu

+36 30 747 8504

Információk

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1773482252,
                "last": 1773482252,
                "now": 1773482252
            },
            "token": "3g4UEXSmKz6a6Z4fSENMYqBXNXktjzfN"
        },
        "registry": {
            "mod_vp_mini_cart": {
                "option": "com_virtuemart",
                "view": "productdetails"
            },
            "com_vpadvanceduser": {
                "login": {
                    "form": {
                        "data": []
                    }
                }
            },
            "proopc": {
                "lastvisited": {
                    "url": "https://blackcicus.hu/haziallat/kutya/jatek-kutyaknak/kutyajatek-huzos-kosar-labda-75x20cm"
                }
            }
        },
        "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
        }
    },
    "__vm": {
        "vmlastvisitedItemid": 254,
        "vmcartlastVendorId": 1,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":1,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":[],\"ST\":{\"address_type_name\":\"C\\u00edm tetsz\\u0151leges c\\u00edmk\\u00e9je\"},\"cartfields\":[],\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"hu-HU\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"OrderIdOrderDone\":false,\"orderdoneHtml\":false,\"virtuemart_order_id\":false,\"byDefaultBT\":[],\"byDefaultST\":{\"address_type_name\":1},\"productCartLoaded\":[],\"loadedCart\":true,\"lastAddedProduct\":0}",
        "vmlastvisitedcategoryid": 32,
        "vmlastvisitedproductids": [
            93
        ]
    }
}

Profilinformációk

Idő

Memória

Idő: 12.78 ms / 12.78 ms Memória: 2.019 MB / 2.40 MB Application: afterLoad

Idő: 50.61 ms / 63.39 ms Memória: 6.415 MB / 8.81 MB Application: afterInitialise

Idő: 31.52 ms / 94.92 ms Memória: 4.890 MB / 13.70 MB Application: Before Access::preloadComponents (all components)

Idő: 0.56 ms / 95.48 ms Memória: 0.071 MB / 13.78 MB Application: After Access::preloadComponents (all components)

Idő: 0.02 ms / 95.49 ms Memória: -0.003 MB / 13.77 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Idő: 0.36 ms / 95.85 ms Memória: 0.026 MB / 13.80 MB Application: After Access::getAssetRules (id:1 name:root.1)

Idő: 0.02 ms / 95.87 ms Memória: 0.001 MB / 13.80 MB Application: Before Access::getAssetRules (id:61 name:com_virtuemart)

Idő: 0.01 ms / 95.88 ms Memória: 0.002 MB / 13.80 MB Application: After Access::getAssetRules (id:61 name:com_virtuemart)

Idő: 22.06 ms / 117.94 ms Memória: 1.754 MB / 15.55 MB Application: afterRoute

Idő: 0.44 ms / 118.38 ms Memória: 0.017 MB / 15.57 MB Application: beforeRenderComponent com_virtuemart

Idő: 84.61 ms / 202.99 ms Memória: 7.982 MB / 23.55 MB Application: afterRenderComponent com_virtuemart

Idő: 5.33 ms / 208.31 ms Memória: 0.459 MB / 24.01 MB Application: afterDispatch

Idő: 14.83 ms / 223.15 ms Memória: 0.978 MB / 24.99 MB Application: beforeRenderModule mod_smartlook (Smartlook)

Idő: 1.50 ms / 224.65 ms Memória: 0.093 MB / 25.08 MB Application: afterRenderModule mod_smartlook (Smartlook)

Idő: 0.94 ms / 225.58 ms Memória: 0.026 MB / 25.11 MB Application: beforeRenderModule mod_menu (Információk)

Idő: 3.23 ms / 228.81 ms Memória: 0.089 MB / 25.20 MB Application: afterRenderModule mod_menu (Információk)

Idő: 0.31 ms / 229.12 ms Memória: -0.024 MB / 25.17 MB Application: beforeRenderModule mod_acym (Érdekelnek az újdonságok, árváltozások, kedvezmények? Iratkozz fel.)

Idő: 6.35 ms / 235.47 ms Memória: 0.546 MB / 25.72 MB Application: afterRenderModule mod_acym (Érdekelnek az újdonságok, árváltozások, kedvezmények? Iratkozz fel.)

Idő: 0.32 ms / 235.79 ms Memória: 0.004 MB / 25.73 MB Application: beforeRenderModule mod_vp_ajax_search (VP Ajax Product Search)

Idő: 1.35 ms / 237.14 ms Memória: 0.055 MB / 25.78 MB Application: afterRenderModule mod_vp_ajax_search (VP Ajax Product Search)

Idő: 0.31 ms / 237.44 ms Memória: -0.033 MB / 25.75 MB Application: beforeRenderModule mod_vp_mini_cart (VP Mini Cart)

Idő: 2.53 ms / 239.97 ms Memória: 0.160 MB / 25.91 MB Application: afterRenderModule mod_vp_mini_cart (VP Mini Cart)

Idő: 0.05 ms / 240.02 ms Memória: -0.005 MB / 25.90 MB Application: beforeRenderModule mod_vpadvanceduser (Teszt login form)

Idő: 14.13 ms / 254.15 ms Memória: 1.073 MB / 26.98 MB Application: afterRenderModule mod_vpadvanceduser (Teszt login form)

Idő: 42.74 ms / 296.89 ms Memória: 5.069 MB / 32.04 MB Application: afterRender

Adatbázislekérdezés összesen: 20.69 ms

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Lekérdezés ideje: 0.23 ms Utolsó lekérdezés után: 4.02 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 4.829 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `h207m_viewlevels`

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.23 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 4.842 MB Visszaadott sorok: 2

SELECT b.id

  FROM h207m_usergroups AS a

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

  WHERE a.id = 9

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.34 ms Utolsó lekérdezés után: 29.15 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 8.609 MB Visszaadott sorok: 1

SELECT `value` 
  FROM h207m_acym_configuration 
  WHERE `name` = 'level'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_acym_configuration	const	PRIMARY	PRIMARY	767	const	1

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/acymtriggers/acymtriggers.php:639
10	plgSystemAcymtriggers->getAcyConf()	JROOT/plugins/system/acymtriggers/acymtriggers.php:655
9	plgSystemAcymtriggers->handleCron()	JROOT/plugins/system/acymtriggers/acymtriggers.php:344
8	plgSystemAcymtriggers->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

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

Lekérdezés ideje: 0.48 ms Utolsó lekérdezés után: 31.57 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 13.605 MB Visszaadott sorok: 1

SHOW TABLES LIKE "h207m_virtuemart_configs"

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW TABLES LIKE "h207m_virtuemart_configs"

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:824
15	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:592
14	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:405
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:220
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:339
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:137
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

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

Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 13.613 MB Visszaadott sorok: 1

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

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:454
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:220
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:339
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:137
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

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

Lekérdezés ideje: 0.38 ms Utolsó lekérdezés után: 0.65 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 13.712 MB Visszaadott sorok: 46

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

  FROM `h207m_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_akeeba','com_associations','com_baforms','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gsd','com_imagerecycle','com_imageway2enjoy','com_installer','com_jchoptimize','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_tagmeta','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_vm_map','com_vmcustomadvanced','com_vpadvanceduser','com_wrapper')

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_assets	ALL	idx_asset_name	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	151	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
15	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:103
14	VmConfig::showDebug()	JROOT/administrator/components/com_virtuemart/helpers/config.php:476
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:220
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:339
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:137
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

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

Lekérdezés ideje: 0.36 ms Utolsó lekérdezés után: 2.80 ms Memória lekérdezése: 0.042 MB memória a lekérdezés előtt: 14.013 MB Visszaadott sorok: 9

SELECT * 
  FROM `h207m_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and (language="*" or language = "hu-HU" )  
  AND client_id=0 
  AND published=1 
  AND ( access="1" OR access="5" )  
  ORDER BY `language` DESC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	107	Using where; Fájlrendezés használata

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1648
14	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:320
13	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:286
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:339
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:137
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

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

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

SELECT l.virtuemart_product_id  
  FROM `h207m_virtuemart_products_hu_hu` as l  
  WHERE l.slug = "kutyajatek-huzos-kosar-labda-75x20cm"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	const	slug	slug	766	const	1	Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1574
13	vmrouterHelper::getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1511
12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1158
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:141
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

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

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

SELECT l.virtuemart_category_id  
  FROM `h207m_virtuemart_categories_hu_hu` as l  
  WHERE l.slug = "jatek-kutyaknak"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	const	slug	slug	766	const	1	Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1574
14	vmrouterHelper::getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1368
13	vmrouterHelper::getCategoryId()	JROOT/components/com_virtuemart/router.php:1515
12	vmrouterHelper::getProductId()	JROOT/components/com_virtuemart/router.php:1158
11	vmrouterHelper::parseRoute()	JROOT/components/com_virtuemart/router.php:141
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

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

Lekérdezés ideje: 0.34 ms Utolsó lekérdezés után: 3.55 ms Memória lekérdezése: 0.007 MB memória a lekérdezés előtt: 14.390 MB

UPDATE `h207m_extensions`

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

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

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
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/vponepagecheckout/cart/helper.php:72
10	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
9	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
8	plgSystemVPOnePageCheckout->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM `h207m_extensions`

  WHERE `type` = 'package' 
  AND `element` = 'pkg_vp_smart' 
  AND `enabled` = '1'

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/vpframework/helpers/dlk.php:948
12	VPFrameworkDlk->loadInfo()	JROOT/plugins/system/vpframework/helpers/dlk.php:98
11	VPFrameworkDlk->__construct()	JROOT/plugins/system/vpframework/helpers/dlk.php:127
10	VPFrameworkDlk::getInstance()	JROOT/plugins/system/vpframework/helper.php:204
9	plgSystemVPFrameworkHelper->initialize()	JROOT/plugins/system/vpframework/vpframework.php:85
8	plgSystemVPFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.22 ms Utolsó lekérdezés után: 0.23 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 15.388 MB Visszaadott sorok: 2

SELECT title, module AS name

  FROM h207m_modules

  WHERE published = 1 
  AND module IN ('mod_virtuemart_category','mod_virtuemart_search')

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_modules	range	published,newsfeeds	newsfeeds	204	NULL	3	Using index condition

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/vpframework/helper.php:684
9	plgSystemVPFrameworkHelper->manageModuleCache()	JROOT/plugins/system/vpframework/vpframework.php:102
8	plgSystemVPFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.55 ms Utolsó lekérdezés után: 1.14 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 15.488 MB Visszaadott sorok: 19

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

  FROM h207m_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-03-14 09:57:32') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-14 09:57:32') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 254 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
10	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/plugins/system/vpframework/helper.php:701
9	plgSystemVPFrameworkHelper->manageModuleCache()	JROOT/plugins/system/vpframework/vpframework.php:102
8	plgSystemVPFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT element, folder

  FROM h207m_extensions

  WHERE type = 'component' 
  AND element = 'com_virtuemart' 
  AND enabled = 1

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/vpframework/helpers/utility.php:258
10	VPFrameworkUtility::hasExtension()	JROOT/plugins/system/vpframework/helper.php:1320
9	plgSystemVPFrameworkHelper->manageWishlist()	JROOT/plugins/system/vpframework/vpframework.php:108
8	plgSystemVPFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.23 ms Utolsó lekérdezés után: 18.43 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 17.738 MB Visszaadott sorok: 1

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	2	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:190
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
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:133
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

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

Lekérdezés ideje: 0.29 ms Utolsó lekérdezés után: 0.91 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 17.772 MB Visszaadott sorok: 1

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

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1133
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1156
16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:109
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:190
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
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:133
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

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

Lekérdezés ideje: 0.54 ms Utolsó lekérdezés után: 1.50 ms Memória lekérdezése: 0.034 MB memória a lekérdezés előtt: 17.976 MB Visszaadott sorok: 33

SHOW FULL COLUMNS  
  FROM `h207m_virtuemart_userfields`

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:785
19	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
18	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:239
17	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:441
16	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:403
15	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:615
14	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
13	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:567
12	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:373
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:257
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
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:133
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

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

Lekérdezés ideje: 0.30 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 18.016 MB Visszaadott sorok: 15

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_userfields	ALL	published,account	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	30	Using where; Fájlrendezés használata

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:512
14	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:557
13	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:438
12	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:414
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:257
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
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:133
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

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

Lekérdezés ideje: 0.28 ms Utolsó lekérdezés után: 1.74 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 18.195 MB Visszaadott sorok: 8

SELECT * 
  FROM `h207m_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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_userfields	index_merge	published,shipment	shipment,published	1,1	NULL	5	Using intersect(shipment,published); Using where; Fájlrendezés használata

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:512
14	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:557
13	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:444
12	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:414
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:257
10	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
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:133
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

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

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.90 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 18.349 MB Visszaadott sorok: 1

SELECT `h207m_virtuemart_products`.* ,`h207m_virtuemart_products_hu_hu`.*  
  FROM `h207m_virtuemart_products` 
  INNER JOIN `h207m_virtuemart_products_hu_hu` 
  ON `h207m_virtuemart_products`.`virtuemart_product_id` = `h207m_virtuemart_products_hu_hu`.`virtuemart_product_id`  
  WHERE `h207m_virtuemart_products`.`virtuemart_product_id` = "93"

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1133
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1769
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1294
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 0.45 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 18.414 MB Visszaadott sorok: 2

SELECT `virtuemart_media_id` 
  FROM `h207m_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "93"  
  ORDER BY `ordering`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	2	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1802
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1294
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.13 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 18.438 MB Visszaadott sorok: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `h207m_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "93"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_product_shoppergroups	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1814
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1294
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

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

SELECT * 
  FROM `h207m_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "93"  
  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` <= "2026-03-14 10:57:32" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-03-14 10:57:32" ) ) 
  ORDER BY `product_price` DESC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_product_prices	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	Using where; Fájlrendezés használata

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1578
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1602
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1832
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1294
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 18.467 MB Visszaadott sorok: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `h207m_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "93"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_product_manufacturers	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1841
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1294
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 18.470 MB Visszaadott sorok: 1

SELECT * 
  FROM `h207m_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 93

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_product_categories	ref	virtuemart_product_id,virtuemart_product_id_uid	virtuemart_product_id	4	const	1

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:2175
13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:2152
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1853
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1294
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

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

SELECT `h207m_virtuemart_categories`.* ,`h207m_virtuemart_categories_hu_hu`.*  
  FROM `h207m_virtuemart_categories` 
  INNER JOIN `h207m_virtuemart_categories_hu_hu` 
  ON `h207m_virtuemart_categories`.`virtuemart_category_id` = `h207m_virtuemart_categories_hu_hu`.`virtuemart_category_id`  
  WHERE `h207m_virtuemart_categories`.`virtuemart_category_id` = "32"

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1133
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:2156
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1853
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1294
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.25 ms Utolsó lekérdezés után: 1.74 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 18.823 MB Visszaadott sorok: 0

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.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, 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.`noninheritable`, field.`ordering`,
		field.`product_sku`, field.`product_gtin`, field.`product_mpn`
		
  FROM `h207m_virtuemart_customs` AS c 
  LEFT JOIN `h207m_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE field.`virtuemart_product_id` IN (93) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	field	ref	unique_cust_prd_value,virtuemart_product_id,virtuemart_custom_id	virtuemart_product_id	4	const	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	blackcicus_joomla.field.virtuemart_custom_id	1	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:163
11	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1425
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.21 ms Utolsó lekérdezés után: 2.52 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 19.216 MB Visszaadott sorok: 1

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

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:316
16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3294
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1439
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.22 ms Utolsó lekérdezés után: 0.60 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 19.288 MB Visszaadott sorok: 1

SELECT `h207m_virtuemart_currencies`.*  
  FROM `h207m_virtuemart_currencies`  
  WHERE `h207m_virtuemart_currencies`.`virtuemart_currency_id` = "64"

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1133
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1156
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3294
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1439
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.32 ms Utolsó lekérdezés után: 0.50 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 19.377 MB Visszaadott sorok: 1

SELECT c.* 
  FROM h207m_virtuemart_calcs as c  
  LEFT JOIN h207m_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 (  ( ISNULL(`publish_up`) or `publish_up`="0000-00-00 00:00:00")  OR publish_up <= "2026-03-14 08:57:32" )
				
  AND (  ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00")  OR publish_down >= "2026-03-14 08:57:32" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) 
  ORDER BY c.ordering

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where; Fájlrendezés használata
1	SIMPLE	cs	ref	virtuemart_calc_id	virtuemart_calc_id	4	blackcicus_joomla.c.virtuemart_calc_id	1	Using where; Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:174
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:95
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:3294
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1439
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

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

SELECT `virtuemart_manufacturer_id` 
  FROM h207m_virtuemart_calc_manufacturers 
  WHERE `virtuemart_calc_id`="1"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_calc_manufacturers	ref	virtuemart_calc_id	virtuemart_calc_id	4	const	1	Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1392
13	calculationHelper->gatherEffectingRulesForProductPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:380
12	calculationHelper->getProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:3295
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1439
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:78
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:133
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

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

Lekérdezés ideje: 0.21 ms Utolsó lekérdezés után: 0.86 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 19.528 MB Visszaadott sorok: 1

SELECT `h207m_virtuemart_medias`.*  
  FROM `h207m_virtuemart_medias`  
  WHERE `h207m_virtuemart_medias`.`virtuemart_media_id` = "430"

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1133
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:566
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1316
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:159
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:133
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

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

Lekérdezés ideje: 0.16 ms Utolsó lekérdezés után: 2.14 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 19.872 MB Visszaadott sorok: 1

SELECT `h207m_virtuemart_medias`.*  
  FROM `h207m_virtuemart_medias`  
  WHERE `h207m_virtuemart_medias`.`virtuemart_media_id` = "431"

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1133
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:566
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1316
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:159
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:133
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

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

Lekérdezés ideje: 0.52 ms Utolsó lekérdezés után: 5.04 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 20.405 MB Visszaadott sorok: 0

SELECT  c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug  
  FROM h207m_virtuemart_categories as c  
  LEFT JOIN `h207m_virtuemart_categories_hu_hu` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`  
  WHERE  (c.`category_parent_id` = 32) 
  AND  c.`published` = 1  
  ORDER BY c.ordering,category_name ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.c.virtuemart_category_id	1

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:409
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/administrator/components/com_virtuemart/models/category.php:223
12	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/product.php:585
11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:2391
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:180
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:133
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

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

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

SELECT `virtuemart_media_id` 
  FROM `h207m_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "32"  
  ORDER BY `ordering`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:118
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
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:133
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

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

Lekérdezés ideje: 0.16 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 20.496 MB Visszaadott sorok: 1

Duplikált lekérdezések: #47

SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  h207m_virtuemart_categories 
				
  WHERE `virtuemart_category_id`= 32

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1095
13	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1018
12	VirtueMartModelCategory::getParents()	JROOT/administrator/components/com_virtuemart/models/category.php:1001
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:165
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
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:133
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

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

Lekérdezés ideje: 0.13 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 20.504 MB Visszaadott sorok: 1

Duplikált lekérdezések: #43

SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  h207m_virtuemart_categories 
				
  WHERE `virtuemart_category_id`= 23

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1095
14	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1104
13	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1018
12	VirtueMartModelCategory::getParents()	JROOT/administrator/components/com_virtuemart/models/category.php:1001
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:165
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
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:133
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

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

Lekérdezés ideje: 0.16 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 20.513 MB Visszaadott sorok: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `h207m_virtuemart_categories` as c  
  LEFT JOIN `h207m_virtuemart_categories_hu_hu` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 23

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1041
12	VirtueMartModelCategory::getParents()	JROOT/administrator/components/com_virtuemart/models/category.php:1001
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:165
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
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:133
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

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

Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 20.521 MB Visszaadott sorok: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `h207m_virtuemart_categories` as c  
  LEFT JOIN `h207m_virtuemart_categories_hu_hu` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 32

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1041
12	VirtueMartModelCategory::getParents()	JROOT/administrator/components/com_virtuemart/models/category.php:1001
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:165
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:218
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:133
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

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

Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 0.46 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 20.542 MB Visszaadott sorok: 1

Duplikált lekérdezések: #40

SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  h207m_virtuemart_categories 
				
  WHERE `virtuemart_category_id`= 23

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1095
21	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1060
20	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:1282
19	vmrouterHelper::getCategoryRoute()	JROOT/components/com_virtuemart/router.php:419
18	vmrouterHelper::buildRoute()	JROOT/components/com_virtuemart/router.php:128
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:231
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:133
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

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

Lekérdezés ideje: 0.13 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 20.554 MB Visszaadott sorok: 1

SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  h207m_virtuemart_categories 
				
  WHERE `virtuemart_category_id`= 17

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1095
22	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1104
21	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1060
20	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:1282
19	vmrouterHelper::getCategoryRoute()	JROOT/components/com_virtuemart/router.php:419
18	vmrouterHelper::buildRoute()	JROOT/components/com_virtuemart/router.php:128
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:231
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:133
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

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

Lekérdezés ideje: 0.19 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 20.578 MB Visszaadott sorok: 1

SELECT `h207m_virtuemart_categories`.* ,`h207m_virtuemart_categories_hu_hu`.*  
  FROM `h207m_virtuemart_categories` 
  INNER JOIN `h207m_virtuemart_categories_hu_hu` 
  ON `h207m_virtuemart_categories`.`virtuemart_category_id` = `h207m_virtuemart_categories_hu_hu`.`virtuemart_category_id`  
  WHERE `h207m_virtuemart_categories`.`virtuemart_category_id` = "23"

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1133
22	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:115
21	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1339
20	vmrouterHelper::getCategoryNames()	JROOT/components/com_virtuemart/router.php:1299
19	vmrouterHelper::getCategoryRoute()	JROOT/components/com_virtuemart/router.php:419
18	vmrouterHelper::buildRoute()	JROOT/components/com_virtuemart/router.php:128
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:231
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:133
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

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

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

SELECT `virtuemart_media_id` 
  FROM `h207m_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "23"  
  ORDER BY `ordering`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
23	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
22	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:118
21	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1339
20	vmrouterHelper::getCategoryNames()	JROOT/components/com_virtuemart/router.php:1299
19	vmrouterHelper::getCategoryRoute()	JROOT/components/com_virtuemart/router.php:419
18	vmrouterHelper::buildRoute()	JROOT/components/com_virtuemart/router.php:128
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:231
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:133
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

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

Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 20.605 MB Visszaadott sorok: 1

Duplikált lekérdezések: #39

SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  h207m_virtuemart_categories 
				
  WHERE `virtuemart_category_id`= 32

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:1095
21	VirtueMartModelCategory::getCategoryRecurseS()	JROOT/administrator/components/com_virtuemart/models/category.php:1060
20	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:1282
19	vmrouterHelper::getCategoryRoute()	JROOT/components/com_virtuemart/router.php:419
18	vmrouterHelper::buildRoute()	JROOT/components/com_virtuemart/router.php:128
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:231
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:133
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

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

Lekérdezés ideje: 0.89 ms Utolsó lekérdezés után: 25.34 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 22.534 MB Visszaadott sorok: 2

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.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM h207m_virtuemart_shipmentmethods as i 
 
  LEFT JOIN `h207m_virtuemart_shipmentmethods_hu_hu` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
 
  LEFT JOIN `h207m_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `h207m_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE 
 i.`published` = "1" 
  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` ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	index	NULL	PRIMARY	4	NULL	2	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.i.virtuemart_shipmentmethod_id	1
1	SIMPLE	j	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.i.shipment_jplugin_id	1
1	SIMPLE	s	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	blackcicus_joomla.i.virtuemart_shipmentmethod_id	1	Using where; Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:515
14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:365
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
10	vDispatcher::trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:370
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:133
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

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

Lekérdezés ideje: 0.28 ms Utolsó lekérdezés után: 7.85 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 23.424 MB Visszaadott sorok: 0

SELECT * 
  FROM `h207m_virtuemart_ratings` 
  WHERE `virtuemart_product_id` = "93" 
  AND `published`="1"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_ratings	ref	virtuemart_product_id,published	virtuemart_product_id	4	const	1	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/ratings.php:293
15	VirtueMartModelRatings->getRatingByProduct()	JROOT/components/com_virtuemart/sublayouts/snippets.php:24
14	include JROOT/components/com_virtuemart/sublayouts/snippets.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:574
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/productdetails/tmpl/bs3-default.php:338
12	include JROOT/components/com_virtuemart/views/productdetails/tmpl/bs3-default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:113
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:437
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:133
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

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

Lekérdezés ideje: 0.40 ms Utolsó lekérdezés után: 30.10 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 25.247 MB Visszaadott sorok: 109

SELECT * 
  FROM h207m_acym_configuration

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
15	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:21
14	AcyMailing\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/global/global.php:37
13	acym_config()	JROOT/administrator/components/com_acym/helpers/global/email.php:5
12	acym_getEmailRegex()	JROOT/administrator/components/com_acym/helpers/global/module.php:43
11	acym_initModule()	JROOT/modules/mod_acym/mod_acym.php:15
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.20 ms Utolsó lekérdezés után: 2.21 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 25.583 MB Visszaadott sorok: 1

SELECT * 
  FROM h207m_acym_list 
  WHERE `type` = 'standard'

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/list.php:522
11	AcyMailing\Classes\ListClass->getAllWithoutManagement()	JROOT/modules/mod_acym/mod_acym.php:38
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.16 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 25.591 MB Visszaadott sorok: 1

SELECT * 
  FROM h207m_acym_field 
  WHERE `id` IN(2) 
  ORDER BY `ordering` ASC

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/field.php:51
11	AcyMailing\Classes\FieldClass->getFieldsByID()	JROOT/modules/mod_acym/mod_acym.php:41
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.21 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 25.600 MB Visszaadott sorok: 1

SELECT article.id, article.alias, article.catid, cat.alias AS catalias, article.language
        
  FROM h207m_content AS article 
        
  LEFT JOIN h207m_categories AS cat 
  ON cat.id = article.catid 
        
  WHERE article.id = 2 
  LIMIT 1

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:51
12	acym_loadObject()	JROOT/administrator/components/com_acym/libraries/joomla/content.php:84
11	acym_getArticleURL()	JROOT/modules/mod_acym/mod_acym.php:117
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.42 ms Utolsó lekérdezés után: 0.88 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 25.661 MB Visszaadott sorok: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `h207m_categories` AS `s`

  INNER JOIN `h207m_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	2 (63%)	Using index condition; Using where; Using rowid filter

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
22	ContentRouter->getCategorySegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
21	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
20	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
18	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
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/administrator/components/com_acym/libraries/joomla/url.php:16
12	acym_route()	JROOT/administrator/components/com_acym/libraries/joomla/content.php:102
11	acym_getArticleURL()	JROOT/modules/mod_acym/mod_acym.php:117
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.18 ms Utolsó lekérdezés után: 0.43 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 25.704 MB Visszaadott sorok: 1

SELECT article.id, article.alias, article.catid, cat.alias AS catalias, article.language
        
  FROM h207m_content AS article 
        
  LEFT JOIN h207m_categories AS cat 
  ON cat.id = article.catid 
        
  WHERE article.id = 3 
  LIMIT 1

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:51
12	acym_loadObject()	JROOT/administrator/components/com_acym/libraries/joomla/content.php:84
11	acym_getArticleURL()	JROOT/modules/mod_acym/mod_acym.php:122
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.44 ms Utolsó lekérdezés után: 3.33 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 25.855 MB Visszaadott sorok: 0

SELECT * 
  FROM h207m_virtuemart_calcs  
  LEFT JOIN h207m_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DBTaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-03-14 09:57:32" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-03-14 09:57:32" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where
1	SIMPLE	h207m_virtuemart_calc_shoppergroups	ref	virtuemart_calc_id	virtuemart_calc_id	4	blackcicus_joomla.h207m_virtuemart_calcs.virtuemart_calc_id	1	Using where; Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1523
16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:774
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2347
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2457
13	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2653
12	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vp_mini_cart/helper.php:41
11	ModVPMiniCartHelper::getCart()	JROOT/modules/mod_vp_mini_cart/mod_vp_mini_cart.php:19
10	include JROOT/modules/mod_vp_mini_cart/mod_vp_mini_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.28 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 25.865 MB Visszaadott sorok: 0

SELECT * 
  FROM h207m_virtuemart_calcs  
  LEFT JOIN h207m_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="TaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-03-14 09:57:32" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-03-14 09:57:32" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where
1	SIMPLE	h207m_virtuemart_calc_shoppergroups	ref	virtuemart_calc_id	virtuemart_calc_id	4	blackcicus_joomla.h207m_virtuemart_calcs.virtuemart_calc_id	1	Using where; Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1523
16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2347
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2457
13	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2653
12	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vp_mini_cart/helper.php:41
11	ModVPMiniCartHelper::getCart()	JROOT/modules/mod_vp_mini_cart/mod_vp_mini_cart.php:19
10	include JROOT/modules/mod_vp_mini_cart/mod_vp_mini_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.26 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 25.874 MB Visszaadott sorok: 0

SELECT * 
  FROM h207m_virtuemart_calcs  
  LEFT JOIN h207m_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DATaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2026-03-14 09:57:32" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-03-14 09:57:32" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	h207m_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where
1	SIMPLE	h207m_virtuemart_calc_shoppergroups	ref	virtuemart_calc_id	virtuemart_calc_id	4	blackcicus_joomla.h207m_virtuemart_calcs.virtuemart_calc_id	1	Using where; Using index

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1523
16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:776
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2347
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2457
13	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:2653
12	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vp_mini_cart/helper.php:41
11	ModVPMiniCartHelper::getCart()	JROOT/modules/mod_vp_mini_cart/mod_vp_mini_cart.php:19
10	include JROOT/modules/mod_vp_mini_cart/mod_vp_mini_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.19 ms Utolsó lekérdezés után: 1.42 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 25.961 MB Visszaadott sorok: 1

SELECT `name`,`state`

  FROM `h207m_vpadvanceduser_fields`

  WHERE `name` = 'profile_picture' 
  AND `type` = 'avatar'

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_vpadvanceduser/helpers/user/user.php:103
12	VPAUser::hasProfilePicture()	JROOT/modules/mod_vpadvanceduser/variables.php:40
11	require JROOT/modules/mod_vpadvanceduser/variables.php	JROOT/modules/mod_vpadvanceduser/mod_vpadvanceduser.php:28
10	include JROOT/modules/mod_vpadvanceduser/mod_vpadvanceduser.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.75 ms Utolsó lekérdezés után: 6.55 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 26.780 MB Visszaadott sorok: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM h207m_fields AS a

  LEFT JOIN `h207m_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN h207m_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN h207m_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN h207m_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN h207m_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_users.user' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	blackcicus_joomla.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.a.group_id	1	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
21	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
20	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
17	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
16	UsersModelRegistration->preprocessForm()	JROOT/components/com_vpadvanceduser/models/registration.php:254
15	VPAdvancedUserModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
14	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_vpadvanceduser/models/registration.php:131
13	VPAdvancedUserModelRegistration->getForm()	JROOT/modules/mod_vpadvanceduser/helper.php:53
12	ModVPAdvancedUserHelper::get()	JROOT/modules/mod_vpadvanceduser/variables.php:44
11	require JROOT/modules/mod_vpadvanceduser/variables.php	JROOT/modules/mod_vpadvanceduser/mod_vpadvanceduser.php:28
10	include JROOT/modules/mod_vpadvanceduser/mod_vpadvanceduser.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.55 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 26.850 MB Visszaadott sorok: 2

Duplikált lekérdezések: #74

SELECT id, label, name, description, type, show_in_registration, show_in_profile, access, params, ordering, state, language

  FROM `h207m_vpadvanceduser_fields`

  WHERE `show_in_registration` = 1 
  AND `access` IN (1,1,5) 
  AND `state` = 1 
  AND (`language` = 'en-GB' OR `language` = '*')

  ORDER BY `ordering`

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_vpadvanceduser/models/data.php:258
22	VPAdvancedUserModelData->getFields()	JROOT/administrator/components/com_vpadvanceduser/models/data.php:36
21	VPAdvancedUserModelData->getForm()	JROOT/plugins/user/vpadvanceduser/vpadvanceduser.php:154
20	plgUserVPAdvancedUser->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
17	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
16	UsersModelRegistration->preprocessForm()	JROOT/components/com_vpadvanceduser/models/registration.php:254
15	VPAdvancedUserModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
14	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_vpadvanceduser/models/registration.php:131
13	VPAdvancedUserModelRegistration->getForm()	JROOT/modules/mod_vpadvanceduser/helper.php:53
12	ModVPAdvancedUserHelper::get()	JROOT/modules/mod_vpadvanceduser/variables.php:44
11	require JROOT/modules/mod_vpadvanceduser/variables.php	JROOT/modules/mod_vpadvanceduser/mod_vpadvanceduser.php:28
10	include JROOT/modules/mod_vpadvanceduser/mod_vpadvanceduser.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.60 ms Utolsó lekérdezés után: 1.77 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 26.915 MB Visszaadott sorok: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM h207m_fields AS a

  LEFT JOIN `h207m_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN h207m_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN h207m_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN h207m_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN h207m_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_users.login' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	blackcicus_joomla.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	blackcicus_joomla.a.group_id	1	Using where

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
23	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
22	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
21	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/login.php:110
17	UsersModelLogin->preprocessForm()	JROOT/components/com_vpadvanceduser/models/login.php:151
16	VPAdvancedUserModelLogin->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
15	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/login.php:35
14	UsersModelLogin->getForm()	JROOT/components/com_vpadvanceduser/models/login.php:53
13	VPAdvancedUserModelLogin->getForm()	JROOT/modules/mod_vpadvanceduser/helper.php:53
12	ModVPAdvancedUserHelper::get()	JROOT/modules/mod_vpadvanceduser/variables.php:46
11	require JROOT/modules/mod_vpadvanceduser/variables.php	JROOT/modules/mod_vpadvanceduser/mod_vpadvanceduser.php:28
10	include JROOT/modules/mod_vpadvanceduser/mod_vpadvanceduser.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.18 ms Utolsó lekérdezés után: 3.87 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 27.087 MB Visszaadott sorok: 1

SELECT * 
  FROM h207m_acym_list 
  WHERE type = 'standard'

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
15	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/list.php:503
14	AcyMailing\Classes\ListClass->getAllForSelect()	JROOT/administrator/components/com_acym/classes/form.php:25
13	AcyMailing\Classes\FormClass->__construct()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 27.095 MB Visszaadott sorok: 3

SELECT * 
  FROM h207m_acym_field

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
15	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:58
14	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/classes/form.php:28
13	AcyMailing\Classes\FormClass->__construct()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.26 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 27.134 MB Visszaadott sorok: 0

SELECT * 
  FROM h207m_acym_form 
  WHERE active = 1 
  AND type != 'shortcode'

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
14	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/form.php:450
13	AcyMailing\Classes\FormClass->getAllFormsToDisplay()	JROOT/plugins/system/acymtriggers/acymtriggers.php:292
12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `value` 
  FROM h207m_acym_configuration 
  WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/acymtriggers/acymtriggers.php:430
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.58 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 28.949 MB Visszaadott sorok: 212

SHOW TABLES

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW TABLES

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
11	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:120
10	acym_getTableList()	JROOT/administrator/components/com_acym/helpers/global/addon.php:10
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:467
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 0.48 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 28.977 MB Visszaadott sorok: 4

Duplikált lekérdezések: #69

SELECT * 
  FROM h207m_acym_plugin

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:58
12	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/classes/plugin.php:20
11	AcyMailing\Classes\PluginClass->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:88
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:467
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.13 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 28.988 MB Visszaadott sorok: 4

Duplikált lekérdezések: #68

SELECT * 
  FROM h207m_acym_plugin

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:58
11	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:89
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:467
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 4.90 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 29.801 MB Visszaadott sorok: 9

SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` 
        
  FROM h207m_usergroups AS `groups`

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:36
13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/user.php:46
12	acym_getGroups()	JROOT/administrator/components/com_acym/dynamics/createuser/plugin.php:21
11	plgAcymcreateuser->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:130
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:467
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:311
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT manifest_cache

  FROM h207m_extensions

  WHERE type='component' 
  AND element='com_baforms'

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:560
9	baformsHelper::aboutUs()	JROOT/components/com_baforms/helpers/baforms.php:458
8	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:39
7	plgSystemBaforms->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 31.481 MB Visszaadott sorok: 1

SELECT `key`

  FROM h207m_baforms_api

  WHERE service = 'balbooa_activation'

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:545
9	baformsHelper::checkFormsActivation()	JROOT/components/com_baforms/helpers/baforms.php:459
8	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:39
7	plgSystemBaforms->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.41 ms Utolsó lekérdezés után: 0.55 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 31.543 MB Visszaadott sorok: 1

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

  FROM h207m_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-03-14 09:57:32') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-14 09:57:32') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND m.module = 'mod_vpadvanceduser' 
  AND (mm.menuid = 254 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:752
8	plgSystemVPAdvancedUser->_getModules()	JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:413
7	plgSystemVPAdvancedUser->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.51 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 31.565 MB Visszaadott sorok: 2

Duplikált lekérdezések: #61

SELECT id, label, name, description, type, show_in_registration, show_in_profile, access, params, ordering, state, language

  FROM `h207m_vpadvanceduser_fields`

  WHERE `show_in_registration` = 1 
  AND `access` IN (1,1,5) 
  AND `state` = 1 
  AND (`language` = 'en-GB' OR `language` = '*')

  ORDER BY `ordering`

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_vpadvanceduser/models/data.php:258
20	VPAdvancedUserModelData->getFields()	JROOT/administrator/components/com_vpadvanceduser/models/data.php:36
19	VPAdvancedUserModelData->getForm()	JROOT/plugins/user/vpadvanceduser/vpadvanceduser.php:154
18	plgUserVPAdvancedUser->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
15	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
14	UsersModelRegistration->preprocessForm()	JROOT/components/com_vpadvanceduser/models/registration.php:254
13	VPAdvancedUserModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_vpadvanceduser/models/registration.php:131
11	VPAdvancedUserModelRegistration->getForm()	JROOT/modules/mod_vpadvanceduser/helper.php:53
10	ModVPAdvancedUserHelper::get()	JROOT/modules/mod_vpadvanceduser/variables.php:44
9	require JROOT/modules/mod_vpadvanceduser/variables.php	JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:605
8	plgSystemVPAdvancedUser->_loadModalForms()	JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:428
7	plgSystemVPAdvancedUser->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.22 ms Utolsó lekérdezés után: 7.34 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 31.648 MB Visszaadott sorok: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.catid, a.introtext, a.fulltext, a.language, a.state

  FROM h207m_content AS a

  WHERE a.id = 2 
  AND a.state = 1

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vpadvanceduser/models/fields/vptos.php:130
14	JFormFieldVptos->getArticle()	JROOT/administrator/components/com_vpadvanceduser/models/fields/vptos.php:76
13	JFormFieldVptos->getLayoutData()	JROOT/administrator/components/com_vpadvanceduser/models/fields/vptos.php:47
12	JFormFieldVptos->getInput()	JROOT/libraries/src/Form/FormField.php:425
11	Joomla\CMS\Form\FormField->__get()	JROOT/libraries/joomla/form/fields/checkbox.php:56
10	JFormFieldCheckbox->__get()	JROOT/modules/mod_vpadvanceduser/tmpl/modal_registration.php:53
9	require JROOT/modules/mod_vpadvanceduser/tmpl/modal_registration.php	JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:629
8	plgSystemVPAdvancedUser->_loadModalForms()	JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:428
7	plgSystemVPAdvancedUser->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.17 ms Utolsó lekérdezés után: 1.28 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 31.681 MB Visszaadott sorok: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.catid, a.introtext, a.fulltext, a.language, a.state

  FROM h207m_content AS a

  WHERE a.id = 3 
  AND a.state = 1

Magyarázat

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

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_vpadvanceduser/models/fields/vptos.php:130
14	JFormFieldVptos->getArticle()	JROOT/administrator/components/com_vpadvanceduser/models/fields/vptos.php:76
13	JFormFieldVptos->getLayoutData()	JROOT/administrator/components/com_vpadvanceduser/models/fields/vptos.php:47
12	JFormFieldVptos->getInput()	JROOT/libraries/src/Form/FormField.php:425
11	Joomla\CMS\Form\FormField->__get()	JROOT/libraries/joomla/form/fields/checkbox.php:56
10	JFormFieldCheckbox->__get()	JROOT/modules/mod_vpadvanceduser/tmpl/modal_registration.php:53
9	require JROOT/modules/mod_vpadvanceduser/tmpl/modal_registration.php	JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:629
8	plgSystemVPAdvancedUser->_loadModalForms()	JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:428
7	plgSystemVPAdvancedUser->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT táblák:

5 × SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  h207m_virtuemart_categories

3 × SELECT * 
  FROM h207m_virtuemart_calcs  
  LEFT JOIN h207m_virtuemart_calc_shoppergroups using(virtuemart_calc_id)

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM h207m_modules AS m 
  LEFT JOIN h207m_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN h207m_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

2 × SELECT `virtuemart_media_id` 
  FROM `h207m_virtuemart_category_medias`

2 × SELECT `h207m_virtuemart_categories`.* ,`h207m_virtuemart_categories_hu_hu`.*  
  FROM `h207m_virtuemart_categories` 
  INNER JOIN `h207m_virtuemart_categories_hu_hu` 
  ON `h207m_virtuemart_categories`.`virtuemart_category_id` = `h207m_virtuemart_categories_hu_hu`.`virtuemart_category_id`

2 × SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `h207m_virtuemart_categories` as c  
  LEFT JOIN `h207m_virtuemart_categories_hu_hu` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`

```
2 × SELECT * 
  FROM h207m_acym_list
```

2 × SELECT * 
  FROM `h207m_virtuemart_userfields`

2 × SELECT article.id, article.alias, article.catid, cat.alias AS catalias, article.language         
  FROM h207m_content AS article          
  LEFT JOIN h207m_categories AS cat 
  ON cat.id = article.catid

2 × SELECT `h207m_virtuemart_medias`.*  
  FROM `h207m_virtuemart_medias`

2 × SELECT a.id, a.asset_id, a.title, a.alias, a.catid, a.introtext, a.fulltext, a.language, a.state 
  FROM h207m_content AS a

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM h207m_fields AS a 
  LEFT JOIN `h207m_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN h207m_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN h207m_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN h207m_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN h207m_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT id, label, name, description, type, show_in_registration, show_in_profile, access, params, ordering, state, language 
  FROM `h207m_vpadvanceduser_fields`

```
2 × SELECT * 
  FROM h207m_acym_plugi
```

2 × SELECT `value` 
  FROM h207m_acym_configuration

1 × SELECT `name`,`state` 
  FROM `h207m_vpadvanceduser_fields`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `h207m_categories` AS `s` 
  INNER JOIN `h207m_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

```
1 × SELECT * 
  FROM h207m_acym_fiel
```
```
1 × SELECT * 
  FROM h207m_acym_form
```
```
1 × SELECT * 
  FROM h207m_acym_field
```

1 × SELECT * 
  FROM h207m_acym_configuratio

1 × SELECT * 
  FROM `h207m_virtuemart_ratings`

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.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM h207m_virtuemart_shipmentmethods as i   
  LEFT JOIN `h207m_virtuemart_shipmentmethods_hu_hu` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`   
  LEFT JOIN `h207m_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`    
  LEFT 
  OUTER JOIN `h207m_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`

1 × SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`          
  FROM h207m_usergroups AS `groups

1 × SELECT manifest_cache 
  FROM h207m_extensions

1 × SELECT `key` 
  FROM h207m_baforms_api

1 × SELECT  c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug  
  FROM h207m_virtuemart_categories as c  
  LEFT JOIN `h207m_virtuemart_categories_hu_hu` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`

1 × SELECT `data` 
  FROM `h207m_session`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM h207m_virtuemart_calc_manufacturers

1 × SELECT element, folder 
  FROM h207m_extensions

1 × SELECT id, rules 
  FROM `h207m_viewlevels

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

1 × SELECT `config` 
  FROM `h207m_virtuemart_configs`

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

```
1 × SELECT * 
  FROM `h207m_menu`
```

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

1 × SELECT l.virtuemart_category_id  
  FROM `h207m_virtuemart_categories_hu_hu` as l

1 × SELECT * 
  FROM `h207m_extensions`

1 × SELECT title, module AS name 
  FROM h207m_modules

1 × SELECT * 
  FROM `h207m_virtuemart_shoppergroups`

1 × SELECT c.* 
  FROM h207m_virtuemart_calcs as c  
  LEFT JOIN h207m_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT `h207m_virtuemart_shoppergroups`.*  
  FROM `h207m_virtuemart_shoppergroups`

1 × SELECT `h207m_virtuemart_products`.* ,`h207m_virtuemart_products_hu_hu`.*  
  FROM `h207m_virtuemart_products` 
  INNER JOIN `h207m_virtuemart_products_hu_hu` 
  ON `h207m_virtuemart_products`.`virtuemart_product_id` = `h207m_virtuemart_products_hu_hu`.`virtuemart_product_id`

1 × SELECT `virtuemart_media_id` 
  FROM `h207m_virtuemart_product_medias`

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM `h207m_virtuemart_product_shoppergroups`

1 × SELECT * 
  FROM `h207m_virtuemart_product_prices`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM `h207m_virtuemart_product_manufacturers`

1 × SELECT * 
  FROM `h207m_virtuemart_product_categories`

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.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, 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.`noninheritable`, field.`ordering`,   field.`product_sku`, field.`product_gtin`, field.`product_mpn`   
  FROM `h207m_virtuemart_customs` AS c 
  LEFT JOIN `h207m_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

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

1 × SELECT `session_id` 
  FROM `h207m_session`

1 × SELECT `h207m_virtuemart_currencies`.*  
  FROM `h207m_virtuemart_currencies`

EGYÉB táblák:

1 × INSERT INTO `h207m_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3865303564306366623639666461373264373737373430343432373836326465', 1, 1773482252, 0, '', 0

1 × SHOW TABLES LIKE "h207m_virtuemart_configs

1 × UPDATE `h207m_extensions` 
  SET `params` = '{\"mediaversion\":\"a7bee775bcd770b63f5c9d6a09f8ab91\"}'

1 × SHOW FULL COLUMNS  
  FROM `h207m_virtuemart_userfields

```
1 × SHOW TABLE
```

Kutyajáték húzós kosár labda, 7,5x20cm

Megosztom ...

Csatlakozz hozzánk, kövess minket!

Keress minket

Információk

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

76 naplózott lekérdezés 20.69 ms

8 duplikátum található!

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

SELECT táblák:

EGYÉB táblák:

Kutyajáték húzós kosár labda, 7,5x20cm

Megosztom ...

Szeretnél értesülni az újdonságokról?

Csatlakozz hozzánk, kövess minket!

Keress minket

Információk

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

76 naplózott lekérdezés 20.69 ms

8 duplikátum található!

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

SELECT táblák:

EGYÉB táblák: