Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /customers/c/b/6/huisansiau.be/httpd.www/templates/huisansiau/functions.php on line 182 Afrekenen - Huis Ansiau

Bistro - Restaurant

Viane

Winkelwagen

1 producten voor 31,40 €

U bevindt zich hier: Huis Ansiau - Shop

Login of nieuwe account aanmaken

Login

Uw wachtwoord vergeten

Uw gebruikersnaam vergeten

Registratie

Naam*

Gebruikersnaam*

E-mail*

E-mail bevestiging*

Wachtwoord*

Wachtwoord bevestigen*

Adres informatie

Titel*

Voornaam*

Achternaam*

Straatnaam*

Nummer*

Postcode*

Woonplaats*

Telefoon*

Bedrijfsnaam

BTW nummer

Gebruik hetzelfde adres voor verzending

Velden gemarkeerd met een (*) zijn verplicht.

Verzendmethode

Afhalen 0,00 €
Levering < 15km 0,00 €

Betaalmethode

Visa, mastercard, maestro, payconiq en cash mogelijk in ons restaurant Bistro - Restaurant Huis Ansiau, Vianeplein 37, 9500 Viane, T: 054/58.83.80 Openingsuren : Alle dagen van 12u tot 15u en van 18u tot 22u - Dinsdag en woensdag gesloten

Afbeelding

Naam

Stuk prijs

Voorraad

Totaal prijs

2016_bolla_le_poiane_amarone_della_valpolicella

Amarone della Valpolicella "Bolla"

31,40 € stuk

	+
	–

31,40 €

Subtotaal

31,40 €

Verzending

0,00 €

Belastingen

5,45 €

Totaal

31,40 €

De verzendmethode Afhalen is geselecteerd.
De betaalmethode Visa, mastercard, maestro, payconiq en cash mogelijk in ons restaurant is geselecteerd.

Bent u op zoek naar een wijn die niet vermeld staat in onze webshop?

Geen probleem, stuur een mail naar webshop@huisansiau.be en we helpen u graag verder.

Joomla! Foutopsporingsconsole

Sessie

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1716063665,
                "last": 1716063665,
                "now": 1716063666
            },
            "client": {
                "forwarded": "3.133.112.82"
            },
            "token": "iHDVZ3yFjhfVRpga7X8rHOj8d0bXsLrn"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "user_id": 0,
                "zone_id": 21,
                "shipping_cache": {
                    "usable_methods": {
                        "6bf845d29dfbcc0af10ec583f3c3b9435a2f34ae": [
                            {
                                "manual": [
                                    {
                                        "2": {
                                            "shipping_id": "2",
                                            "shipping_type": "manual",
                                            "shipping_zone_namekey": "",
                                            "shipping_tax_id": "0",
                                            "shipping_price": "0.00001",
                                            "shipping_currency_id": "1",
                                            "shipping_name": "Afhalen",
                                            "shipping_description": "",
                                            "shipping_published": "1",
                                            "shipping_ordering": "1",
                                            "shipping_currency": "",
                                            "shipping_params": {
                                                "shipping_percentage": "0",
                                                "shipping_tax": "0",
                                                "shipping_per_product": "0",
                                                "shipping_price_per_product": "",
                                                "shipping_virtual_included": "0",
                                                "shipping_override_address": "0",
                                                "shipping_override_address_text": "",
                                                "override_tax_zone": "",
                                                "shipping_warehouse_filter": "",
                                                "shipping_min_price": "0",
                                                "shipping_max_price": "0",
                                                "shipping_price_use_tax": "1",
                                                "shipping_min_quantity": "",
                                                "shipping_max_quantity": "",
                                                "shipping_min_weight": "0",
                                                "shipping_weight_unit": "kg",
                                                "shipping_max_weight": "0",
                                                "shipping_min_volume": "0",
                                                "shipping_size_unit": "m",
                                                "shipping_max_volume": "0",
                                                "shipping_zip_prefix": "",
                                                "shipping_min_zip": "",
                                                "shipping_max_zip": "",
                                                "shipping_zip_suffix": ""
                                            },
                                            "shipping_images": "",
                                            "shipping_access": "all",
                                            "shippingkey": "25492",
                                            "shipping_warehouse_id": 0,
                                            "shipping_price_with_tax": "0.00001",
                                            "shipping_price_orig_with_tax": null,
                                            "taxes": {
                                                "BTW": {
                                                    "tax_namekey": "BTW",
                                                    "tax_rate": "0.21000",
                                                    "tax_amount": 0,
                                                    "amount": "0.00001"
                                                }
                                            }
                                        },
                                        "6": {
                                            "shipping_id": "6",
                                            "shipping_type": "manual",
                                            "shipping_zone_namekey": "",
                                            "shipping_tax_id": "0",
                                            "shipping_price": "0.00001",
                                            "shipping_currency_id": "1",
                                            "shipping_name": "Levering < 15km",
                                            "shipping_description": "",
                                            "shipping_published": "1",
                                            "shipping_ordering": "3",
                                            "shipping_currency": "",
                                            "shipping_params": {
                                                "shipping_percentage": "0",
                                                "shipping_tax": "0",
                                                "shipping_per_product": "0",
                                                "shipping_price_per_product": "",
                                                "shipping_virtual_included": "1",
                                                "shipping_override_address": "0",
                                                "shipping_override_address_text": "",
                                                "override_tax_zone": "",
                                                "shipping_warehouse_filter": "",
                                                "shipping_min_price": "0",
                                                "shipping_max_price": "0",
                                                "shipping_price_use_tax": "1",
                                                "shipping_min_quantity": "",
                                                "shipping_max_quantity": "",
                                                "shipping_min_weight": "0",
                                                "shipping_weight_unit": "kg",
                                                "shipping_max_weight": "0",
                                                "shipping_min_volume": "0",
                                                "shipping_size_unit": "m",
                                                "shipping_max_volume": "0",
                                                "shipping_zip_prefix": "",
                                                "shipping_min_zip": "",
                                                "shipping_max_zip": "",
                                                "shipping_zip_suffix": ""
                                            },
                                            "shipping_images": "",
                                            "shipping_access": "all",
                                            "shippingkey": "25492",
                                            "shipping_warehouse_id": 0,
                                            "shipping_price_with_tax": "0.00001",
                                            "shipping_price_orig_with_tax": null
                                        }
                                    },
                                    []
                                ]
                            }
                        ]
                    }
                },
                "popup_cart_type": "cart",
                "cart_empty_redirect": 0,
                "checkout_itemid": 0
            }
        },
        "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
        }
    }
}

Profielinformatie

Geheugengebruik

Database zoekopdrachten

53 zoekopdrachten gelogd 18.40 ms

6 identieke gevonden!

2 identieke: #30 #36

2 identieke: #31 #37

2 identieke: #32 #38

Tijd zoekopdracht: 0.24 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.031 MB Regels teruggegeven: 1

SELECT `data`

  FROM `alnew_session`

  WHERE `session_id` = X'6237306337386530336434626539316565633261363537396662653735333530'

Verklaren

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

Profiel

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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Zelfde als de call in onderstaande regel.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.41 ms Na de laatste zoekopdracht: 0.39 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 1.100 MB Regels teruggegeven: 38

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

  FROM `alnew_extensions`

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

Verklaren

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

Profiel

Status	Duration
Starting	0.02 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
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Zelfde als de call in onderstaande regel.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.17 ms Na de laatste zoekopdracht: 0.25 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.129 MB Regels teruggegeven: 5

SELECT id, rules

  FROM `alnew_viewlevels`

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_viewlevels	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	5

Profiel

Status	Duration
Starting	0.01 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.22 ms Na de laatste zoekopdracht: 0.05 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.141 MB Regels teruggegeven: 2

SELECT b.id

  FROM alnew_usergroups AS a

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

  WHERE a.id = 9

Verklaren

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

Profiel

Status	Duration
Starting	0.02 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.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.53 ms Na de laatste zoekopdracht: 0.06 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 1.163 MB Regels teruggegeven: 124

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

  FROM alnew_extensions

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

  ORDER BY ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_extensions	ALL	extension	INDEX KEY ONTBREEKT	NULL	NULL	439	Using where; Gebruikt bestandssortering

Profiel

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
Creating sort index	0.28 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Zelfde als de call in onderstaande regel.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.16 ms Na de laatste zoekopdracht: 6.32 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 1.820 MB Regels teruggegeven: 1

SELECT count(*)

  FROM `alnew_cwgears_schedule`

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	Select tables optimized away

Profiel

Status	Duration
Starting	0.02 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
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
8	plgSystemCwgears->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:696
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.16 ms Na de laatste zoekopdracht: 0.03 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 1.825 MB Regels teruggegeven: 1

SELECT count(*)

  FROM `alnew_cwgears_schedule`

  WHERE time + '86400'<'1716063666'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiel

Status	Duration
Starting	0.02 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
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
8	plgSystemCwgears->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:696
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.36 ms Na de laatste zoekopdracht: 0.31 ms Zoekopdracht geheugen: 0.044 MB geheugen voor zoekopdracht: 1.859 MB Regels teruggegeven: 12

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

  FROM alnew_menu AS m

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

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

  ORDER BY m.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	13	Using index condition; Using where; Gebruikt bestandssortering
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	huisansiau_be.m.component_id	1	Using where

Profiel

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.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Zelfde als de call in onderstaande regel.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1169
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.31 ms Na de laatste zoekopdracht: 1.35 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 2.110 MB Regels teruggegeven: 1

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

  FROM `alnew_extensions`

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

Verklaren

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

Profiel

Status	Duration
Starting	0.02 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.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
21	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Zelfde als de call in onderstaande regel.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
18	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
17	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
16	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
13	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3045
12	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:163
11	_HikashopParseRoute()	JROOT/components/com_hikashop/router.php:152
10	HikashopParseRoute()	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:1170
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.26 ms Na de laatste zoekopdracht: 0.08 ms Zoekopdracht geheugen: 0.008 MB geheugen voor zoekopdracht: 2.104 MB

UPDATE `alnew_extensions`

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

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

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE `alnew_extensions` SET `params` = '{\"mediaversion\":\"f1352a077f0df7124a9402d3fb2c30df\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profiel

Status	Duration
Starting	0.02 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.08 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
17	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
16	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
13	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3045
12	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:163
11	_HikashopParseRoute()	JROOT/components/com_hikashop/router.php:152
10	HikashopParseRoute()	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:1170
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.37 ms Na de laatste zoekopdracht: 2.54 ms Zoekopdracht geheugen: 0.062 MB geheugen voor zoekopdracht: 2.720 MB Regels teruggegeven: 307

SELECT * 
  FROM alnew_hikashop_config

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_hikashop_config	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	307

Profiel

Status	Duration
Starting	0.02 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.09 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
14	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1177
13	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3064
12	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:163
11	_HikashopParseRoute()	JROOT/components/com_hikashop/router.php:152
10	HikashopParseRoute()	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:1170
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.21 ms Na de laatste zoekopdracht: 0.38 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 2.906 MB Regels teruggegeven: 1

SELECT *

  FROM alnew_languages

  WHERE published=1

  ORDER BY ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_languages	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	2	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.01 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
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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.26 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 2.927 MB Regels teruggegeven: 1

SELECT id, home, template, s.params

  FROM alnew_template_styles as s

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

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	huisansiau_be.s.template,const	1	Using index condition; Using where

Profiel

Status	Duration
Starting	0.02 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.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.32 ms Na de laatste zoekopdracht: 4.76 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 3.052 MB Regels teruggegeven: 1

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart	ref	session_id	session_id	767	const	1	Using index condition; Using where; Gebruikt bestandssortering

Profiel

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.05 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/classes/cart.php:68
11	hikashopCartClass->getCurrentCartId()	JROOT/administrator/components/com_hikashop/classes/cart.php:139
10	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:48
9	hikashopCheckoutHelper->__construct()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:36
8	hikashopCheckoutHelper::get()	JROOT/components/com_hikashop/controllers/checkout.php:56
7	checkoutController->__construct()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.23 ms Na de laatste zoekopdracht: 0.05 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 3.059 MB Regels teruggegeven: 1

SELECT * 
  FROM alnew_hikashop_cart 
  WHERE cart_id = '18641' 
  LIMIT 0, 1

Verklaren

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

Profiel

Status	Duration
Starting	0.02 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2328
11	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/cart.php:146
10	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:48
9	hikashopCheckoutHelper->__construct()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:36
8	hikashopCheckoutHelper::get()	JROOT/components/com_hikashop/controllers/checkout.php:56
7	checkoutController->__construct()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.49 ms Na de laatste zoekopdracht: 0.67 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 3.386 MB Regels teruggegeven: 1

SELECT cart_product.*, product.product_type, product.product_parent_id  
  FROM alnew_hikashop_cart_product AS cart_product  
  LEFT JOIN alnew_hikashop_product AS product 
  ON cart_product.product_id = product.product_id  
  WHERE (cart_product.cart_id = 18641)  
  ORDER BY cart_product.cart_product_modified ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart_product	ref	cart_id	cart_id	4	const	1	Using where; Gebruikt bestandssortering
1	SIMPLE	product	eq_ref	PRIMARY	PRIMARY	4	huisansiau_be.cart_product.product_id	1

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/cart.php:202
10	hikashopCartClass->get()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:48
9	hikashopCheckoutHelper->__construct()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:36
8	hikashopCheckoutHelper::get()	JROOT/components/com_hikashop/controllers/checkout.php:56
7	checkoutController->__construct()	JROOT/components/com_hikashop/hikashop.php:88
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.19 ms Na de laatste zoekopdracht: 0.18 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 3.477 MB Regels teruggegeven: 1

SELECT shipping_id, shipping_params 
  FROM alnew_hikashop_shipping 
  WHERE shipping_id IN(2)

Verklaren

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

Profiel

Status	Duration
Starting	0.02 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/cart.php:772
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.22 ms Na de laatste zoekopdracht: 0.12 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 3.497 MB Regels teruggegeven: 1

SELECT currency_id 
  FROM alnew_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 1

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_hikashop_currency	ALL	PRIMARY	INDEX KEY ONTBREEKT	NULL	NULL	182	Using where

Profiel

Status	Duration
Starting	0.02 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.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:471
13	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/cart.php:853
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.40 ms Na de laatste zoekopdracht: 0.04 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 3.506 MB Regels teruggegeven: 1

SELECT cart_product.cart_product_id, cart_product.cart_product_quantity, cart_product.cart_product_option_parent_id, cart_product.cart_product_parent_id, cart_product.cart_product_wishlist_id, product.*  
  FROM alnew_hikashop_cart_product AS cart_product  
  LEFT JOIN alnew_hikashop_product AS product 
  ON cart_product.product_id = product.product_id  
  WHERE (cart_product.cart_id = 18641) 
  AND (cart_product.product_id > 0)  
  ORDER BY cart_product.cart_product_id ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cart_product	ref	cart_id	cart_id	4	const	1	Using where; Gebruikt bestandssortering
1	SIMPLE	product	eq_ref	PRIMARY	PRIMARY	4	huisansiau_be.cart_product.product_id	1

Profiel

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.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/cart.php:875
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.33 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 3.518 MB Regels teruggegeven: 1

SELECT * 
  FROM alnew_hikashop_file 
  WHERE file_ref_id IN (173) 
  AND file_type IN ('product','file')  
  ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_hikashop_file	ALL	file_type	INDEX KEY ONTBREEKT	NULL	NULL	53	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.02 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.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/cart.php:959
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.41 ms Na de laatste zoekopdracht: 0.04 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 3.527 MB Regels teruggegeven: 1

SELECT product_category.*, category.*  
  FROM alnew_hikashop_product_category AS product_category  
  LEFT JOIN alnew_hikashop_category AS category 
  ON product_category.category_id = category.category_id  
  WHERE product_category.product_id IN (173) 
  ORDER BY product_category.ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	product_category	ref	product_id	product_id	4	const	1	Using where; Gebruikt bestandssortering
1	SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	huisansiau_be.product_category.category_id	1

Profiel

Status	Duration
Starting	0.02 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.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/cart.php:975
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.16 ms Na de laatste zoekopdracht: 0.04 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 3.536 MB Regels teruggegeven: 0

SELECT product_id 
  FROM alnew_hikashop_product_related 
  WHERE product_related_type = 'options' 
  AND product_id IN (173)

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiel

Status	Duration
Starting	0.02 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
Executing	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/cart.php:981
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.19 ms Na de laatste zoekopdracht: 0.08 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 3.543 MB Regels teruggegeven: 0

SELECT hk_variant.*, hk_characteristic.*  
  FROM alnew_hikashop_variant AS hk_variant  
  LEFT JOIN alnew_hikashop_characteristic AS hk_characteristic 
  ON hk_variant.variant_characteristic_id = hk_characteristic.characteristic_id  
  WHERE hk_variant.variant_product_id IN (173)  
  ORDER BY hk_variant.ordering, hk_characteristic.characteristic_value

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiel

Status	Duration
Starting	0.02 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
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/cart.php:1058
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.25 ms Na de laatste zoekopdracht: 0.08 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 3.559 MB Regels teruggegeven: 1

SELECT p.* 
  FROM alnew_hikashop_price as p 
  WHERE (p.price_currency_id IN (1)) 
  AND (p.price_start_date < 1716063666) 
  AND ((p.price_end_date < 1 OR p.price_end_date > 1716063666)) 
  AND (p.price_product_id IN (173)) 
  AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) 
  ORDER BY p.price_site_id ASC, p.price_value DESC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ref	price_product_id	price_product_id	4	const	1	Using where; Gebruikt bestandssortering

Profiel

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.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.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1597
14	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
13	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/cart.php:1134
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.20 ms Na de laatste zoekopdracht: 0.05 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 3.570 MB Regels teruggegeven: 1

SELECT * 
  FROM alnew_hikashop_currency 
  WHERE currency_id IN (1)

Verklaren

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

Profiel

Status	Duration
Starting	0.02 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1872
18	hikashopCurrencyClass->getCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:2282
17	hikashopCurrencyClass->getRounding()	JROOT/administrator/components/com_hikashop/classes/currency.php:2634
16	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1689
15	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1604
14	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
13	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/cart.php:1134
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.27 ms Na de laatste zoekopdracht: 0.09 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 3.584 MB Regels teruggegeven: 1

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	b	system	NULL	INDEX KEY ONTBREEKT	NULL	NULL	1
1	SIMPLE	a	const	PRIMARY,category_namekey	PRIMARY	4	const	1
1	SIMPLE	c	system	PRIMARY	INDEX KEY ONTBREEKT	NULL	NULL	1

Profiel

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.01 ms
init	0.02 ms
Optimizing	0.02 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:197
18	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
17	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2636
16	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1689
15	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1604
14	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
13	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/cart.php:1134
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.18 ms Na de laatste zoekopdracht: 0.03 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 3.595 MB Regels teruggegeven: 1

SELECT * 
  FROM alnew_hikashop_zone 
  WHERE zone_id = 21

Verklaren

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

Profiel

Status	Duration
Starting	0.01 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/currency.php:218
18	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:60
17	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2636
16	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1689
15	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1604
14	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
13	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/cart.php:1134
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.25 ms Na de laatste zoekopdracht: 0.09 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 3.611 MB Regels teruggegeven: 0

SELECT * 
  FROM alnew_hikashop_discount 
  WHERE (discount_type = 'discount') 
  AND (discount_published = 1) 
  AND (discount_quota > discount_used_times OR discount_quota = 0) 
  AND (discount_start < 1716063666) 
  AND (discount_end > 1716063666 OR discount_end = 0) 
  AND (discount_product_id IN ('','0','173') OR discount_product_id LIKE '%,173,%') 
  AND (discount_flat_amount != 0 OR discount_percent_amount != 0) 
  AND ((discount_flat_amount = 0 OR discount_currency_id =1)) 
  AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiel

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.03 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1657
14	hikashopCurrencyClass->getProductPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1515
13	hikashopCurrencyClass->getPrices()	JROOT/administrator/components/com_hikashop/classes/cart.php:1134
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.29 ms Na de laatste zoekopdracht: 0.40 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 3.702 MB Regels teruggegeven: 10

SELECT * 
  FROM alnew_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='address'  
  ORDER BY a.`field_ordering` ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	54	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.02 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.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:167
15	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/zone.php:157
14	hikashopZoneClass->getOrderZones()	JROOT/administrator/components/com_hikashop/classes/shipping.php:171
13	hikashopShippingClass->getShippings()	JROOT/administrator/components/com_hikashop/classes/cart.php:1271
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.17 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 3.732 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #36

SELECT * 
  FROM alnew_hikashop_zone 
  WHERE zone_id = '21' 
  LIMIT 0, 1

Verklaren

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

Profiel

Status	Duration
Starting	0.02 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2328
16	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/zone.php:87
15	hikashopZoneClass->getZoneParents()	JROOT/administrator/components/com_hikashop/classes/zone.php:175
14	hikashopZoneClass->getOrderZones()	JROOT/administrator/components/com_hikashop/classes/shipping.php:171
13	hikashopShippingClass->getShippings()	JROOT/administrator/components/com_hikashop/classes/cart.php:1271
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.54 ms Na de laatste zoekopdracht: 0.03 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 3.741 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #37

SELECT a.zone_parent_namekey 
  FROM alnew_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('country_Belgium_21');

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	4095	Using where

Profiel

Status	Duration
Starting	0.02 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.38 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/zone.php:100
15	hikashopZoneClass->getZoneParents()	JROOT/administrator/components/com_hikashop/classes/zone.php:175
14	hikashopZoneClass->getOrderZones()	JROOT/administrator/components/com_hikashop/classes/shipping.php:171
13	hikashopShippingClass->getShippings()	JROOT/administrator/components/com_hikashop/classes/cart.php:1271
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.52 ms Na de laatste zoekopdracht: 0.04 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 3.751 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #38

SELECT a.zone_parent_namekey 
  FROM alnew_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('tax_europe_9728');

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	4095	Using where

Profiel

Status	Duration
Starting	0.01 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.36 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/zone.php:100
16	hikashopZoneClass->getZoneParents()	JROOT/administrator/components/com_hikashop/classes/zone.php:116
15	hikashopZoneClass->getZoneParents()	JROOT/administrator/components/com_hikashop/classes/zone.php:175
14	hikashopZoneClass->getOrderZones()	JROOT/administrator/components/com_hikashop/classes/shipping.php:171
13	hikashopShippingClass->getShippings()	JROOT/administrator/components/com_hikashop/classes/cart.php:1271
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.22 ms Na de laatste zoekopdracht: 0.08 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 3.765 MB Regels teruggegeven: 3

SELECT * 
  FROM alnew_hikashop_shipping  
  WHERE (shipping_currency IN ('','_','all') OR shipping_currency LIKE '%,1,%') 
  ORDER BY shipping_ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_hikashop_shipping	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	3	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.02 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
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/plugins.php:59
15	hikashopPluginsClass->getMethods()	JROOT/administrator/components/com_hikashop/classes/shipping.php:136
14	hikashopShippingClass->getMethods()	JROOT/administrator/components/com_hikashop/classes/shipping.php:177
13	hikashopShippingClass->getShippings()	JROOT/administrator/components/com_hikashop/classes/cart.php:1271
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.26 ms Na de laatste zoekopdracht: 0.29 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 3.783 MB Regels teruggegeven: 7

SELECT * 
  FROM alnew_hikashop_payment  
  WHERE (payment_shipping_methods IN ('','_') OR payment_shipping_methods LIKE '%\nmanual_2\n%' OR payment_shipping_methods LIKE 'manual_2\n%' OR payment_shipping_methods LIKE '%\nmanual_2' OR payment_shipping_methods LIKE 'manual_2') 
  AND (payment_currency IN ('','_','all') OR payment_currency LIKE '%,1,%') 
  ORDER BY payment_ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_hikashop_payment	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	8	Using where; Gebruikt bestandssortering

Profiel

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.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.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/plugins.php:59
15	hikashopPluginsClass->getMethods()	JROOT/administrator/components/com_hikashop/classes/payment.php:106
14	hikashopPaymentClass->getMethods()	JROOT/administrator/components/com_hikashop/classes/payment.php:139
13	hikashopPaymentClass->getPayments()	JROOT/administrator/components/com_hikashop/classes/cart.php:1355
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.37 ms Na de laatste zoekopdracht: 0.10 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 3.813 MB Regels teruggegeven: 7

SELECT * 
  FROM alnew_extensions 
  WHERE element IN ('cardsave','creditcard','googlecheckout','paypal','alipay','collectondelivery','paypalexpress') 
  AND folder='hikashoppayment' 
  AND type='plugin' 
  ORDER BY ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	alnew_extensions	range	element_clientid,element_folder_clientid,extension	element_clientid	402	NULL	7	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.02 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.09 ms
Preparing	0.01 ms
Sorting result	0.01 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/plugins.php:72
15	hikashopPluginsClass->getMethods()	JROOT/administrator/components/com_hikashop/classes/payment.php:106
14	hikashopPaymentClass->getMethods()	JROOT/administrator/components/com_hikashop/classes/payment.php:139
13	hikashopPaymentClass->getPayments()	JROOT/administrator/components/com_hikashop/classes/cart.php:1355
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.17 ms Na de laatste zoekopdracht: 0.17 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 3.830 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #30

SELECT * 
  FROM alnew_hikashop_zone 
  WHERE zone_id = '21' 
  LIMIT 0, 1

Verklaren

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

Profiel

Status	Duration
Starting	0.01 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.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2328
16	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/zone.php:87
15	hikashopZoneClass->getZoneParents()	JROOT/administrator/components/com_hikashop/classes/zone.php:175
14	hikashopZoneClass->getOrderZones()	JROOT/administrator/components/com_hikashop/classes/payment.php:155
13	hikashopPaymentClass->getPayments()	JROOT/administrator/components/com_hikashop/classes/cart.php:1355
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.54 ms Na de laatste zoekopdracht: 0.03 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 3.839 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #31

SELECT a.zone_parent_namekey 
  FROM alnew_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('country_Belgium_21');

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	4095	Using where

Profiel

Status	Duration
Starting	0.02 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.38 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/zone.php:100
15	hikashopZoneClass->getZoneParents()	JROOT/administrator/components/com_hikashop/classes/zone.php:175
14	hikashopZoneClass->getOrderZones()	JROOT/administrator/components/com_hikashop/classes/payment.php:155
13	hikashopPaymentClass->getPayments()	JROOT/administrator/components/com_hikashop/classes/cart.php:1355
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.51 ms Na de laatste zoekopdracht: 0.03 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 3.849 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #32

SELECT a.zone_parent_namekey 
  FROM alnew_hikashop_zone_link AS a 
  WHERE a.zone_child_namekey IN ('tax_europe_9728');

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	4095	Using where

Profiel

Status	Duration
Starting	0.02 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.36 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/zone.php:100
16	hikashopZoneClass->getZoneParents()	JROOT/administrator/components/com_hikashop/classes/zone.php:116
15	hikashopZoneClass->getZoneParents()	JROOT/administrator/components/com_hikashop/classes/zone.php:175
14	hikashopZoneClass->getOrderZones()	JROOT/administrator/components/com_hikashop/classes/payment.php:155
13	hikashopPaymentClass->getPayments()	JROOT/administrator/components/com_hikashop/classes/cart.php:1355
12	hikashopCartClass->getFullCart()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:112
11	hikashopCheckoutHelper->getCart()	JROOT/components/com_hikashop/controllers/checkout.php:106
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.25 ms Na de laatste zoekopdracht: 9.11 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 3.965 MB Regels teruggegeven: 1

SELECT * 
  FROM alnew_extensions 
  WHERE folder='system' 
  AND element='privacyconsent' 
  AND type='plugin'

Verklaren

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

Profiel

Status	Duration
Starting	0.02 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/plugins.php:113
19	hikashopPluginsClass->getByName()	JROOT/administrator/components/com_hikashop/classes/user.php:1268
18	hikashopUserClass->getPrivacyConsentSettings()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:420
17	hikashopCheckoutLoginHelper->loadRegistrationparams()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:386
16	hikashopCheckoutLoginHelper->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:168
15	CheckoutViewCheckout->show()	JROOT/components/com_hikashop/views/checkout/view.html.php:51
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.26 ms Na de laatste zoekopdracht: 2.52 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 3.986 MB Regels teruggegeven: 0

SELECT * 
  FROM alnew_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='user'  
  ORDER BY a.`field_ordering` ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	54	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.02 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:167
19	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:187
18	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:454
17	hikashopCheckoutLoginHelper->initRegistration()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:388
16	hikashopCheckoutLoginHelper->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:168
15	CheckoutViewCheckout->show()	JROOT/components/com_hikashop/views/checkout/view.html.php:51
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.27 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 3.997 MB Regels teruggegeven: 10

SELECT * 
  FROM alnew_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND (a.field_address_type='billing' OR a.field_address_type='') 
  AND a.field_table='address'  
  ORDER BY a.`field_ordering` ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	54	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.02 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.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:167
19	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:187
18	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:473
17	hikashopCheckoutLoginHelper->initRegistration()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:388
16	hikashopCheckoutLoginHelper->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:168
15	CheckoutViewCheckout->show()	JROOT/components/com_hikashop/views/checkout/view.html.php:51
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.19 ms Na de laatste zoekopdracht: 0.53 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 4.039 MB Regels teruggegeven: 1

SELECT * 
  FROM alnew_hikashop_shipping 
  WHERE shipping_id = '2' 
  LIMIT 0, 1

Verklaren

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

Profiel

Status	Duration
Starting	0.01 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2328
21	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/shipping.php:108
20	hikashopShippingClass->get()	JROOT/administrator/components/com_hikashop/helpers/shippingplugin.php:380
19	hikashopShippingPlugin->getShippingAddress()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:189
18	hikashopCheckoutHelper->getShippingAddressOverride()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:479
17	hikashopCheckoutLoginHelper->initRegistration()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:388
16	hikashopCheckoutLoginHelper->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:168
15	CheckoutViewCheckout->show()	JROOT/components/com_hikashop/views/checkout/view.html.php:51
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.26 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 4.050 MB Regels teruggegeven: 10

SELECT * 
  FROM alnew_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND (a.field_address_type='shipping' OR a.field_address_type='') 
  AND a.field_table='address'  
  ORDER BY a.`field_ordering` ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	54	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.02 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.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:167
19	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:187
18	hikashopFieldClass->getFields()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:503
17	hikashopCheckoutLoginHelper->initRegistration()	JROOT/administrator/components/com_hikashop/helpers/checkout/login.php:388
16	hikashopCheckoutLoginHelper->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:168
15	CheckoutViewCheckout->show()	JROOT/components/com_hikashop/views/checkout/view.html.php:51
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.78 ms Na de laatste zoekopdracht: 4.08 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 4.101 MB Regels teruggegeven: 4

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hk_cat	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Gebruikt bestandssortering
1	SIMPLE	hk_parent	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	17	Using where

Profiel

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.05 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Creating tmp table	0.03 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
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:759
20	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:350
19	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:186
18	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/checkout/view.html.php:392
17	CheckoutViewCheckout->loadFields()	JROOT/administrator/components/com_hikashop/helpers/checkout/cart.php:171
16	hikashopCheckoutCartHelper->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:168
15	CheckoutViewCheckout->show()	JROOT/components/com_hikashop/views/checkout/view.html.php:51
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.52 ms Na de laatste zoekopdracht: 0.06 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 4.123 MB Regels teruggegeven: 0

SELECT * 
  FROM alnew_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_display` LIKE '%;checkout=1;%' 
  AND a.field_table='product'  
  AND ((((field_with_sub_categories = 0 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,13,%'))OR (field_with_sub_categories = 1 
  AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%' OR field_categories LIKE '%,13,%'))) 
  AND field_products="") OR (field_products LIKE '%,173,%')) 
  ORDER BY a.`field_ordering` ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	54	Using where; Gebruikt bestandssortering

Profiel

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.11 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.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:167
19	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:187
18	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/checkout/view.html.php:392
17	CheckoutViewCheckout->loadFields()	JROOT/administrator/components/com_hikashop/helpers/checkout/cart.php:171
16	hikashopCheckoutCartHelper->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:168
15	CheckoutViewCheckout->show()	JROOT/components/com_hikashop/views/checkout/view.html.php:51
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.19 ms Na de laatste zoekopdracht: 5.54 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 4.253 MB Regels teruggegeven: 0

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	INDEX KEY ONTBREEKT	NULL	NULL	3	Using where
1	SIMPLE	a	ref\|filter	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype\|idx_client_id_parent_id_alias_language	98\|1	huisansiau_be.b.menutype	4 (29%)	Using where; Using rowid filter

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
21	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:332
20	hikashopCheckoutHelper->completeLink()	JROOT/components/com_hikashop/views/checkout/tmpl/show.php:10
19	include JROOT/components/com_hikashop/views/checkout/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2474
17	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2429
15	hikashopView->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:53
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.29 ms Na de laatste zoekopdracht: 0.05 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 4.264 MB Regels teruggegeven: 3

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	INDEX KEY ONTBREEKT	NULL	NULL	3	Using where
1	SIMPLE	a	ref\|filter	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype\|idx_client_id_parent_id_alias_language	98\|1	huisansiau_be.b.menutype	4 (29%)	Using where; Using rowid filter

Profiel

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.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
21	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/helpers/checkout.php:336
20	hikashopCheckoutHelper->completeLink()	JROOT/components/com_hikashop/views/checkout/tmpl/show.php:10
19	include JROOT/components/com_hikashop/views/checkout/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2474
17	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2429
15	hikashopView->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:53
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.42 ms Na de laatste zoekopdracht: 13.75 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 4.337 MB Regels teruggegeven: 1

SELECT a.id, a.link, a.params 
  FROM alnew_menu AS a 
  INNER JOIN `alnew_menu_types` AS b 
  ON a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND (a.link='index.php?option=com_hikashop&view=category&layout=listing' OR a.link='index.php?option=com_hikashop&view=product&layout=listing') 
  AND a.language IN ('*', '', 'nl-NL')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	INDEX KEY ONTBREEKT	NULL	NULL	3	Using where
1	SIMPLE	a	ref\|filter	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype\|idx_client_id_parent_id_alias_language	98\|1	huisansiau_be.b.menutype	4 (29%)	Using where; Using rowid filter

Profiel

Status	Duration
Starting	0.04 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.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1030
24	hikashop_contentLink()	JROOT/components/com_hikashop/views/checkout/tmpl/show_block_cart.php:226
23	include JROOT/components/com_hikashop/views/checkout/tmpl/show_block_cart.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2474
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/checkout/view.html.php:282
20	CheckoutViewCheckout->displayBlock()	JROOT/components/com_hikashop/views/checkout/tmpl/show.php:42
19	include JROOT/components/com_hikashop/views/checkout/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2474
17	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2429
15	hikashopView->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:53
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.27 ms Na de laatste zoekopdracht: 0.03 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 4.352 MB Regels teruggegeven: 1

SELECT c.category_id 
  FROM alnew_hikashop_product_category AS pc 
  INNER JOIN alnew_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1 
  WHERE pc.product_id = 173 
  ORDER BY pc.product_category_id ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ref	category_id,product_id	product_id	4	const	1	Using where; Gebruikt bestandssortering
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	huisansiau_be.pc.category_id	1	Using where

Profiel

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.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1041
24	hikashop_contentLink()	JROOT/components/com_hikashop/views/checkout/tmpl/show_block_cart.php:226
23	include JROOT/components/com_hikashop/views/checkout/tmpl/show_block_cart.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2474
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/checkout/view.html.php:282
20	CheckoutViewCheckout->displayBlock()	JROOT/components/com_hikashop/views/checkout/tmpl/show.php:42
19	include JROOT/components/com_hikashop/views/checkout/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2474
17	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2429
15	hikashopView->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:53
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.29 ms Na de laatste zoekopdracht: 0.06 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 4.375 MB Regels teruggegeven: 1

SELECT a.id 
  FROM alnew_menu AS a 
  INNER JOIN `alnew_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.access IN (1,1,5) 
  AND a.client_id=0 
  AND a.link='index.php?option=com_hikashop&view=category&layout=listing' 
  AND a.language IN ('*', '', 'nl-NL')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	idx_menutype	INDEX KEY ONTBREEKT	NULL	NULL	3	Using where
1	SIMPLE	a	ref\|filter	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype\|idx_client_id_parent_id_alias_language	98\|1	huisansiau_be.b.menutype	4 (29%)	Using where; Using rowid filter

Profiel

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.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
26	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/menus.php:276
25	hikashopMenusClass->loadAMenuItemId()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1076
24	hikashop_contentLink()	JROOT/components/com_hikashop/views/checkout/tmpl/show_block_cart.php:226
23	include JROOT/components/com_hikashop/views/checkout/tmpl/show_block_cart.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2474
21	hikashopView->loadTemplate()	JROOT/components/com_hikashop/views/checkout/view.html.php:282
20	CheckoutViewCheckout->displayBlock()	JROOT/components/com_hikashop/views/checkout/tmpl/show.php:42
19	include JROOT/components/com_hikashop/views/checkout/tmpl/show.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
18	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2474
17	hikashopView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
16	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2429
15	hikashopView->display()	JROOT/components/com_hikashop/views/checkout/view.html.php:53
14	CheckoutViewCheckout->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2166
12	hikashopController->display()	JROOT/components/com_hikashop/controllers/checkout.php:65
11	checkoutController->display()	JROOT/components/com_hikashop/controllers/checkout.php:213
10	checkoutController->show()	JROOT/components/com_hikashop/controllers/checkout.php:81
9	checkoutController->step()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:2144
7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:92
6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.73 ms Na de laatste zoekopdracht: 13.47 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 4.486 MB Regels teruggegeven: 6

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

  FROM alnew_modules AS m

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

  LEFT JOIN alnew_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 <= '2024-05-18 20:21:06') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-18 20:21:06') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 185 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	8	Using index condition; Using where; Gebruikt bestandssortering
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	huisansiau_be.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	huisansiau_be.m.module,const	1	Using index condition; Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Zelfde als de call in onderstaande regel.
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:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/huisansiau/library/Artx/Page.php:46
8	ArtxPage->containsModules()	JROOT/templates/huisansiau/index.php:59
7	require JROOT/templates/huisansiau/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.22 ms Na de laatste zoekopdracht: 34.29 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 4.580 MB Regels teruggegeven: 0

SELECT uikit

  FROM `alnew_cwgears`

  WHERE url = 'https://www.huisansiau.be/index.php/shop/checkout'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiel

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.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
12	plgSystemCwgears->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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.14 ms Na de laatste zoekopdracht: 0.05 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 4.586 MB Regels teruggegeven: 0

SELECT uikit_plus

  FROM `alnew_cwgears`

  WHERE url = 'https://www.huisansiau.be/index.php/shop/checkout'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiel

Status	Duration
Starting	0.02 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
Executing	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
12	plgSystemCwgears->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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

39 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

5 × SELECT * 
  FROM alnew_hikashop_field as a

4 × SELECT a.zone_parent_namekey 
  FROM alnew_hikashop_zone_link AS a

3 × SELECT * 
  FROM alnew_hikashop_zone

3 × SELECT a.id 
  FROM alnew_menu AS a 
  INNER JOIN `alnew_menu_types` as b 
  on a.menutype = b.menutype

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

2 × SELECT * 
  FROM alnew_hikashop_shipping

```
2 × SELECT * 
  FROM alnew_extensions
```

1 × SELECT `data` 
  FROM `alnew_session`

1 × SELECT id, rules 
  FROM `alnew_viewlevels

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

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

1 × SELECT count(*) 
  FROM `alnew_cwgears_schedule

1 × SELECT count(*) 
  FROM `alnew_cwgears_schedule`

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

1 × SELECT * 
  FROM alnew_hikashop_confi

```
1 × SELECT * 
  FROM alnew_languages
```

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

1 × SELECT cart.cart_id 
  FROM alnew_hikashop_cart AS cart

1 × SELECT * 
  FROM alnew_hikashop_cart

1 × SELECT cart_product.*, product.product_type, product.product_parent_id  
  FROM alnew_hikashop_cart_product AS cart_product  
  LEFT JOIN alnew_hikashop_product AS product 
  ON cart_product.product_id = product.product_id

1 × SELECT shipping_id, shipping_params 
  FROM alnew_hikashop_shipping

1 × SELECT currency_id 
  FROM alnew_hikashop_currency

1 × SELECT cart_product.cart_product_id, cart_product.cart_product_quantity, cart_product.cart_product_option_parent_id, cart_product.cart_product_parent_id, cart_product.cart_product_wishlist_id, product.*  
  FROM alnew_hikashop_cart_product AS cart_product  
  LEFT JOIN alnew_hikashop_product AS product 
  ON cart_product.product_id = product.product_id

1 × SELECT * 
  FROM alnew_hikashop_file

1 × SELECT product_category.*, category.*  
  FROM alnew_hikashop_product_category AS product_category  
  LEFT JOIN alnew_hikashop_category AS category 
  ON product_category.category_id = category.category_id

1 × SELECT product_id 
  FROM alnew_hikashop_product_related

1 × SELECT hk_variant.*, hk_characteristic.*  
  FROM alnew_hikashop_variant AS hk_variant  
  LEFT JOIN alnew_hikashop_characteristic AS hk_characteristic 
  ON hk_variant.variant_characteristic_id = hk_characteristic.characteristic_id

1 × SELECT p.* 
  FROM alnew_hikashop_price as p

1 × SELECT * 
  FROM alnew_hikashop_currency

1 × SELECT b.*,c.* 
  FROM alnew_hikashop_category AS a 
  LEFT JOIN alnew_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN alnew_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey

1 × SELECT * 
  FROM alnew_hikashop_discount

1 × SELECT * 
  FROM alnew_hikashop_payment

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

1 × SELECT a.id, a.link, a.params 
  FROM alnew_menu AS a 
  INNER JOIN `alnew_menu_types` AS b 
  ON a.menutype = b.menutype

1 × SELECT c.category_id 
  FROM alnew_hikashop_product_category AS pc 
  INNER JOIN alnew_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  AND c.category_published = 1

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

1 × SELECT uikit 
  FROM `alnew_cwgears`

1 × SELECT uikit_plus 
  FROM `alnew_cwgears`

ANDERE Tabellen:

1 × UPDATE `alnew_extensions` 
  SET `params` = '{\"mediaversion\":\"f1352a077f0df7124a9402d3fb2c30df\"}'