+49 (0) 4761 886 100 info@thomashilfen-shop.de
KiMeter
 
 

KiMeter

Artikel-Nr.: E92141
Star Rating (0)
 

Lieferzeit 3-5 Werktage

Dieser Artikel steht derzeit nicht zur Verfügung!
Wenn Sie für weitere 35,00 € einkaufen, erhalten Sie Ihre Bestellung versandkostenfrei!
 

Produktinformationen "KiMeter"

Ihr KiMeter ermöglicht Ihnen, den kinesiologischen Muskeltest selbst durchzuführen. Es gibt drei wesentliche Vorteile zum normalen Armtest:

  • Sie benötigen keine zweite Person für einen Test.
  • Die Ergebnisse sind objektiv auf dem Display des KiMeter abzulesen – und Sie brauchen sich nicht auf die Feinfühligkeit der Testperson zu verlassen.
  • Sie können ab sofort überall einen kinesiologischen Test durchführen – ohne großes Aufsehen zu erregen. Im Supermarkt, im Restaurant und auf Reisen – das KiMeter ist überall dabei und bereit für einen Test.

Was kann getestet werden?
Grundsätzlich können Sie alle Einflüsse auf Ihren Körper testen. Die Kinesiologie umfasst hier fast alle Bereiche des Lebens. Es liegt an Ihnen, worauf Sie das KiMeter anwenden möchten.
Als Beispiel seien genannt:
Nahrungsmittel, Kleidung, Schlafplatz und geopathogene Belastungen, homöopathische Mittel, Schüßler Salze, Farben, usw.
Das KiMeter bietet Ihnen die Möglichkeit selbst kreativ zu werden und einmal verschiedene Aspekte Ihres Lebens zu untersuchen.
Technische Daten:
Stromversorgung:
4x Knopfzelle CR2032
(Batterie hält etwa 11 Monate bei 20-maliger täglicher Nutzung)
Maße (L x B x H):
11,5 x 5 x 3,3 cm
Gewicht: 170 g

Weiterführende Links zu "KiMeter"

Weitere Artikel von Thomashilfen

Kundenbewertungen für "KiMeter"

Bewertungen werden nach Überprüfung freigeschaltet.

Bewertung schreiben

Die mit einem * markierten Felder sind Pflichtfelder.

Zuletzt angesehen

Clear cache
4.3.6
detail::index
28x Events / 92x Listeners
114 (0.118331 ms) > 22
0 Mails
26x Cached files
5.4.37-pl0
12.646251678467 MB
16x Function calls
0x Ajax requests
20x Templates
Display storefront
Property name Property value
trustedproxies
db
username => p224247
password => hpnw3032
dbname => usr_p224247_1
host => db3391.mydbserver.com
charset => utf8
adapter => pdo_mysql
port => 3306
snippet
readFromDb => 1
writeToDb => 1
readFromIni => false
writeToIni => false
front
noErrorHandler => false
throwExceptions => false
useDefaultControllerAlways => 1
disableOutputBuffering => false
showException => false
charset => utf-8
template
compileCheck => 1
compileLocking => 1
useSubDirs => 1
forceCompile => false
useIncludePath => 1
charset => utf-8
forceCache => false
cacheDir => /home/www/p224247/html/shopware/cache/templates/
compileDir => /home/www/p224247/html/shopware/cache/templates/
mail
charset => utf-8
httpcache
enabled => 1
debug => false
default_ttl => 0
private_headers => Array ( )
allow_reload => false
allow_revalidate => false
stale_while_revalidate => 2
stale_if_error => false
cache_dir => /home/www/p224247/html/shopware/cache/html/
cache_cookies => Array ( )
session
name => SHOPWARESID
cookie_lifetime => 0
use_trans_sid => false
gc_probability => 1
gc_divisor => 100
save_handler => db
phpsettings
error_reporting => 32767
display_errors => 1
date.timezone => Europe/Berlin
zend.ze1_compatibility_mode => 0
cache
frontendOptions => Array ( )
backend => File
backendOptions => Array ( )
hook
proxyDir => /home/www/p224247/html/shopware/cache/proxies/
proxyNamespace => Shopware_Proxies
model
autoGenerateProxyClasses => false
fileCacheDir => /home/www/p224247/html/shopware/cache/doctrine/filecache/
attributeDir => /home/www/p224247/html/shopware/cache/doctrine/attributes/
proxyDir => /home/www/p224247/html/shopware/cache/doctrine/proxies/
proxyNamespace => Shopware\Proxies
cacheProvider => auto
cacheNamespace => null
config
store
apiEndpoint => https://api.shopware.com
custom
backendsession
name => SHOPWAREBACKEND
cookie_lifetime => 0
cookie_httponly => 1
use_trans_sid => false
referer_check => 1
client_check => false
plugins
Property name Property value
Class
0 => Enlight_Controller_Request_RequestHttp
Module
0 => frontend
Controller
0 => detail
Action
0 => index
IP
0 => 54.205.37.110
Http host
0 => www.alltagshilfen.de
Request uri
0 => /freizeit/kimeter/1325/kimeter
Scheme
0 => http
Server
REDIRECT_TMP => /home/www/p224247/tmp
REDIRECT_TEMP => /home/www/p224247/tmp
REDIRECT_TMPDIR => /home/www/p224247/tmp
REDIRECT_MAGICK_TMPDIR => /home/www/p224247/tmp
REDIRECT_MAGICK_TEMPORARY_PATH => /home/www/p224247/tmp
REDIRECT_STATUS => 200
HTTP_AUTHORIZATION =>
TMP => /home/www/p224247/tmp
TEMP => /home/www/p224247/tmp
TMPDIR => /home/www/p224247/tmp
MAGICK_TMPDIR => /home/www/p224247/tmp
MAGICK_TEMPORARY_PATH => /home/www/p224247/tmp
HTTP_HOST => www.alltagshilfen.de
HTTP_ACCEPT_ENCODING => x-gzip, gzip, deflate
HTTP_USER_AGENT => CCBot/2.0 (http://commoncrawl.org/faq/)
HTTP_ACCEPT_LANGUAGE => en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
PATH => /bin:/sbin:/usr/bin:/usr/sbin
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache
SERVER_NAME => www.alltagshilfen.de
SERVER_ADDR => 172.20.133.91
SERVER_PORT => 80
REMOTE_ADDR => 54.205.37.110
DOCUMENT_ROOT => /home/www/p224247/html/shopware/
SERVER_ADMIN => [no address given]
SCRIPT_FILENAME => /home/www/p224247/html/shopware/shopware.php
REMOTE_PORT => 32882
REDIRECT_URL => /freizeit/kimeter/1325/kimeter
GATEWAY_INTERFACE => CGI/1.1
SERVER_PROTOCOL => HTTP/1.0
REQUEST_METHOD => GET
QUERY_STRING =>
REQUEST_URI => /freizeit/kimeter/1325/kimeter
SCRIPT_NAME => /shopware.php
PHP_SELF => /shopware.php
REQUEST_TIME_FLOAT => 1432850159.98
REQUEST_TIME => 1432850159
HTTP_SURROGATE_CAPABILITY => shopware="ESI/1.0", symfony2="ESI/1.0"
HTTP_X_FORWARDED_FOR => 54.205.37.110
HTTPS => null
Base url
0 =>
Base url (raw)
0 =>
Parameters
rewriteAlias => 1
sViewport => detail
sArticle => 1325
controller => detail
sCategory => 180
Path information
0 => /freizeit/kimeter/1325/kimeter
Base path
0 =>
Header
Host => www.alltagshilfen.de
Accept-Encoding => x-gzip, gzip, deflate
User-Agent => CCBot/2.0 (http://commoncrawl.org/faq/)
Accept-Language => en-us,en-gb,en;q=0.7,*;q=0.3
Accept => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

Response

Property name Property value
Class
0 => Enlight_Controller_Response_ResponseHttp
Raw header
Response code
0 => 200
Exception
Property name Property value
sessionId
0 => 3c923882c403d49327d4fe6b35c4405e8fc9e13c
Bot
0 => 1
sOutputNet
0 => false
sRegister
billing => Array ( )
sUserId
sCountry
0 => 2
sState
sArea
sOrderVariables
sPaymentID
netiFreeDelivery
dispatchID => 10
shippingFreeLimit => 35
shippingSteps => Array ( )
check => 2110
sDispatch
0 => 10
id
0 => 3c923882c403d49327d4fe6b35c4405e8fc9e13c

Cookies

Cookie name Cookie value
Property name Property value
Loaded templates
0 => frontend/detail/index.tpl
1 => frontend/plugins/index.tpl
2 => frontend/plugins/hpnw_template/header.tpl
3 => frontend/plugins/compare/index.tpl
4 => frontend/plugins/seo/index.tpl
5 => frontend/plugins/google/index.tpl
6 => frontend/fbInit.tpl
7 => frontend/plugins/webg_seototal/rating.tpl
8 => frontend/plugins/webg_seototal/lazy.tpl
9 => frontend/plugins/webg_seototal/index.tpl
10 => frontend/plugins/webg_seototal/data.tpl
11 => frontend/plugins/advanced_menu/index.tpl
12 => frontend/netiFreeDelivery/templateExtensions.tpl
13 => frontend/plugins/PreisAufAnfrage/ajax_add_article.tpl
14 => frontend/plugins/PreisAufAnfrage/index.tpl
15 => frontend/plugins/PreisAufAnfrage/col.tpl
16 => frontend/plugins/PreisAufAnfrage/data.tpl
17 => frontend/plugins/PreisAufAnfrage/item.tpl
18 => frontend/plugins/PreisAufAnfrage/box_similar.tpl
19 => frontend/plugins/swag_profiling/index.tpl
Cache directory
0 => /home/www/p224247/html/shopware/cache/templates/
Compile directory
0 => /home/www/p224247/html/shopware/cache/templates/
Config directory
0 => ./configs/
Config variables
Debug template
0 => file:/home/www/p224247/html/shopware/engine/Library/Smarty//debug.tpl
Plugin directories
0 => /home/www/p224247/html/shopware/engine/Library/Enlight/Template/Plugins/
1 => /home/www/p224247/html/shopware/engine/Library/Smarty/plugins/
Template directories
custom => /home/www/p224247/html/shopware/templates/alltagshilfen/
local => /home/www/p224247/html/shopware/templates/_local/
emotion => /home/www/p224247/html/shopware/templates/_default/
default => /home/www/p224247/html/shopware/templates/_default/
base => templates/
include_dir => ./
payment => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Default/Core/PaymentMethods/Views/
0 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Community/Frontend/HPNWGeoip/Views/
1 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Community/Frontend/HpnwTemplate/Views/
2 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Community/Frontend/NetiSocialLogin/Views/
3 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Community/Frontend/WebgSeoTotal/Views/
4 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Community/Frontend/NetiFreeDelivery/Views/
5 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Default/Frontend/PiPaymorrowPayment/Views/
6 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Community/Frontend/sKUZOPreisAufAnfrage/view/
7 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Community/Backend/SwagMigration/Views/
8 => /home/www/p224247/html/shopware/engine/Shopware/Plugins/Community/Frontend/SwagProfiling/Views/
Assignments
sAction => index
sErrorFlag => Array ( )
sFormData => Array ( )
sInquiry => http://www.alltagshilfen.de/support/index/sFid/16/sInquiry/detail/sOrdernumber/E92141
sBreadcrumb => Array ( )
sCategoryInfo => Array ( )
sArticle => Array ( )
rand => c501b3d378178cc0de90bb06415d751f
HPNWTemplateConfig => Enlight_Config
sCompareShow => 1
SeoMetaDescription => Kinesiologischer Muskeltest selbstständig ausführen. | alltagshilfen.de
sLastArticlesShow => 1
GoogleTrackingID => UA-55935968-1
GoogleAnonymizeIp => 1
netiSocialLogin_fb_appId =>
SeoTotalConfig => Enlight_Config
HostConfig => www.alltagshilfen.de
sAdvancedMenu => Array ( )
config => Enlight_Config
img => http://www.alltagshilfen.de/engine/Shopware/Plugins/Community/Frontend/NetiFreeDelivery/images/delivery.png
netiFreeDelivery => Wenn Sie für weitere 35,00 € einkaufen, erhalten Sie Ihre Bestellung versandkostenfrei!
pi_Paymorrow_lang => Array ( )
pi_Paymorrow_Viewport => detail
preisAufAnfrageFormLink =>
preisAufAnfrageAttrID => attr
Controller => detail
Shopware => Shopware
sBasketQuantity => 0
sBasketAmount => 0
sNotesQuantity => 0
sUserLoggedIn => false
Shop => Shopware\Models\Shop\Shop
Locale => de_DE
sCategoryStart => 93
sCategoryCurrent => 180
sCategories => Array ( )
sMainCategories => Array ( )
sOutputNet => false
sMenu => Array ( )
sShopname => Alltagshilfen
  • notifyUntil
    Enlight_Controller_Router_Route (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_RouterRewrite_Bootstrap:: onRoute:: 0
    • Shopware_Plugins_Frontend_RouterOld_Bootstrap:: onRoute:: 10
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Enlight_Controller_Router_Default
    request => Enlight_Controller_Request_RequestHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • filter
    Enlight_Controller_Router_FilterRouteParams (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    Before-Listener-Triggered

    sViewport => detail
    sArticle => 1325

    After-Listener-Triggered

    sViewport => detail
    sArticle => 1325
  • notifyUntil
    Enlight_Controller_Dispatcher_ControllerPath_Frontend_Detail (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Enlight_Controller_Dispatcher_Default
    request => Enlight_Controller_Request_RequestHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_Init (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Enlight_Controller_Plugins_ViewRenderer_Bootstrap:: onActionInit:: 400
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_Init_Frontend_Detail (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_PreDispatch (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Core_HttpCache_Bootstrap:: onPreDispatch:: 0
    • Shopware_Plugins_Frontend_HPNWAvalara_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Backend_Auth_Bootstrap:: onPreDispatchBackend:: 0
    • Shopware_Plugins_Backend_StoreApi_Bootstrap:: onPreDispatch:: 0
    • Enlight_Controller_Plugins_ViewRenderer_Bootstrap:: onPreDispatch:: 400
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • filter
    Shopware_Components_Password_Manager_AddEncoder (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Core_PasswordEncoder_Bootstrap:: onAddEncoder:: 0
    • Shopware_Plugins_Backend_SwagMigration_Bootstrap:: onAddPasswordEncoder:: 0
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Plugins_Core_PasswordEncoder_Bootstrap

    Before-Listener-Triggered

    After-Listener-Triggered

  • notifyUntil
    Shopware_Modules_Admin_GetUserData_Start (0 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_sAdminProxy

    Before-Listener-Triggered

    After-Listener-Triggered

  • filter
    Shopware_Modules_Admin_GetUserData_FilterResult (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_sAdminProxy
    id => null

    Before-Listener-Triggered

    additional => Array ( )

    After-Listener-Triggered

    additional => Array ( )
  • notify
    Enlight_Controller_Action_PreDispatch_Frontend (8.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_PreDispatch_Frontend_Detail (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notifyUntil
    Enlight_Controller_Action_Frontend_Detail_Index (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy

    Before-Listener-Triggered

    After-Listener-Triggered

  • filter
    Shopware_Modules_Articles_GetArticleById_FilterSQL (2.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_sArticlesProxy
    id => 1325
    customergroup => EK

    Before-Listener-Triggered

    0 => SELECT a.id as articleID, aDetails.id as articleDetailsID, TRIM(ordernumber) as ordernumber, datum, additionaltext, aDetails.shippingtime, aDetails.shippingfree, aDetails.instock, aDetails.minpurchase, notification, aDetails.purchasesteps, aDetails.maxpurchase, aDetails.purchaseunit, aDetails.referenceunit, aDetails.packunit, aDetails.suppliernumber, aDetails.ean, aDetails.width, aDetails.length, aDetails.height, weight, a.laststock, aDetails.unitID, a.template, a.pricegroupID, a.pricegroupActive, a.mode, a.taxID, a.description AS description, a.metaTitle, a.keywords, a.description_long, aSupplier.name AS supplierName, aSupplier.img AS supplierImg, aSupplier.id AS supplierID, aSupplier.description AS supplierDescription, a.name AS articleName, IFNULL(p.price,p2.price) as price, sales, IF(p.pseudoprice,p.pseudoprice,p2.pseudoprice) as pseudoprice, IFNULL(p.pricegroup,p2.pricegroup) as pricegroup, tax, attr1,attr2,attr3,attr4,attr5,attr6,attr7,attr8,attr9,attr10, attr11,attr12,attr13,attr14,attr15,attr16,attr17,attr18,attr19,attr20, filtergroupID, a.crossbundlelook, IF(aDetails.releasedate > CURDATE(), 1, 0) as sUpcoming, IF(aDetails.releasedate > CURDATE(), aDetails.releasedate, '') as sReleasedate FROM s_articles a INNER JOIN s_articles_categories_ro ac ON ac.articleID = a.id AND ac.categoryID = 93 INNER JOIN s_categories c ON c.id = ac.categoryID AND c.active = 1 JOIN s_articles_details aDetails ON aDetails.id=a.main_detail_id JOIN s_core_tax AS aTax ON a.taxID=aTax.id JOIN s_articles_attributes AS aAttributes ON aAttributes.articledetailsID=aDetails.id LEFT JOIN s_articles_prices AS p ON p.articledetailsID=aDetails.id AND p.pricegroup='EK' AND p.from='1' LEFT JOIN s_articles_prices AS p2 ON p2.articledetailsID=aDetails.id AND p2.pricegroup='EK' AND p2.from='1' LEFT JOIN s_articles_supplier AS aSupplier ON aSupplier.id=a.supplierID LEFT JOIN s_articles_avoid_customergroups ag ON ag.articleID=a.id AND ag.customergroupID=1 WHERE a.id=1325 AND ag.articleID IS NULL AND a.active=1

    After-Listener-Triggered

    0 => SELECT a.id as articleID, aDetails.id as articleDetailsID, TRIM(ordernumber) as ordernumber, datum, additionaltext, aDetails.shippingtime, aDetails.shippingfree, aDetails.instock, aDetails.minpurchase, notification, aDetails.purchasesteps, aDetails.maxpurchase, aDetails.purchaseunit, aDetails.referenceunit, aDetails.packunit, aDetails.suppliernumber, aDetails.ean, aDetails.width, aDetails.length, aDetails.height, weight, a.laststock, aDetails.unitID, a.template, a.pricegroupID, a.pricegroupActive, a.mode, a.taxID, a.description AS description, a.metaTitle, a.keywords, a.description_long, aSupplier.name AS supplierName, aSupplier.img AS supplierImg, aSupplier.id AS supplierID, aSupplier.description AS supplierDescription, a.name AS articleName, IFNULL(p.price,p2.price) as price, sales, IF(p.pseudoprice,p.pseudoprice,p2.pseudoprice) as pseudoprice, IFNULL(p.pricegroup,p2.pricegroup) as pricegroup, tax, attr1,attr2,attr3,attr4,attr5,attr6,attr7,attr8,attr9,attr10, attr11,attr12,attr13,attr14,attr15,attr16,attr17,attr18,attr19,attr20, filtergroupID, a.crossbundlelook, IF(aDetails.releasedate > CURDATE(), 1, 0) as sUpcoming, IF(aDetails.releasedate > CURDATE(), aDetails.releasedate, '') as sReleasedate FROM s_articles a INNER JOIN s_articles_categories_ro ac ON ac.articleID = a.id AND ac.categoryID = 93 INNER JOIN s_categories c ON c.id = ac.categoryID AND c.active = 1 JOIN s_articles_details aDetails ON aDetails.id=a.main_detail_id JOIN s_core_tax AS aTax ON a.taxID=aTax.id JOIN s_articles_attributes AS aAttributes ON aAttributes.articledetailsID=aDetails.id LEFT JOIN s_articles_prices AS p ON p.articledetailsID=aDetails.id AND p.pricegroup='EK' AND p.from='1' LEFT JOIN s_articles_prices AS p2 ON p2.articledetailsID=aDetails.id AND p2.pricegroup='EK' AND p2.from='1' LEFT JOIN s_articles_supplier AS aSupplier ON aSupplier.id=a.supplierID LEFT JOIN s_articles_avoid_customergroups ag ON ag.articleID=a.id AND ag.customergroupID=1 WHERE a.id=1325 AND ag.articleID IS NULL AND a.active=1
  • filter
    Shopware_Modules_Articles_GetArticleById_FilterArticle (2.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_sArticlesProxy
    id => 1325
    customergroup => EK

    Before-Listener-Triggered

    articleID => 1325
    articleDetailsID => 2040
    ordernumber => E92141
    datum => 2014-04-23
    additionaltext =>
    shippingtime => 3-5
    shippingfree => 0
    instock => 0
    minpurchase => 0
    notification => 0
    purchasesteps => 0
    maxpurchase => 0
    purchaseunit => 0.0000
    referenceunit => 0.000
    packunit =>
    suppliernumber =>
    ean =>
    width => 0.000
    length => 0.000
    height => 0.000
    weight => 0.000
    laststock => 1
    unitID => null
    template =>
    pricegroupID => null
    pricegroupActive => 0
    mode => 0
    taxID => 1
    description => Kinesiologischer Muskeltest selbstständig ausführen. | alltagshilfen.de
    metaTitle => KiMeter | alltagshilfen.de
    keywords => KiMeter, Muskeln, Muskeltest, Arm, Einflüsse, Körper, Nahrungsmittel
    description_long =>

    Ihr KiMeter ermöglicht Ihnen, den kinesiologischen Muskeltest selbst durchzuführen. Es gibt drei wesentliche Vorteile zum normalen Armtest:

    • Sie benötigen keine zweite Person für einen Test.
    • Die Ergebnisse sind objektiv auf dem Display des KiMeter abzulesen – und Sie brauchen sich nicht auf die Feinfühligkeit der Testperson zu verlassen.
    • Sie können ab sofort überall einen kinesiologischen Test durchführen – ohne großes Aufsehen zu erregen. Im Supermarkt, im Restaurant und auf Reisen – das KiMeter ist überall dabei und bereit für einen Test.

    Was kann getestet werden?
    Grundsätzlich können Sie alle Einflüsse auf Ihren Körper testen. Die Kinesiologie umfasst hier fast alle Bereiche des Lebens. Es liegt an Ihnen, worauf Sie das KiMeter anwenden möchten.
    Als Beispiel seien genannt:
    Nahrungsmittel, Kleidung, Schlafplatz und geopathogene Belastungen, homöopathische Mittel, Schüßler Salze, Farben, usw.
    Das KiMeter bietet Ihnen die Möglichkeit selbst kreativ zu werden und einmal verschiedene Aspekte Ihres Lebens zu untersuchen.
    Technische Daten:
    Stromversorgung:
    4x Knopfzelle CR2032
    (Batterie hält etwa 11 Monate bei 20-maliger täglicher Nutzung)
    Maße (L x B x H):
    11,5 x 5 x 3,3 cm
    Gewicht: 170 g

    supplierName => Thomashilfen
    supplierImg =>
    supplierID => 1
    supplierDescription => null
    articleName => KiMeter
    price => 125.21008403361
    sales => 2
    pseudoprice => 0
    pricegroup => EK
    tax => 19.00
    attr1 =>
    attr2 =>
    attr3 =>
    attr4 =>
    attr5 =>
    attr6 =>
    attr7 =>
    attr8 =>
    attr9 =>
    attr10 =>
    attr11 =>
    attr12 =>
    attr13 =>
    attr14 =>
    attr15 =>
    attr16 =>
    attr17 => null
    attr18 =>
    attr19 =>
    attr20 =>
    filtergroupID => 1
    crossbundlelook => 0
    sUpcoming => 0
    sReleasedate =>

    After-Listener-Triggered

    articleID => 1325
    articleDetailsID => 2040
    ordernumber => E92141
    datum => 2014-04-23
    additionaltext =>
    shippingtime => 3-5
    shippingfree => 0
    instock => 0
    minpurchase => 0
    notification => 0
    purchasesteps => 0
    maxpurchase => 0
    purchaseunit => 0.0000
    referenceunit => 0.000
    packunit =>
    suppliernumber =>
    ean =>
    width => 0.000
    length => 0.000
    height => 0.000
    weight => 0.000
    laststock => 1
    unitID => null
    template =>
    pricegroupID => null
    pricegroupActive => 0
    mode => 0
    taxID => 1
    description => Kinesiologischer Muskeltest selbstständig ausführen. | alltagshilfen.de
    metaTitle => KiMeter | alltagshilfen.de
    keywords => KiMeter, Muskeln, Muskeltest, Arm, Einflüsse, Körper, Nahrungsmittel
    description_long =>

    Ihr KiMeter ermöglicht Ihnen, den kinesiologischen Muskeltest selbst durchzuführen. Es gibt drei wesentliche Vorteile zum normalen Armtest:

    • Sie benötigen keine zweite Person für einen Test.
    • Die Ergebnisse sind objektiv auf dem Display des KiMeter abzulesen – und Sie brauchen sich nicht auf die Feinfühligkeit der Testperson zu verlassen.
    • Sie können ab sofort überall einen kinesiologischen Test durchführen – ohne großes Aufsehen zu erregen. Im Supermarkt, im Restaurant und auf Reisen – das KiMeter ist überall dabei und bereit für einen Test.

    Was kann getestet werden?
    Grundsätzlich können Sie alle Einflüsse auf Ihren Körper testen. Die Kinesiologie umfasst hier fast alle Bereiche des Lebens. Es liegt an Ihnen, worauf Sie das KiMeter anwenden möchten.
    Als Beispiel seien genannt:
    Nahrungsmittel, Kleidung, Schlafplatz und geopathogene Belastungen, homöopathische Mittel, Schüßler Salze, Farben, usw.
    Das KiMeter bietet Ihnen die Möglichkeit selbst kreativ zu werden und einmal verschiedene Aspekte Ihres Lebens zu untersuchen.
    Technische Daten:
    Stromversorgung:
    4x Knopfzelle CR2032
    (Batterie hält etwa 11 Monate bei 20-maliger täglicher Nutzung)
    Maße (L x B x H):
    11,5 x 5 x 3,3 cm
    Gewicht: 170 g

    supplierName => Thomashilfen
    supplierImg =>
    supplierID => 1
    supplierDescription => null
    articleName => KiMeter
    price => 125.21008403361
    sales => 2
    pseudoprice => 0
    pricegroup => EK
    tax => 19.00
    attr1 =>
    attr2 =>
    attr3 =>
    attr4 =>
    attr5 =>
    attr6 =>
    attr7 =>
    attr8 =>
    attr9 =>
    attr10 =>
    attr11 =>
    attr12 =>
    attr13 =>
    attr14 =>
    attr15 =>
    attr16 =>
    attr17 => null
    attr18 =>
    attr19 =>
    attr20 =>
    filtergroupID => 1
    crossbundlelook => 0
    sUpcoming => 0
    sReleasedate =>
  • notify
    Shopware_Modules_Articles_GetArticlePictures_Start (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_sArticlesProxy
    id => 1325

    Before-Listener-Triggered

    After-Listener-Triggered

  • filter
    Shopware_Modules_Articles_GetArticlePictures_FilterResult (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_sArticlesProxy
    id => 1325

    Before-Listener-Triggered

    src => Array ( )
    res => Array ( )
    position => 5
    extension => jpg
    main => 1
    id => 4097
    parentId => null
    attribute => Array ( )

    After-Listener-Triggered

    src => Array ( )
    res => Array ( )
    position => 5
    extension => jpg
    main => 1
    id => 4097
    parentId => null
    attribute => Array ( )
  • notify
    Enlight_Controller_Router_PreAssemble (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Enlight_Controller_Router_Default
    request => Enlight_Controller_Request_RequestHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • filter
    Enlight_Controller_Router_FilterAssembleParams (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Core_Router_Bootstrap:: onFilterAssemble:: 0
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Enlight_Controller_Router_Default
    request => Enlight_Controller_Request_RequestHttp

    Before-Listener-Triggered

    sViewport => detail
    sArticle => 1325
    sCategory => 180
    title => KiMeter
    module => frontend

    After-Listener-Triggered

    sViewport => detail
    sArticle => 1325
    sCategory => 180
    title => KiMeter
    module => frontend
  • notifyUntil
    Enlight_Controller_Router_Assemble (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_RouterRewrite_Bootstrap:: onAssemble:: 0
    • Shopware_Plugins_Frontend_RouterRewrite_Bootstrap:: onAssemble:: 0
    • Shopware_Plugins_Core_Router_Bootstrap:: onAssemble:: 100
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Enlight_Controller_Router_Default
    request => Enlight_Controller_Request_RequestHttp
    params => false
    userParams => false

    Before-Listener-Triggered

    After-Listener-Triggered

  • filter
    Enlight_Controller_Router_FilterUrl (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Core_Router_Bootstrap:: onFilterUrl:: 0
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Enlight_Controller_Router_Default
    request => Enlight_Controller_Request_RequestHttp
    params => false
    userParams => false

    Before-Listener-Triggered

    0 => kimeter/1325?c=180

    After-Listener-Triggered

    0 => kimeter/1325?c=180
  • filter
    Shopware_Modules_Articles_GetArticleById_FilterResult (2.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_sArticlesProxy
    id => 1325
    isBlog => null
    customergroup => EK

    Before-Listener-Triggered

    articleID => 1325
    articleDetailsID => 2040
    ordernumber => E92141
    datum => 2014-04-23
    additionaltext =>
    shippingtime => 3-5
    shippingfree => 0
    instock => 0
    minpurchase => 1
    notification => 0
    purchasesteps => 1
    maxpurchase => 100
    referenceunit => 0.000
    packunit =>
    suppliernumber =>
    ean =>
    width => 0.000
    length => 0.000
    height => 0.000
    weight => 0.000
    laststock => 1
    unitID => null
    template =>
    pricegroupID => null
    pricegroupActive => 0
    mode => 0
    taxID => 1
    description => Kinesiologischer Muskeltest selbstständig ausführen. | alltagshilfen.de
    metaTitle => KiMeter | alltagshilfen.de
    keywords => KiMeter, Muskeln, Muskeltest, Arm, Einflüsse, Körper, Nahrungsmittel
    description_long =>

    Ihr KiMeter ermöglicht Ihnen, den kinesiologischen Muskeltest selbst durchzuführen. Es gibt drei wesentliche Vorteile zum normalen Armtest:

    • Sie benötigen keine zweite Person für einen Test.
    • Die Ergebnisse sind objektiv auf dem Display des KiMeter abzulesen – und Sie brauchen sich nicht auf die Feinfühligkeit der Testperson zu verlassen.
    • Sie können ab sofort überall einen kinesiologischen Test durchführen – ohne großes Aufsehen zu erregen. Im Supermarkt, im Restaurant und auf Reisen – das KiMeter ist überall dabei und bereit für einen Test.

    Was kann getestet werden?
    Grundsätzlich können Sie alle Einflüsse auf Ihren Körper testen. Die Kinesiologie umfasst hier fast alle Bereiche des Lebens. Es liegt an Ihnen, worauf Sie das KiMeter anwenden möchten.
    Als Beispiel seien genannt:
    Nahrungsmittel, Kleidung, Schlafplatz und geopathogene Belastungen, homöopathische Mittel, Schüßler Salze, Farben, usw.
    Das KiMeter bietet Ihnen die Möglichkeit selbst kreativ zu werden und einmal verschiedene Aspekte Ihres Lebens zu untersuchen.
    Technische Daten:
    Stromversorgung:
    4x Knopfzelle CR2032
    (Batterie hält etwa 11 Monate bei 20-maliger täglicher Nutzung)
    Maße (L x B x H):
    11,5 x 5 x 3,3 cm
    Gewicht: 170 g

    supplierName => Thomashilfen
    supplierImg =>
    supplierID => 1
    supplierDescription => null
    articleName => KiMeter
    price => 149,00
    sales => 2
    pseudoprice => 0
    pricegroup => EK
    tax => 19.00
    attr1 =>
    attr2 =>
    attr3 =>
    attr4 =>
    attr5 =>
    attr6 =>
    attr7 =>
    attr8 =>
    attr9 =>
    attr10 =>
    attr11 =>
    attr12 =>
    attr13 =>
    attr14 =>
    attr15 =>
    attr16 =>
    attr17 => null
    attr18 =>
    attr19 =>
    attr20 =>
    filtergroupID => 1
    crossbundlelook => false
    sUpcoming => 0
    sReleasedate =>
    sLinks => Array ( )
    categoryID => 180
    sRelatedArticles => Array ( )
    sSimilarArticles => Array ( )
    esd => false
    sBlockPrices => Array ( )
    sVariants => Array ( )
    priceStartingFrom => 0
    image => Array ( )
    images => Array ( )
    linkBasket => shopware.php?sViewport=basket&sAdd=E92141
    linkDetails => shopware.php?sViewport=detail&sArticle=1325&sCategory=180
    linkDetailsRewrited => http://www.alltagshilfen.de/kimeter/1325?c=180
    linkNote => shopware.php?sViewport=note&sAdd=E92141
    linkTellAFriend => shopware.php?sViewport=tellafriend&sDetails=1325
    linkCheaper => shopware.php?sViewport=cheaper&sDetails=1325
    sDownloads => Array ( )
    sAccessories => false
    sVoteAverange => Array ( )
    sVoteComments => Array ( )
    sProperties => Array ( )
    sNavigation => Array ( )
    sDescriptionKeywords => KiMeter, Sie, Ihnen, –, selbst, Es, überall, kinesiologischen, Schüßler, usw., Farben, Salze, kreativ, einmal, verschiedene, Mittel, Möglichkeit, bietet, Das, geopathogene

    After-Listener-Triggered

    articleID => 1325
    articleDetailsID => 2040
    ordernumber => E92141
    datum => 2014-04-23
    additionaltext =>
    shippingtime => 3-5
    shippingfree => 0
    instock => 0
    minpurchase => 1
    notification => 0
    purchasesteps => 1
    maxpurchase => 100
    referenceunit => 0.000
    packunit =>
    suppliernumber =>
    ean =>
    width => 0.000
    length => 0.000
    height => 0.000
    weight => 0.000
    laststock => 1
    unitID => null
    template =>
    pricegroupID => null
    pricegroupActive => 0
    mode => 0
    taxID => 1
    description => Kinesiologischer Muskeltest selbstständig ausführen. | alltagshilfen.de
    metaTitle => KiMeter | alltagshilfen.de
    keywords => KiMeter, Muskeln, Muskeltest, Arm, Einflüsse, Körper, Nahrungsmittel
    description_long =>

    Ihr KiMeter ermöglicht Ihnen, den kinesiologischen Muskeltest selbst durchzuführen. Es gibt drei wesentliche Vorteile zum normalen Armtest:

    • Sie benötigen keine zweite Person für einen Test.
    • Die Ergebnisse sind objektiv auf dem Display des KiMeter abzulesen – und Sie brauchen sich nicht auf die Feinfühligkeit der Testperson zu verlassen.
    • Sie können ab sofort überall einen kinesiologischen Test durchführen – ohne großes Aufsehen zu erregen. Im Supermarkt, im Restaurant und auf Reisen – das KiMeter ist überall dabei und bereit für einen Test.

    Was kann getestet werden?
    Grundsätzlich können Sie alle Einflüsse auf Ihren Körper testen. Die Kinesiologie umfasst hier fast alle Bereiche des Lebens. Es liegt an Ihnen, worauf Sie das KiMeter anwenden möchten.
    Als Beispiel seien genannt:
    Nahrungsmittel, Kleidung, Schlafplatz und geopathogene Belastungen, homöopathische Mittel, Schüßler Salze, Farben, usw.
    Das KiMeter bietet Ihnen die Möglichkeit selbst kreativ zu werden und einmal verschiedene Aspekte Ihres Lebens zu untersuchen.
    Technische Daten:
    Stromversorgung:
    4x Knopfzelle CR2032
    (Batterie hält etwa 11 Monate bei 20-maliger täglicher Nutzung)
    Maße (L x B x H):
    11,5 x 5 x 3,3 cm
    Gewicht: 170 g

    supplierName => Thomashilfen
    supplierImg =>
    supplierID => 1
    supplierDescription => null
    articleName => KiMeter
    price => 149,00
    sales => 2
    pseudoprice => 0
    pricegroup => EK
    tax => 19.00
    attr1 =>
    attr2 =>
    attr3 =>
    attr4 =>
    attr5 =>
    attr6 =>
    attr7 =>
    attr8 =>
    attr9 =>
    attr10 =>
    attr11 =>
    attr12 =>
    attr13 =>
    attr14 =>
    attr15 =>
    attr16 =>
    attr17 => null
    attr18 =>
    attr19 =>
    attr20 =>
    filtergroupID => 1
    crossbundlelook => false
    sUpcoming => 0
    sReleasedate =>
    sLinks => Array ( )
    categoryID => 180
    sRelatedArticles => Array ( )
    sSimilarArticles => Array ( )
    esd => false
    sBlockPrices => Array ( )
    sVariants => Array ( )
    priceStartingFrom => 0
    image => Array ( )
    images => Array ( )
    linkBasket => shopware.php?sViewport=basket&sAdd=E92141
    linkDetails => shopware.php?sViewport=detail&sArticle=1325&sCategory=180
    linkDetailsRewrited => http://www.alltagshilfen.de/kimeter/1325?c=180
    linkNote => shopware.php?sViewport=note&sAdd=E92141
    linkTellAFriend => shopware.php?sViewport=tellafriend&sDetails=1325
    linkCheaper => shopware.php?sViewport=cheaper&sDetails=1325
    sDownloads => Array ( )
    sAccessories => false
    sVoteAverange => Array ( )
    sVoteComments => Array ( )
    sProperties => Array ( )
    sNavigation => Array ( )
    sDescriptionKeywords => KiMeter, Sie, Ihnen, –, selbst, Es, überall, kinesiologischen, Schüßler, usw., Farben, Salze, kreativ, einmal, verschiedene, Mittel, Möglichkeit, bietet, Das, geopathogene
  • notify
    Enlight_Controller_Action_PostDispatchSecure_Frontend_Detail (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_PostDispatchSecure_Frontend (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_PostDispatchSecure (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Core_PaymentMethods_Bootstrap:: addPaths:: 0
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_PostDispatch_Frontend_Detail (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_PostDispatch_Frontend (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_HPNWGeoip_Bootstrap:: onPostDispatchFrontend:: 0
    • Shopware_Plugins_Frontend_HPNWTemplate_Bootstrap:: onPostDispatchListing:: 0
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • notify
    Enlight_Controller_Action_PostDispatch (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_Compare_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_Seo_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_TagCloud_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_LastArticles_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_SofagPayment_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_Google_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_NetiSocialLogin_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_WebgSeoTotal_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_AdvancedMenu_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_NetiFreeDelivery_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_PiPaymorrowPayment_Bootstrap:: onPostPaymorrowDispatch:: 0
    • Shopware_Plugins_Frontend_BestitAmazonCBA_Bootstrap:: onPostDispatch:: 0
    • Shopware_Plugins_Frontend_sKUZOPreisAufAnfrage_Bootstrap:: onPostDispatch:: 95
    • Shopware_Plugins_Core_ControllerBase_Bootstrap:: onPostDispatch:: 100
    • Shopware_Plugins_Backend_SwagMigration_Bootstrap:: onPostDispatch:: 110
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onDisplayProfiling:: 200
    • Shopware_Plugins_Core_HttpCache_Bootstrap:: onPostDispatch:: 399
    • Enlight_Controller_Plugins_ViewRenderer_Bootstrap:: onPostDispatch:: 400
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_ShopwareControllersFrontendDetailProxy
    request => Enlight_Controller_Request_RequestHttp
    response => Enlight_Controller_Response_ResponseHttp

    Before-Listener-Triggered

    After-Listener-Triggered

  • filter
    Shopware_Modules_Basket_GetBasket_FilterSQL (1.0E-5 ms)
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: -1000
    • Shopware_Plugins_Frontend_SwagProfiling_Bootstrap:: onEvent:: 1000

    Parameters

    subject => Shopware_Proxies_sBasketProxy

    Before-Listener-Triggered

    0 => SELECT s_order_basket.*, COALESCE (NULLIF(ad.packunit, ''), mad.packunit) AS packunit, a.main_detail_id AS mainDetailId, ad.id AS articleDetailId, ad.minpurchase, a.taxID, ad.instock AS instock, ad.suppliernumber, ad.maxpurchase, ad.purchasesteps, ad.purchaseunit, COALESCE (ad.unitID, mad.unitID) AS unitID, a.laststock, ad.shippingtime, ad.releasedate, ad.releasedate AS sReleaseDate, COALESCE (ad.ean, mad.ean) AS ean, ad.stockmin, s_order_basket_attributes.attribute1 as ob_attr1, s_order_basket_attributes.attribute2 as ob_attr2, s_order_basket_attributes.attribute3 as ob_attr3, s_order_basket_attributes.attribute4 as ob_attr4, s_order_basket_attributes.attribute5 as ob_attr5, s_order_basket_attributes.attribute6 as ob_attr6 FROM s_order_basket LEFT JOIN s_articles_details AS ad ON ad.ordernumber = s_order_basket.ordernumber LEFT JOIN s_articles a ON (a.id = ad.articleID) LEFT JOIN s_articles_details AS mad ON mad.id = a.main_detail_id LEFT JOIN s_order_basket_attributes ON s_order_basket.id = s_order_basket_attributes.basketID WHERE sessionID=? ORDER BY id ASC, datum DESC

    After-Listener-Triggered

    0 => SELECT s_order_basket.*, COALESCE (NULLIF(ad.packunit, ''), mad.packunit) AS packunit, a.main_detail_id AS mainDetailId, ad.id AS articleDetailId, ad.minpurchase, a.taxID, ad.instock AS instock, ad.suppliernumber, ad.maxpurchase, ad.purchasesteps, ad.purchaseunit, COALESCE (ad.unitID, mad.unitID) AS unitID, a.laststock, ad.shippingtime, ad.releasedate, ad.releasedate AS sReleaseDate, COALESCE (ad.ean, mad.ean) AS ean, ad.stockmin, s_order_basket_attributes.attribute1 as ob_attr1, s_order_basket_attributes.attribute2 as ob_attr2, s_order_basket_attributes.attribute3 as ob_attr3, s_order_basket_attributes.attribute4 as ob_attr4, s_order_basket_attributes.attribute5 as ob_attr5, s_order_basket_attributes.attribute6 as ob_attr6 FROM s_order_basket LEFT JOIN s_articles_details AS ad ON ad.ordernumber = s_order_basket.ordernumber LEFT JOIN s_articles a ON (a.id = ad.articleID) LEFT JOIN s_articles_details AS mad ON mad.id = a.main_detail_id LEFT JOIN s_order_basket_attributes ON s_order_basket.id = s_order_basket_attributes.basketID WHERE sessionID=? ORDER BY id ASC, datum DESC
Toggle Params Query Explain
Toggle ... SELECT module, host, license FROM s_core ...
FROM s_core_licenses WHERE active=1
- Table: s_core_licenses select ALL
0.00096
SELECT
module,
host,
license
FROM
s_core_licenses
WHERE
active = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_licenses ALL 16 Using where
Toggle ... SELECT host FROM s_core_shops WHERE `def ...
FROM s_core_shops WHERE `default`=1
- Table: s_core_shops select ALL
0.00079
SELECT
host
FROM
s_core_shops
WHERE
`default` = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_shops ALL 5 Using where
Toggle ... SELECT org_path, main FROM s_core_rewrit ...
FROM s_core_rewrite_urls WHERE path LIKE ? AND subshopID =?
0.00139
string(29) "freizeit/kimeter/1325/kimeter"
int(6)
SELECT
org_path,
main
FROM
s_core_rewrite_urls
WHERE
path LIKE ?
AND subshopID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_rewrite_urls range path path 771 1 Using where
Toggle ... SELECT `s_core_sessions`.* FROM `s_core_ ...
FROM `s_core_sessions` WHERE (((`s_core_sessions`.`id` = '3c923882c403d49327d4fe
0.00122
SELECT
`s_core_sessions`.*
FROM
`s_core_sessions`
WHERE
(
(
(
`s_core_sessions`.`id` = '3c923882c403d49327d4fe6b35c4405e8fc9e13c'
)
)
)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00101
int(6)
int(1)
string(11) "InputFilter"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT id as `key`, m.* FROM s_core_mult ...
FROM s_core_multilanguage m
- Table: m select ALL
0.00078
SELECT
id as `key`,
m.*
FROM
s_core_multilanguage m
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ALL 4
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00094
int(6)
int(1)
string(15) "PasswordEncoder"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT c.*, a.name AS countryarea FROM s ...
FROM s_core_countries c LEFT JOIN s_core_countries_areas a ON a.id = c.areaID AN
0.00096
int(0)
SELECT
c.*,
a.name AS countryarea
FROM
s_core_countries c
LEFT JOIN s_core_countries_areas a ON a.id = c.areaID
AND a.active = 1
WHERE
c.id = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT category_id FROM s_articles_categ ...
FROM s_articles_categories_seo WHERE article_id = :articleId AND shop_id = :shop
0.00100
int(1325)
int(6)
SELECT
category_id
FROM
s_articles_categories_seo
WHERE
article_id = :articleId
AND shop_id = :shopId
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT STRAIGHT_JOIN ac.categoryID as id ...
FROM s_articles_categories_ro ac FORCE INDEX (category_id_by_article_id) INNER J
0.00104
string(6) "%|93|%"
int(1325)
SELECT
STRAIGHT_JOIN ac.categoryID as id
FROM
s_articles_categories_ro ac FORCE INDEX (category_id_by_article_id)
INNER JOIN s_categories c ON ac.categoryID = c.id
AND c.active = 1
AND c.path LIKE ?
LEFT JOIN s_categories c2 ON c2.parent = c.id
WHERE
ac.articleID = ?
AND c2.id IS NULL
ORDER BY
ac.id
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE ac ref category_id_by_article_id category_id_by_article_id 4 const 4 Using where
1 SIMPLE c eq_ref PRIMARY PRIMARY 4 usr_p224247_1.ac.categoryID 1 Using where
1 SIMPLE c2 ref parent,active_query_builder parent 5 usr_p224247_1.ac.categoryID 2 Using where; Using index; Not exists
Toggle ... SELECT a.id as articleID, aDetails.id as ...
FROM s_articles a INNER JOIN s_articles_categories_ro ac ON ac.articleID = a.id
0.00246
SELECT
a.id as articleID,
aDetails.id as articleDetailsID,
TRIM(ordernumber) as ordernumber,
datum,
additionaltext,
aDetails.shippingtime,
aDetails.shippingfree,
aDetails.instock,
aDetails.minpurchase,
notification,
aDetails.purchasesteps,
aDetails.maxpurchase,
aDetails.purchaseunit,
aDetails.referenceunit,
aDetails.packunit,
aDetails.suppliernumber,
aDetails.ean,
aDetails.width,
aDetails.length,
aDetails.height,
weight,
a.laststock,
aDetails.unitID,
a.template,
a.pricegroupID,
a.pricegroupActive,
a.mode,
a.taxID,
a.description AS description,
a.metaTitle,
a.keywords,
a.description_long,
aSupplier.name AS supplierName,
aSupplier.img AS supplierImg,
aSupplier.id AS supplierID,
aSupplier.description AS supplierDescription,
a.name AS articleName,
IFNULL(p.price, p2.price) as price,
sales,
IF(
p.pseudoprice, p.pseudoprice, p2.pseudoprice
) as pseudoprice,
IFNULL(p.pricegroup, p2.pricegroup) as pricegroup,
tax,
attr1,
attr2,
attr3,
attr4,
attr5,
attr6,
attr7,
attr8,
attr9,
attr10,
attr11,
attr12,
attr13,
attr14,
attr15,
attr16,
attr17,
attr18,
attr19,
attr20,
filtergroupID,
a.crossbundlelook,
IF(
aDetails.releasedate > CURDATE(),
1,
0
) as sUpcoming,
IF(
aDetails.releasedate > CURDATE(),
aDetails.releasedate,
''
) as sReleasedate
FROM
s_articles a
INNER JOIN s_articles_categories_ro ac ON ac.articleID = a.id
AND ac.categoryID = 93
INNER JOIN s_categories c ON c.id = ac.categoryID
AND c.active = 1
JOIN s_articles_details aDetails ON aDetails.id = a.main_detail_id
JOIN s_core_tax AS aTax ON a.taxID = aTax.id
JOIN s_articles_attributes AS aAttributes ON aAttributes.articledetailsID = aDetails.id
LEFT JOIN s_articles_prices AS p ON p.articledetailsID = aDetails.id
AND p.pricegroup = 'EK'
AND p.from = '1'
LEFT JOIN s_articles_prices AS p2 ON p2.articledetailsID = aDetails.id
AND p2.pricegroup = 'EK'
AND p2.from = '1'
LEFT JOIN s_articles_supplier AS aSupplier ON aSupplier.id = a.supplierID
LEFT JOIN s_articles_avoid_customergroups ag ON ag.articleID = a.id
AND ag.customergroupID = 1
WHERE
a.id = 1325
AND ag.articleID IS NULL
AND a.active = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY,main_detailID,product_newcomer,get_category_filters PRIMARY 4 const 1
1 SIMPLE c const PRIMARY PRIMARY 4 const 1
1 SIMPLE aDetails const PRIMARY PRIMARY 4 const 1
1 SIMPLE aTax const PRIMARY PRIMARY 4 const 1
1 SIMPLE aAttributes const articledetailsID articledetailsID 5 const 1
1 SIMPLE ac ref articleID,categoryID,articleID_2,categoryID_2,category_id_by_article_id articleID 8 const,const 1 Using index
1 SIMPLE p ref articledetailsID,pricegroup_2,pricegroup articledetailsID 4 const 1
1 SIMPLE p2 ref articledetailsID,pricegroup_2,pricegroup pricegroup_2 100 const,const,const 1
1 SIMPLE aSupplier eq_ref PRIMARY PRIMARY 4 const 1
1 SIMPLE ag const articleID articleID 8 const,const 1 Using where; Using index; Not exists
Toggle ... SELECT objectdata FROM s_core_translatio ...
FROM s_core_translations WHERE objecttype = 'article' AND objectkey = ? AND obje
0.00101
int(1325)
SELECT
objectdata
FROM
s_core_translations
WHERE
objecttype = 'article'
AND objectkey = ?
AND objectlanguage = '6'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT objectdata FROM s_core_translatio ...
FROM s_core_translations WHERE objecttype = 'supplier' AND objectkey = ? AND obj
0.00095
int(1)
SELECT
objectdata
FROM
s_core_translations
WHERE
objecttype = 'supplier'
AND objectkey = ?
AND objectlanguage = '6'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT id, description, link, target FRO ...
FROM s_articles_information WHERE articleID = :articleId
0.00093
string(4) "1325"
SELECT
id,
description,
link,
target
FROM
s_articles_information
WHERE
articleID = :articleId
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT relatedarticle FROM s_articles_re ...
FROM s_articles_relationships WHERE articleID = :articleId
0.00092
string(4) "1325"
SELECT
relatedarticle
FROM
s_articles_relationships
WHERE
articleID = :articleId
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT relatedarticle FROM s_articles_si ...
FROM s_articles_similar WHERE articleID = :articleId
0.00084
string(4) "1325"
SELECT
relatedarticle
FROM
s_articles_similar
WHERE
articleID = :articleId
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT DISTINCT s_articles.id AS related ...
FROM s_articles_categories_ro, s_articles, s_articles_details WHERE s_articles_c
0.00091
int(180)
string(4) "1325"
SELECT
DISTINCT s_articles.id AS relatedarticle
FROM
s_articles_categories_ro,
s_articles,
s_articles_details
WHERE
s_articles_categories_ro.categoryID = :categoryId
AND s_articles.id = s_articles_categories_ro.articleID
AND s_articles.id = s_articles_details.articleID
AND s_articles_details.kind = 1
AND s_articles.id != :articleId
AND s_articles.active = 1
ORDER BY
s_articles_details.sales DESC
LIMIT
3
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT id, serials FROM s_articles_esd W ...
FROM s_articles_esd WHERE articleID=1325 AND articledetailsID=2040
0.00103
SELECT
id,
serials
FROM
s_articles_esd
WHERE
articleID = 1325
AND articledetailsID = 2040
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_articles_esd ref articleID,articledetailsID articleID 4 const 1 Using where
Toggle ... SELECT `from` AS valFrom,`to` AS valTo, ...
FROM s_articles_prices WHERE articledetailsID=:articleDetailsId AND (pricegroup=
0.00089
string(4) "2040"
string(2) "EK"
SELECT
`from` AS valFrom,
`to` AS valTo,
price,
pseudoprice
FROM
s_articles_prices
WHERE
articledetailsID = :articleDetailsId
AND (pricegroup = :priceGroup)
ORDER BY
id ASC
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT price FROM s_articles_prices, s_a ...
FROM s_articles_prices, s_articles_details WHERE s_articles_details.id=s_article
- Table: s_articles_details using file sort
- Table: s_articles_details using temporary table
0.00098
string(2) "EK"
string(4) "1325"
SELECT
price
FROM
s_articles_prices,
s_articles_details
WHERE
s_articles_details.id = s_articles_prices.articledetailsID
AND pricegroup = ?
AND s_articles_details.articleID = ?
GROUP BY
ROUND(price, 2)
ORDER BY
price ASC
LIMIT
2
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_articles_details ref PRIMARY,articleID articleID 4 const 1 Using index; Using temporary; Using filesort
1 SIMPLE s_articles_prices ref articledetailsID,pricegroup_2,pricegroup articledetailsID 4 usr_p224247_1.s_articles_details.id 1 Using where
Toggle ... SELECT s_core_pricegroups_discounts.disc ...
FROM s_core_pricegroups_discounts, s_core_customergroups AS scc WHERE groupID=?
0.00095
NULL
string(2) "EK"
SELECT
s_core_pricegroups_discounts.discount AS discount,
discountstart
FROM
s_core_pricegroups_discounts,
s_core_customergroups AS scc
WHERE
groupID = ?
AND customergroupID = scc.id
AND scc.groupkey = ?
GROUP BY
discount
ORDER BY
discountstart ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT id,tax FROM s_core_tax_rules WHER ...
FROM s_core_tax_rules WHERE active = 1 AND groupID = ? AND (areaID = ? OR areaID
- Table: s_core_tax_rules using file sort
0.00092
string(1) "1"
NULL
NULL
NULL
int(1)
SELECT
id,
tax
FROM
s_core_tax_rules
WHERE
active = 1
AND groupID = ?
AND (
areaID = ?
OR areaID IS NULL
)
AND (
countryID = ?
OR countryID IS NULL
)
AND (
stateID = ?
OR stateID IS NULL
)
AND (
customer_groupID = ?
OR customer_groupID = 0
OR customer_groupID IS NULL
)
ORDER BY
customer_groupID DESC,
areaID DESC,
countryID DESC,
stateID DESC
LIMIT
1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_tax_rules ref groupID,countryID,stateID,areaID,tax_rate_by_conditions groupID 4 const 1 Using where; Using filesort
Toggle ... SELECT tax FROM s_core_tax WHERE id = ? ...
FROM s_core_tax WHERE id = ?
0.00079
string(1) "1"
SELECT
tax
FROM
s_core_tax
WHERE
id = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_tax const PRIMARY PRIMARY 4 const 1
Toggle ... SELECT objectdata FROM s_core_translatio ...
FROM s_core_translations WHERE objecttype = 'articleimage' AND objectkey = ? AND
0.00089
int(4097)
SELECT
objectdata
FROM
s_core_translations
WHERE
objecttype = 'articleimage'
AND objectkey = ?
AND objectlanguage = '6'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT objectdata FROM s_core_translatio ...
FROM s_core_translations WHERE objecttype = 'articleimage' AND objectkey = ? AND
0.00084
int(4097)
SELECT
objectdata
FROM
s_core_translations
WHERE
objecttype = 'articleimage'
AND objectkey = ?
AND objectlanguage = '6'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT objectdata FROM s_core_translatio ...
FROM s_core_translations WHERE objecttype = 'articleimage' AND objectkey = ? AND
0.00094
int(4093)
SELECT
objectdata
FROM
s_core_translations
WHERE
objecttype = 'articleimage'
AND objectkey = ?
AND objectlanguage = '6'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT objectdata FROM s_core_translatio ...
FROM s_core_translations WHERE objecttype = 'articleimage' AND objectkey = ? AND
0.00095
int(4094)
SELECT
objectdata
FROM
s_core_translations
WHERE
objecttype = 'articleimage'
AND objectkey = ?
AND objectlanguage = '6'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT objectdata FROM s_core_translatio ...
FROM s_core_translations WHERE objecttype = 'articleimage' AND objectkey = ? AND
0.00085
int(4095)
SELECT
objectdata
FROM
s_core_translations
WHERE
objecttype = 'articleimage'
AND objectkey = ?
AND objectlanguage = '6'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT objectdata FROM s_core_translatio ...
FROM s_core_translations WHERE objecttype = 'articleimage' AND objectkey = ? AND
0.00094
int(4096)
SELECT
objectdata
FROM
s_core_translations
WHERE
objecttype = 'articleimage'
AND objectkey = ?
AND objectlanguage = '6'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT path FROM s_core_rewrite_urls WHE ...
FROM s_core_rewrite_urls WHERE org_path=? AND subshopID=? AND main=1 ORDER BY id
0.00099
string(30) "sViewport=detail&sArticle=1325"
int(6)
SELECT
path
FROM
s_core_rewrite_urls
WHERE
org_path = ?
AND subshopID = ?
AND main = 1
ORDER BY
id DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_rewrite_urls ref org_path org_path 767 const 5 Using where
Toggle ... SELECT id, description, filename, size F ...
FROM s_articles_downloads WHERE articleID = :articleId
0.00099
string(4) "1325"
SELECT
id,
description,
filename,
size
FROM
s_articles_downloads
WHERE
articleID = :articleId
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT AVG(points) AS averange, COUNT(ar ...
FROM s_articles_vote WHERE articleID=? AND active=1 GROUP BY articleID
- Table: s_articles_vote using file sort
- Table: s_articles_vote using temporary table
0.00090
int(1325)
SELECT
AVG(points) AS averange,
COUNT(articleID) as number
FROM
s_articles_vote
WHERE
articleID = ?
AND active = 1
GROUP BY
articleID
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_articles_vote ref articleID,get_articles_votes articleID 4 const 1 Using where; Using temporary; Using filesort
Toggle ... SELECT * FROM s_articles_vote FORCE INDE ...
FROM s_articles_vote FORCE INDEX (get_articles_votes) WHERE articleID = ? AND ac
0.00093
int(1325)
SELECT
*
FROM
s_articles_vote FORCE INDEX (get_articles_votes)
WHERE
articleID = ?
AND active = 1
ORDER BY
datum DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_articles_vote ref get_articles_votes get_articles_votes 8 const,const 1 Using where
Toggle ... SELECT fv.optionID AS id, fo.id AS optio ...
FROM s_filter_articles fa JOIN s_filter_values fv ON fv.id=fa.valueID JOIN s_fil
- Table: f using file sort
- Table: f using temporary table
0.00081
int(1)
int(6)
int(6)
int(1325)
SELECT
fv.optionID AS id,
fo.id AS optionID,
fo.name AS name,
f.id AS groupID,
f.name AS groupName,
fv.value AS value,
fv.id AS valueID,
st.objectdata AS nameTranslation,
st2.objectdata AS groupNameTranslation,
st3.objectdata AS valueTranslation
FROM
s_filter_articles fa
JOIN s_filter_values fv ON fv.id = fa.valueID
JOIN s_filter f ON f.id = ?
JOIN s_filter_relations fr ON fr.groupID = f.id
JOIN s_filter_options fo ON fo.id = fr.optionID
AND fo.id = fv.optionID
LEFT JOIN s_core_translations AS st ON st.objecttype = 'propertyoption'
AND st.objectkey = fv.optionID
AND st.objectlanguage = ?
LEFT JOIN s_core_translations AS st2 ON st2.objecttype = 'propertygroup'
AND st2.objectkey = f.id
AND st2.objectlanguage = ?
LEFT JOIN s_core_translations AS st3 ON st3.objecttype = 'propertyvalue'
AND st3.objectkey = fv.id
AND st3.objectlanguage = '6'
WHERE
fa.articleID = ?
ORDER BY
fr.position ASC,
IF(
f.sortmode = 1,
TRIM(
REPLACE(fv.value, ',', '.')
)+ 0,
0
),
IF(f.sortmode = 3, fv.position, 0),
fv.value
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE f const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort
1 SIMPLE fa ref PRIMARY,valueID,articleID PRIMARY 4 const 1 Using index
1 SIMPLE fv eq_ref PRIMARY,optionID,get_property_value_by_option_id_query,optionID_2,filters_order_by_position,filters_order_by_numeric,filters_order_by_alphanumeric PRIMARY 4 usr_p224247_1.fa.valueID 1 Using where
1 SIMPLE fr eq_ref groupID,get_set_assigns_query,groupID_2,optionID groupID 8 const,usr_p224247_1.fv.optionID 1 Using where
1 SIMPLE fo eq_ref PRIMARY PRIMARY 4 usr_p224247_1.fv.optionID 1
1 SIMPLE st eq_ref objecttype objecttype 1538 const,usr_p224247_1.fv.optionID,const 1
1 SIMPLE st2 eq_ref objecttype objecttype 1538 const,const,const 1
1 SIMPLE st3 eq_ref objecttype objecttype 1538 const,usr_p224247_1.fv.id,const 1
Toggle ... SELECT a.id, name AS articleName, 0 as p ...
FROM s_articles a INNER JOIN s_articles_categories_ro ac ON ac.articleID = a.id
- Table: c using file sort
- Table: c using temporary table
0.00278
bool(false)
SELECT
a.id,
name AS articleName,
0 as price
FROM
s_articles a
INNER JOIN s_articles_categories_ro ac ON ac.articleID = a.id
AND ac.categoryID = 180
INNER JOIN s_categories c ON c.id = ac.categoryID
AND c.active = 1
JOIN s_articles_details AS aDetails ON aDetails.articleID = a.id
AND aDetails.kind = 1
JOIN s_articles_attributes AS aAttributes ON aAttributes.articledetailsID = aDetails.id
LEFT JOIN s_articles_avoid_customergroups ag ON ag.articleID = ac.articleID
AND ag.customergroupID = 1
WHERE
a.active = 1
AND ag.articleID IS NULL
GROUP BY
a.id
ORDER BY
a.datum DESC,
a.id DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort
1 SIMPLE ac ref articleID,categoryID,articleID_2,categoryID_2,category_id_by_article_id categoryID 4 const 1
1 SIMPLE ag eq_ref articleID articleID 8 usr_p224247_1.ac.articleID,const 1 Using where; Using index; Not exists
1 SIMPLE a eq_ref PRIMARY,product_newcomer,get_category_filters PRIMARY 4 usr_p224247_1.ac.articleID 1 Using where
1 SIMPLE aDetails ref PRIMARY,articleID,get_similar_articles articleID 4 usr_p224247_1.a.id 1 Using where
1 SIMPLE aAttributes ref articledetailsID articledetailsID 5 usr_p224247_1.aDetails.id 1 Using where; Using index
Toggle ... SELECT path FROM s_core_rewrite_urls WHE ...
FROM s_core_rewrite_urls WHERE org_path=? AND subshopID=? AND main=1 ORDER BY id
0.00091
string(41) "sViewport=support&sFid=16&sInquiry=detail"
int(6)
SELECT
path
FROM
s_core_rewrite_urls
WHERE
org_path = ?
AND subshopID = ?
AND main = 1
ORDER BY
id DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_rewrite_urls ref org_path org_path 767 const 1 Using where
Toggle ... SELECT path FROM s_core_rewrite_urls WHE ...
FROM s_core_rewrite_urls WHERE org_path=? AND subshopID=? AND main=1 ORDER BY id
0.00091
string(41) "sViewport=support&sFid=16&sInquiry=detail"
int(6)
SELECT
path
FROM
s_core_rewrite_urls
WHERE
org_path = ?
AND subshopID = ?
AND main = 1
ORDER BY
id DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_rewrite_urls ref org_path org_path 767 const 1 Using where
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00099
int(6)
int(1)
string(9) "HPNWGeoip"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00091
int(6)
int(1)
string(12) "HpnwTemplate"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00127
int(6)
int(1)
string(7) "Compare"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00093
int(6)
int(1)
string(8) "TagCloud"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00074
int(6)
int(1)
string(12) "LastArticles"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00148
int(6)
int(1)
string(6) "Google"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00095
int(6)
int(1)
string(15) "NetiSocialLogin"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00081
int(6)
int(1)
string(12) "WebgSeoTotal"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00077
int(6)
int(1)
string(12) "AdvancedMenu"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00096
int(6)
int(1)
string(16) "NetiFreeDelivery"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT `shippingfree` FROM `s_core_count ...
FROM `s_core_countries` WHERE `id` = ?
0.00107
int(2)
SELECT
`shippingfree`
FROM
`s_core_countries`
WHERE
`id` = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_countries const PRIMARY PRIMARY 4 const 1
Toggle ... SELECT id, modus, quantity FROM s_order_ ...
FROM s_order_basket WHERE sessionID = ?
0.00106
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
id,
modus,
quantity
FROM
s_order_basket
WHERE
sessionID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where
Toggle ... SELECT SUM(quantity*(floor(price * 100 + ...
FROM s_order_basket WHERE sessionID = ? GROUP BY sessionID
- Table: s_order_basket using file sort
- Table: s_order_basket using temporary table
0.00107
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
SUM(
quantity *(
floor(price * 100 +.55)/ 100
)
) AS totalAmount
FROM
s_order_basket
WHERE
sessionID = ?
GROUP BY
sessionID
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where; Using temporary; Using filesort
Toggle ... SELECT basket.id FROM s_order_basket bas ...
FROM s_order_basket basket LEFT JOIN s_addon_premiums premium ON premium.ordernu
- Table: premium select ALL
0.00107
float(0)
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
basket.id
FROM
s_order_basket basket
LEFT JOIN s_addon_premiums premium ON premium.ordernumber_export = basket.ordernumber
AND premium.startprice <= ?
WHERE
basket.modus = 1
AND premium.id IS NULL
AND basket.sessionID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE basket ref sessionID,get_basket sessionID 387 const 1 Using where
1 SIMPLE premium ALL 1 Using where; Not exists
Toggle ... DELETE FROM `s_order_basket` WHERE (sess ...
FROM `s_order_basket` WHERE (sessionID = '3c923882c403d49327d4fe6b35c4405e8fc9e1
0.00186
DELETE FROM
`s_order_basket`
WHERE
(
sessionID = '3c923882c403d49327d4fe6b35c4405e8fc9e13c'
)
AND (modus = 3)
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... DELETE FROM `s_order_basket` WHERE (sess ...
FROM `s_order_basket` WHERE (sessionID = '3c923882c403d49327d4fe6b35c4405e8fc9e1
0.00079
DELETE FROM
`s_order_basket`
WHERE
(
sessionID = '3c923882c403d49327d4fe6b35c4405e8fc9e13c'
)
AND (ordernumber = 'sw-surcharge')
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT COUNT(*) FROM s_order_basket WHER ...
FROM s_order_basket WHERE modus = 0 AND sessionID = ?
0.00135
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
COUNT(*)
FROM
s_order_basket
WHERE
modus = 0
AND sessionID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where
Toggle ... SELECT basketdiscount, basketdiscountsta ...
FROM s_core_customergroups_discounts WHERE groupID = ? ORDER BY basketdiscountst
0.00077
int(1)
SELECT
basketdiscount,
basketdiscountstart
FROM
s_core_customergroups_discounts
WHERE
groupID = ?
ORDER BY
basketdiscountstart ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_customergroups_discounts ref groupID groupID 4 const 1 Using where
Toggle ... DELETE FROM s_order_basket WHERE session ...
FROM s_order_basket WHERE sessionID = ? AND modus = 3
0.00089
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
DELETE FROM
s_order_basket
WHERE
sessionID = ?
AND modus = 3
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT s_order_basket.*, COALESCE (NULLI ...
FROM s_order_basket LEFT JOIN s_articles_details AS ad ON ad.ordernumber = s_ord
- Table: s_order_basket using file sort
0.00218
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
s_order_basket.*,
COALESCE (
NULLIF(ad.packunit, ''),
mad.packunit
) AS packunit,
a.main_detail_id AS mainDetailId,
ad.id AS articleDetailId,
ad.minpurchase,
a.taxID,
ad.instock AS instock,
ad.suppliernumber,
ad.maxpurchase,
ad.purchasesteps,
ad.purchaseunit,
COALESCE (ad.unitID, mad.unitID) AS unitID,
a.laststock,
ad.shippingtime,
ad.releasedate,
ad.releasedate AS sReleaseDate,
COALESCE (ad.ean, mad.ean) AS ean,
ad.stockmin,
s_order_basket_attributes.attribute1 as ob_attr1,
s_order_basket_attributes.attribute2 as ob_attr2,
s_order_basket_attributes.attribute3 as ob_attr3,
s_order_basket_attributes.attribute4 as ob_attr4,
s_order_basket_attributes.attribute5 as ob_attr5,
s_order_basket_attributes.attribute6 as ob_attr6
FROM
s_order_basket
LEFT JOIN s_articles_details AS ad ON ad.ordernumber = s_order_basket.ordernumber
LEFT JOIN s_articles a ON (a.id = ad.articleID)
LEFT JOIN s_articles_details AS mad ON mad.id = a.main_detail_id
LEFT JOIN s_order_basket_attributes ON s_order_basket.id = s_order_basket_attributes.basketID
WHERE
sessionID = ?
ORDER BY
id ASC,
datum DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where; Using filesort
1 SIMPLE ad eq_ref ordernumber ordernumber 122 usr_p224247_1.s_order_basket.ordernumber 1
1 SIMPLE a eq_ref PRIMARY PRIMARY 4 usr_p224247_1.ad.articleID 1
1 SIMPLE mad eq_ref PRIMARY PRIMARY 4 usr_p224247_1.a.main_detail_id 1
1 SIMPLE s_order_basket_attributes ref basketID basketID 5 usr_p224247_1.s_order_basket.id 1
Toggle ... SELECT d.id FROM s_premium_dispatch d JO ...
FROM s_premium_dispatch d JOIN s_premium_dispatch_countries c ON d.id = c.dispat
0.00101
int(9)
int(2)
SELECT
d.id
FROM
s_premium_dispatch d
JOIN s_premium_dispatch_countries c ON d.id = c.dispatchID
WHERE
d.id = ?
AND c.countryID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE Impossible WHERE noticed after reading const tables
Toggle ... SELECT d.id, d.shippingfree * (SELECT fa ...
FROM s_premium_dispatch d JOIN s_premium_dispatch_countries c ON d.id = c.dispat
- Table: d using file sort
- Table: d select ALL
0.00077
int(1)
int(2)
SELECT
d.id,
d.shippingfree * (
SELECT
factor
FROM
s_core_currencies
WHERE
id = ?
) as shippingFreeLimit
FROM
s_premium_dispatch d
JOIN s_premium_dispatch_countries c ON d.id = c.dispatchID
WHERE
c.countryID = ?
ORDER BY
d.shippingfree DESC
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY d ALL PRIMARY 14 Using filesort
1 PRIMARY c eq_ref PRIMARY PRIMARY 8 usr_p224247_1.d.id,const 1 Using index
2 SUBQUERY s_core_currencies const PRIMARY PRIMARY 4 const 1
Toggle ... SELECT * FROM s_premium_shippingcosts WH ...
FROM s_premium_shippingcosts WHERE dispatchID = ? ORDER BY `from` ASC
- Table: s_premium_shippingcosts using file sort
- Table: s_premium_shippingcosts select ALL
0.00082
string(2) "10"
SELECT
*
FROM
s_premium_shippingcosts
WHERE
dispatchID = ?
ORDER BY
`from` ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_premium_shippingcosts ALL 14 Using where; Using filesort
Toggle ... SELECT price FROM s_order_basket WHERE s ...
FROM s_order_basket WHERE sessionID=? AND (modus = 3 OR modus = 4)
0.00098
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
price
FROM
s_order_basket
WHERE
sessionID = ?
AND (
modus = 3
OR modus = 4
)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where
Toggle ... SELECT value FROM s_core_snippets WHERE ...
FROM s_core_snippets WHERE namespace = ? AND name = ? AND shopID = ? AND localeI
0.00080
string(29) "frontend/plugins/freedelivery"
string(32) "Versandkostenfrei_nicht_erreicht"
string(1) "6"
int(1)
SELECT
value
FROM
s_core_snippets
WHERE
namespace = ?
AND name = ?
AND shopID = ?
AND localeID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_snippets const namespace namespace 1542 const,const,const,const 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00087
int(6)
int(1)
string(18) "PiPaymorrowPayment"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT * FROM s_core_paymentmeans WHERE ...
FROM s_core_paymentmeans WHERE name = 'Amazoncba'
0.00085
SELECT
*
FROM
s_core_paymentmeans
WHERE
name = 'Amazoncba'
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_paymentmeans const name name 767 const 1
Toggle ... SELECT id, modus, quantity FROM s_order_ ...
FROM s_order_basket WHERE sessionID = ?
0.00091
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
id,
modus,
quantity
FROM
s_order_basket
WHERE
sessionID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where
Toggle ... SELECT SUM(quantity*(floor(price * 100 + ...
FROM s_order_basket WHERE sessionID = ? GROUP BY sessionID
- Table: s_order_basket using file sort
- Table: s_order_basket using temporary table
0.00081
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
SUM(
quantity *(
floor(price * 100 +.55)/ 100
)
) AS totalAmount
FROM
s_order_basket
WHERE
sessionID = ?
GROUP BY
sessionID
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where; Using temporary; Using filesort
Toggle ... SELECT basket.id FROM s_order_basket bas ...
FROM s_order_basket basket LEFT JOIN s_addon_premiums premium ON premium.ordernu
- Table: premium select ALL
0.00083
float(0)
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
basket.id
FROM
s_order_basket basket
LEFT JOIN s_addon_premiums premium ON premium.ordernumber_export = basket.ordernumber
AND premium.startprice <= ?
WHERE
basket.modus = 1
AND premium.id IS NULL
AND basket.sessionID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE basket ref sessionID,get_basket sessionID 387 const 1 Using where
1 SIMPLE premium ALL 1 Using where; Not exists
Toggle ... DELETE FROM `s_order_basket` WHERE (sess ...
FROM `s_order_basket` WHERE (sessionID = '3c923882c403d49327d4fe6b35c4405e8fc9e1
0.00090
DELETE FROM
`s_order_basket`
WHERE
(
sessionID = '3c923882c403d49327d4fe6b35c4405e8fc9e13c'
)
AND (modus = 3)
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... DELETE FROM `s_order_basket` WHERE (sess ...
FROM `s_order_basket` WHERE (sessionID = '3c923882c403d49327d4fe6b35c4405e8fc9e1
0.00093
DELETE FROM
`s_order_basket`
WHERE
(
sessionID = '3c923882c403d49327d4fe6b35c4405e8fc9e13c'
)
AND (ordernumber = 'sw-surcharge')
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT COUNT(*) FROM s_order_basket WHER ...
FROM s_order_basket WHERE modus = 0 AND sessionID = ?
0.00090
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
COUNT(*)
FROM
s_order_basket
WHERE
modus = 0
AND sessionID = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where
Toggle ... SELECT basketdiscount, basketdiscountsta ...
FROM s_core_customergroups_discounts WHERE groupID = ? ORDER BY basketdiscountst
0.00089
int(1)
SELECT
basketdiscount,
basketdiscountstart
FROM
s_core_customergroups_discounts
WHERE
groupID = ?
ORDER BY
basketdiscountstart ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_customergroups_discounts ref groupID groupID 4 const 1 Using where
Toggle ... DELETE FROM s_order_basket WHERE session ...
FROM s_order_basket WHERE sessionID = ? AND modus = 3
0.00104
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
DELETE FROM
s_order_basket
WHERE
sessionID = ?
AND modus = 3
id select_type table type possible_keys key key_len ref rows Extra
S S S S S S S S S S
Toggle ... SELECT s_order_basket.*, COALESCE (NULLI ...
FROM s_order_basket LEFT JOIN s_articles_details AS ad ON ad.ordernumber = s_ord
- Table: s_order_basket using file sort
0.00086
string(40) "3c923882c403d49327d4fe6b35c4405e8fc9e13c"
SELECT
s_order_basket.*,
COALESCE (
NULLIF(ad.packunit, ''),
mad.packunit
) AS packunit,
a.main_detail_id AS mainDetailId,
ad.id AS articleDetailId,
ad.minpurchase,
a.taxID,
ad.instock AS instock,
ad.suppliernumber,
ad.maxpurchase,
ad.purchasesteps,
ad.purchaseunit,
COALESCE (ad.unitID, mad.unitID) AS unitID,
a.laststock,
ad.shippingtime,
ad.releasedate,
ad.releasedate AS sReleaseDate,
COALESCE (ad.ean, mad.ean) AS ean,
ad.stockmin,
s_order_basket_attributes.attribute1 as ob_attr1,
s_order_basket_attributes.attribute2 as ob_attr2,
s_order_basket_attributes.attribute3 as ob_attr3,
s_order_basket_attributes.attribute4 as ob_attr4,
s_order_basket_attributes.attribute5 as ob_attr5,
s_order_basket_attributes.attribute6 as ob_attr6
FROM
s_order_basket
LEFT JOIN s_articles_details AS ad ON ad.ordernumber = s_order_basket.ordernumber
LEFT JOIN s_articles a ON (a.id = ad.articleID)
LEFT JOIN s_articles_details AS mad ON mad.id = a.main_detail_id
LEFT JOIN s_order_basket_attributes ON s_order_basket.id = s_order_basket_attributes.basketID
WHERE
sessionID = ?
ORDER BY
id ASC,
datum DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_order_basket ref sessionID,get_basket sessionID 387 const 1 Using where; Using filesort
1 SIMPLE ad eq_ref ordernumber ordernumber 122 usr_p224247_1.s_order_basket.ordernumber 1
1 SIMPLE a eq_ref PRIMARY PRIMARY 4 usr_p224247_1.ad.articleID 1
1 SIMPLE mad eq_ref PRIMARY PRIMARY 4 usr_p224247_1.a.main_detail_id 1
1 SIMPLE s_order_basket_attributes ref basketID basketID 5 usr_p224247_1.s_order_basket.id 1
Toggle ... SELECT c.*, a.name AS countryarea FROM s ...
FROM s_core_countries c LEFT JOIN s_core_countries_areas a ON a.id = c.areaID AN
0.00099
int(2)
SELECT
c.*,
a.name AS countryarea
FROM
s_core_countries c
LEFT JOIN s_core_countries_areas a ON a.id = c.areaID
AND a.active = 1
WHERE
c.id = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c const PRIMARY PRIMARY 4 const 1
1 SIMPLE a const PRIMARY PRIMARY 4 const 1
Toggle ... SELECT rule1, value1, rule2, value2 FROM ...
FROM s_core_rulesets WHERE paymentID = ? ORDER BY id ASC
0.00100
string(2) "76"
SELECT
rule1,
value1,
rule2,
value2
FROM
s_core_rulesets
WHERE
paymentID = ?
ORDER BY
id ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_rulesets index PRIMARY 4 8 Using where
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00107
int(6)
int(1)
string(15) "BestitAmazonCBA"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT ce.name, IFNULL(IFNULL(cv.value, ...
FROM s_core_plugins p JOIN s_core_config_forms cf ON cf.plugin_id = p.id JOIN s_
0.00141
int(6)
int(1)
string(20) "sKUZOPreisAufAnfrage"
SELECT
ce.name,
IFNULL(
IFNULL(cv.value, cm.value),
ce.value
) as value
FROM
s_core_plugins p
JOIN s_core_config_forms cf ON cf.plugin_id = p.id
JOIN s_core_config_elements ce ON ce.form_id = cf.id
LEFT JOIN s_core_config_values cv ON cv.element_id = ce.id
AND cv.shop_id = ?
LEFT JOIN s_core_config_values cm ON cm.element_id = ce.id
AND cm.shop_id = ?
WHERE
p.name = ?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cf index PRIMARY,plugin_id plugin_id 5 31 Using index
1 SIMPLE p eq_ref PRIMARY PRIMARY 4 usr_p224247_1.cf.plugin_id 1 Using where
1 SIMPLE ce ref form_id_2,form_id form_id 4 usr_p224247_1.cf.id 4
1 SIMPLE cv ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
1 SIMPLE cm ref shop_id,element_id element_id 4 usr_p224247_1.ce.id 1
Toggle ... SELECT 1 FROM s_core_plugins WHERE name= ...
FROM s_core_plugins WHERE name='SwfResponsiveTemplate' AND active=1
- Table: s_core_plugins more than 100 rows
- Table: s_core_plugins select ALL
0.00094
SELECT
1
FROM
s_core_plugins
WHERE
name = 'SwfResponsiveTemplate'
AND active = 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s_core_plugins ALL 124 Using where
Toggle ... SELECT p.id, p.description, p.link, p.ta ...
FROM s_cms_static p, s_cms_static_groups g LEFT JOIN s_cms_static_groups m ON m.
- Table: g using file sort
- Table: g using temporary table
- Table: g select ALL
- Table: p more than 100 rows
- Table: p select ALL
- Table: s_cms_static more than 100 rows
- Table: s_cms_static select ALL
0.00110
int(6)
SELECT
p.id,
p.description,
p.link,
p.target,
g.key as `group`,
m.key as mapping,
(
SELECT
COUNT(*)
FROM
s_cms_static
WHERE
parentID = p.id
) as childrenCount
FROM
s_cms_static p,
s_cms_static_groups g
LEFT JOIN s_cms_static_groups m ON m.id = g.mapping_id
LEFT JOIN s_core_shop_pages s ON s.group_id = g.id
AND s.shop_id = ?
WHERE
g.active =