Zentrierring Kunststoff 70,1-60,1

object(Enlight_Controller_Request_RequestHttp)#205 (34) { ["validDeviceTypes":protected]=> array(3) { [0]=> string(7) "desktop" [1]=> string(6) "tablet" [2]=> string(6) "mobile" } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(8) "frontend" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(6) "detail" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "index" ["_actionKey":protected]=> string(6) "action" ["_params":protected]=> array(0) { } ["nameFormatter":"Enlight_Controller_Request_RequestHttp":private]=> object(Shopware\Components\DispatchFormatHelper)#1156 (0) { } ["attributes"]=> object(Symfony\Component\HttpFoundation\ParameterBag)#202 (1) { ["parameters":protected]=> array(2) { ["controllerId"]=> string(36) "shopware_controllers_frontend_detail" ["_controller"]=> string(49) "shopware_controllers_frontend_detail::indexAction" } } ["request"]=> object(Symfony\Component\HttpFoundation\ParameterBag)#204 (1) { ["parameters":protected]=> array(0) { } } ["query"]=> object(Symfony\Component\HttpFoundation\ParameterBag)#203 (1) { ["parameters":protected]=> array(6) { ["module"]=> string(8) "frontend" ["controller"]=> string(6) "detail" ["action"]=> string(5) "index" ["sArticle"]=> string(5) "19532" ["rewriteUrl"]=> bool(true) ["sCategory"]=> int(19129) } } ["server"]=> object(Symfony\Component\HttpFoundation\ServerBag)#199 (1) { ["parameters":protected]=> array(51) { ["USER"]=> string(8) "mbdesign" ["HOME"]=> string(32) "/var/www/vhosts/web.mb-design.de" ["SCRIPT_NAME"]=> string(13) "/shopware.php" ["REQUEST_URI"]=> string(40) "/de/zentrierring-kunststoff-701-601.html" ["QUERY_STRING"]=> string(0) "" ["REQUEST_METHOD"]=> string(3) "GET" ["SERVER_PROTOCOL"]=> string(8) "HTTP/1.0" ["GATEWAY_INTERFACE"]=> string(7) "CGI/1.1" ["REDIRECT_URL"]=> string(40) "/de/zentrierring-kunststoff-701-601.html" ["REMOTE_PORT"]=> string(5) "33626" ["SCRIPT_FILENAME"]=> string(68) "/var/www/vhosts/web.mb-design.de/httpdocs/mbdesign.shop/shopware.php" ["SERVER_ADMIN"]=> string(14) "root@localhost" ["CONTEXT_DOCUMENT_ROOT"]=> string(55) "/var/www/vhosts/web.mb-design.de/httpdocs/mbdesign.shop" ["CONTEXT_PREFIX"]=> string(0) "" ["REQUEST_SCHEME"]=> string(5) "https" ["DOCUMENT_ROOT"]=> string(55) "/var/www/vhosts/web.mb-design.de/httpdocs/mbdesign.shop" ["REMOTE_ADDR"]=> string(9) "127.0.0.1" ["SERVER_PORT"]=> string(3) "443" ["SERVER_ADDR"]=> string(14) "168.119.66.183" ["SERVER_NAME"]=> string(13) "mbdesign.shop" ["SERVER_SOFTWARE"]=> string(6) "Apache" ["SERVER_SIGNATURE"]=> string(0) "" ["PATH"]=> string(49) "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" ["HTTP_ACCEPT_ENCODING"]=> string(7) "br,gzip" ["HTTP_ACCEPT_LANGUAGE"]=> string(14) "en-US,en;q=0.5" ["HTTP_ACCEPT"]=> string(63) "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8" ["HTTP_USER_AGENT"]=> string(40) "CCBot/2.0 (https://commoncrawl.org/faq/)" ["HTTP_CONNECTION"]=> string(5) "close" ["HTTP_X_ACCEL_INTERNAL"]=> string(31) "/internal-nginx-static-location" ["HTTP_X_REAL_IP"]=> string(14) "44.200.171.156" ["HTTP_HOST"]=> string(13) "mbdesign.shop" ["proxy-nokeepalive"]=> string(1) "1" ["HTTPS"]=> string(2) "on" ["PERL5LIB"]=> string(49) "/usr/share/awstats/lib:/usr/share/awstats/plugins" ["HTTP_AUTHORIZATION"]=> string(0) "" ["SCRIPT_URI"]=> string(61) "https://mbdesign.shop/de/zentrierring-kunststoff-701-601.html" ["SCRIPT_URL"]=> string(40) "/de/zentrierring-kunststoff-701-601.html" ["UNIQUE_ID"]=> string(27) "ZBpmcG9GNToVlQmm@SjwEAAAAMo" ["REDIRECT_STATUS"]=> string(3) "200" ["REDIRECT_HTTPS"]=> string(2) "on" ["REDIRECT_PERL5LIB"]=> string(49) "/usr/share/awstats/lib:/usr/share/awstats/plugins" ["REDIRECT_SCRIPT_URI"]=> string(61) "https://mbdesign.shop/de/zentrierring-kunststoff-701-601.html" ["REDIRECT_SCRIPT_URL"]=> string(40) "/de/zentrierring-kunststoff-701-601.html" ["REDIRECT_UNIQUE_ID"]=> string(27) "ZBpmcG9GNToVlQmm@SjwEAAAAMo" ["FCGI_ROLE"]=> string(9) "RESPONDER" ["PHP_SELF"]=> string(13) "/shopware.php" ["REQUEST_TIME_FLOAT"]=> float(1679451760.4338) ["REQUEST_TIME"]=> int(1679451760) ["HTTP_FORWARDED"]=> string(53) "for="44.200.171.156";host="mbdesign.shop";proto=https" ["HTTP_X_FORWARDED_FOR"]=> string(14) "44.200.171.156" ["HTTP_SURROGATE_CAPABILITY"]=> string(37) "shopware="ESI/1.0", symfony="ESI/1.0"" } } ["files"]=> object(Symfony\Component\HttpFoundation\FileBag)#200 (1) { ["parameters":protected]=> array(0) { } } ["cookies"]=> object(Symfony\Component\HttpFoundation\ParameterBag)#201 (1) { ["parameters":protected]=> array(0) { } } ["headers"]=> object(Symfony\Component\HttpFoundation\HeaderBag)#198 (2) { ["headers":protected]=> array(12) { ["accept-encoding"]=> array(1) { [0]=> string(7) "br,gzip" } ["accept-language"]=> array(1) { [0]=> string(14) "en-US,en;q=0.5" } ["accept"]=> array(1) { [0]=> string(63) "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8" } ["user-agent"]=> array(1) { [0]=> string(40) "CCBot/2.0 (https://commoncrawl.org/faq/)" } ["connection"]=> array(1) { [0]=> string(5) "close" } ["x-accel-internal"]=> array(1) { [0]=> string(31) "/internal-nginx-static-location" } ["x-real-ip"]=> array(1) { [0]=> string(14) "44.200.171.156" } ["host"]=> array(1) { [0]=> string(13) "mbdesign.shop" } ["authorization"]=> array(1) { [0]=> string(0) "" } ["forwarded"]=> array(1) { [0]=> string(53) "for="44.200.171.156";host="mbdesign.shop";proto=https" } ["x-forwarded-for"]=> array(1) { [0]=> string(14) "44.200.171.156" } ["surrogate-capability"]=> array(1) { [0]=> string(37) "shopware="ESI/1.0", symfony="ESI/1.0"" } } ["cacheControl":protected]=> array(0) { } } ["content":protected]=> string(0) "" ["languages":protected]=> NULL ["charsets":protected]=> NULL ["encodings":protected]=> NULL ["acceptableContentTypes":protected]=> NULL ["pathInfo":protected]=> string(37) "/zentrierring-kunststoff-701-601.html" ["requestUri":protected]=> string(40) "/de/zentrierring-kunststoff-701-601.html" ["baseUrl":protected]=> string(3) "/de" ["basePath":protected]=> string(0) "" ["method":protected]=> NULL ["format":protected]=> NULL ["session":protected]=> object(Enlight_Components_Session_Namespace)#784 (5) { ["storage":protected]=> object(Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage)#776 (6) { ["bags":protected]=> array(2) { ["attributes"]=> object(Symfony\Component\HttpFoundation\Session\SessionBagProxy)#792 (3) { ["bag":"Symfony\Component\HttpFoundation\Session\SessionBagProxy":private]=> object(Symfony\Component\HttpFoundation\Session\Attribute\NamespacedAttributeBag)#790 (4) { ["namespaceCharacter":"Symfony\Component\HttpFoundation\Session\Attribute\NamespacedAttributeBag":private]=> string(1) "/" ["name":"Symfony\Component\HttpFoundation\Session\Attribute\AttributeBag":private]=> string(10) "attributes" ["storageKey":"Symfony\Component\HttpFoundation\Session\Attribute\AttributeBag":private]=> string(8) "Shopware" ["attributes":protected]=> &array(6) { ["sessionId"]=> string(26) "e5lrpq0s93s3u66cgv2nnjifrs" ["Bot"]=> bool(true) ["sOutputNet"]=> bool(false) ["PayPalRiskManagementProductDetailId"]=> string(5) "19532" ["PayPalRiskManagementCategoryId"]=> int(19129) ["sRegister"]=> array(0) { } } } ["data":"Symfony\Component\HttpFoundation\Session\SessionBagProxy":private]=> &array(2) { ["Shopware"]=> &array(6) { ["sessionId"]=> string(26) "e5lrpq0s93s3u66cgv2nnjifrs" ["Bot"]=> bool(true) ["sOutputNet"]=> bool(false) ["PayPalRiskManagementProductDetailId"]=> string(5) "19532" ["PayPalRiskManagementCategoryId"]=> int(19129) ["sRegister"]=> array(0) { } } ["_symfony_flashes"]=> &array(0) { } } ["usageIndex":"Symfony\Component\HttpFoundation\Session\SessionBagProxy":private]=> &int(126) } ["flashes"]=> object(Symfony\Component\HttpFoundation\Session\SessionBagProxy)#788 (3) { ["bag":"Symfony\Component\HttpFoundation\Session\SessionBagProxy":private]=> object(Symfony\Component\HttpFoundation\Session\Flash\FlashBag)#793 (3) { ["name":"Symfony\Component\HttpFoundation\Session\Flash\FlashBag":private]=> string(7) "flashes" ["flashes":"Symfony\Component\HttpFoundation\Session\Flash\FlashBag":private]=> &array(0) { } ["storageKey":"Symfony\Component\HttpFoundation\Session\Flash\FlashBag":private]=> string(16) "_symfony_flashes" } ["data":"Symfony\Component\HttpFoundation\Session\SessionBagProxy":private]=> &array(2) { ["Shopware"]=> &array(6) { ["sessionId"]=> string(26) "e5lrpq0s93s3u66cgv2nnjifrs" ["Bot"]=> bool(true) ["sOutputNet"]=> bool(false) ["PayPalRiskManagementProductDetailId"]=> string(5) "19532" ["PayPalRiskManagementCategoryId"]=> int(19129) ["sRegister"]=> array(0) { } } ["_symfony_flashes"]=> &array(0) { } } ["usageIndex":"Symfony\Component\HttpFoundation\Session\SessionBagProxy":private]=> &int(126) } } ["started":protected]=> bool(true) ["closed":protected]=> bool(false) ["saveHandler":protected]=> object(Symfony\Component\HttpFoundation\Session\Storage\Proxy\SessionHandlerProxy)#770 (3) { ["handler":protected]=> object(Symfony\Component\HttpFoundation\Session\Storage\Handler\StrictSessionHandler)#787 (7) { ["handler":"Symfony\Component\HttpFoundation\Session\Storage\Handler\StrictSessionHandler":private]=> object(SessionHandler)#789 (0) { } ["doDestroy":"Symfony\Component\HttpFoundation\Session\Storage\Handler\StrictSessionHandler":private]=> NULL ["sessionName":"Symfony\Component\HttpFoundation\Session\Storage\Handler\AbstractSessionHandler":private]=> string(9) "session-1" ["prefetchId":"Symfony\Component\HttpFoundation\Session\Storage\Handler\AbstractSessionHandler":private]=> NULL ["prefetchData":"Symfony\Component\HttpFoundation\Session\Storage\Handler\AbstractSessionHandler":private]=> NULL ["newSessionId":"Symfony\Component\HttpFoundation\Session\Storage\Handler\AbstractSessionHandler":private]=> string(26) "e5lrpq0s93s3u66cgv2nnjifrs" ["igbinaryEmptyData":"Symfony\Component\HttpFoundation\Session\Storage\Handler\AbstractSessionHandler":private]=> NULL } ["wrapper":protected]=> bool(false) ["saveHandlerName":protected]=> string(5) "redis" } ["metadataBag":protected]=> object(Symfony\Component\HttpFoundation\Session\Storage\MetadataBag)#771 (5) { ["name":"Symfony\Component\HttpFoundation\Session\Storage\MetadataBag":private]=> string(10) "__metadata" ["storageKey":"Symfony\Component\HttpFoundation\Session\Storage\MetadataBag":private]=> string(9) "_sf2_meta" ["meta":protected]=> &array(3) { ["u"]=> int(1679451760) ["c"]=> int(1679451760) ["l"]=> int(0) } ["lastUsed":"Symfony\Component\HttpFoundation\Session\Storage\MetadataBag":private]=> int(1679451760) ["updateThreshold":"Symfony\Component\HttpFoundation\Session\Storage\MetadataBag":private]=> int(0) } ["emulateSameSite":"Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage":private]=> NULL } ["flashName":"Symfony\Component\HttpFoundation\Session\Session":private]=> string(7) "flashes" ["attributeName":"Symfony\Component\HttpFoundation\Session\Session":private]=> string(10) "attributes" ["data":"Symfony\Component\HttpFoundation\Session\Session":private]=> &array(2) { ["Shopware"]=> &array(6) { ["sessionId"]=> string(26) "e5lrpq0s93s3u66cgv2nnjifrs" ["Bot"]=> bool(true) ["sOutputNet"]=> bool(false) ["PayPalRiskManagementProductDetailId"]=> string(5) "19532" ["PayPalRiskManagementCategoryId"]=> int(19129) ["sRegister"]=> array(0) { } } ["_symfony_flashes"]=> &array(0) { } } ["usageIndex":"Symfony\Component\HttpFoundation\Session\Session":private]=> &int(126) } ["locale":protected]=> NULL ["defaultLocale":protected]=> string(2) "en" ["preferredFormat":"Symfony\Component\HttpFoundation\Request":private]=> NULL ["isHostValid":"Symfony\Component\HttpFoundation\Request":private]=> bool(true) ["isForwardedValid":"Symfony\Component\HttpFoundation\Request":private]=> bool(true) } 19532 SELECT a.id AS groupId, a.name AS groupName, a.description AS groupDescription, a.pflicht, a.multiple_choice AS groupMultiple, b.id AS articleId, b.ordernumber AS articleNumber, b.optionname, b.quantity AS articleQuantity, b.standard, b.einheit FROM atsd_article_accessory_direct_buy_groups AS a JOIN atsd_article_accessory_direct_buy_articles AS b ON a.id = b.accessory_group_id JOIN s_articles_details AS d ON d.ordernumber = b.ordernumber AND d.active =1 WHERE a.article_id = :articleId UNION SELECT 9999 AS groupId, '0 Zubehörkit' AS groupName, 'Zubehör zur Radmontage, teilweise Serienradbefestigung.' AS groupDescription, 1 AS pflicht, 0 AS groupMultiple, p2.articleId, p2.products_model AS articleNumber, p2.products_oberflaeche AS optionname, 1 AS articleQuantity, IF(p.products_farbcode IN('B1','BP1','B3','B2','B4','G1') AND p2.products_farbcode = 'S','0','1') AS standard, 'Kit' AS einheit FROM wheel_assistant_wheels AS waw JOIN wheel_assistant_cars AS wac ON wac.id = waw.car JOIN s_articles_attributes AS p ON waw.wheel = p.products_groupid JOIN s_articles_attributes AS p2 ON p2.products_model = waw.accessorie OR p2.products_model = CONCAT(waw.accessorie,IF(p.products_farbcode IN('B1','BP1','B3','B2','B4','G1'),'-B','')) WHERE p.articleID = :articleId AND wac.autoid = :autoId GROUP BY articleNumber ORDER BY groupName ASC