# Ständig Ärger mit der DB - lausige Performance die Zweite

**URL:** <https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440>\
**Category:** Shopware 3.5\
**Tags:** general\
**Created:** [6. Februar 2013 um 15:41 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440 "2013-02-06T15:41:55Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Porter](https://avatars.discourse-cdn.com/v4/letter/p/c5a1d2/32.png) [@Porter](https://forum.shopware.com/u/Porter)\
**Post date:** [6. Februar 2013 um 15:41 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/1 "2013-02-06T15:41:55Z")

</div>

Hi, seit wir Anfang Dezember auf 4.05 geupdatet haben hat unser Virtual Server Max ständig Performance Probleme die bis zur kompletten Nichterreichbarkeit gehen. Am Anfang wurden die Probleme öfters durch den BingBot ausgelöst, was aber mittlerweile gelöst ist (Kombo aus einen Teil der MSN IPs „über die .htaccess aussperren“ und für den Rest crawl delay). Nachdem wir die Sache mit dem Bingbot gelöst haben bleibt noch das Problem mit der Shopdatenbank. Der Shop läuft tlw. über Stunden sehr schnell um dann plötzlich (wir haben eigentlich keine Dienste, nur einen Piwik Cronjob jede Stunde) einen enormen Lastanstieg bei den Apache Prozessen zu verzeichnen und danach (meistens) komplett abzusaufen (allein gestern hatten wir 7 (!) Reboots)…ihr könnt euch sicher vorstellen wieviel Spaß es macht alle paar Minuten zu schauen ob der Shop noch „da“ ist…:x Lt. HostEurope ist unser Paket aber mehr als ausreichend dimensioniert (eher sogar überdimensioniert)…der Support ist der Meinung das das Problem die Shop-Datenbank ist und rät uns die Datenbank zu „optimieren“. Ich hab mal die Slow-Queries unten angehängt (sorry für das ewig lange Log…:oops:…habe es schon gekürzt damit ich es überhaupt posten kann…;)) Jemand eine Idee woran es liegen könnte? Bin langsam echt ratlos… [quote]/usr/sbin/mysqld, Version: 5.1.49-3~bpo50+1-log ((Debian)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument # Time: 130203 14:30:56 # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 18.518514 Lock\_time: 0.000428 Rows\_sent: 0 Rows\_examined: 354 use db1111111-ksv12; SET timestamp=1359898256; SELECT fv.optionID AS id, COUNT(DISTINCT a.id) AS count, fo.id AS optionID, fo.name AS optionName, f.id AS groupID, f.name AS groupName, fv.value AS optionValue, fv.id AS valueID, st.objectdata AS optionNameTranslation, st2.objectdata AS groupNameTranslation, st3.objectdata AS valueTranslation FROM s\_categories c, s\_categories c2, s\_articles\_categories ac JOIN s\_filter\_articles fa ON fa.articleID=ac.articleID JOIN s\_filter\_values fv ON fv.id=fa.valueID JOIN s\_filter\_options fo ON fo.id=fv.optionID AND fo.filterable = 1 JOIN s\_articles a ON a.id=ac.articleID AND a.active =1 AND a.changetime \<= NOW() JOIN s\_filter f ON f.id=a.filtergroupID LEFT JOIN s\_filter\_relations fr ON f.id = fr.groupId AND fo.id = fr.optionId LEFT JOIN s\_articles\_avoid\_customergroups ag ON ag.articleID=fa.articleID AND ag.customergroupID=1 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=’’ INNER JOIN s\_filter\_articles fv1110 ON fv1110.articleID = a.id AND fv1110.valueID = 1110 INNER JOIN s\_filter\_articles fv1111 ON fv1111.articleID = a.id AND fv1111.valueID = 1111 INNER JOIN s\_filter\_articles fv1124 ON fv1124.articleID = a.id AND fv1124.valueID = 1124 INNER JOIN s\_filter\_articles fv1191 ON fv1191.articleID = a.id AND fv1191.valueID = 1191 INNER JOIN s\_filter\_articles fv1192 ON fv1192.articleID = a.id AND fv1192.valueID = 1192 INNER JOIN s\_filter\_articles fv1196 ON fv1196.articleID = a.id AND fv1196.valueID = 1196 INNER JOIN s\_filter\_articles fv1201 ON fv1201.articleID = a.id AND fv1201.valueID = 1201 WHERE c.id=3 AND c2.active=1 AND c2.left \>= c.left AND c2.right \<= c.right AND ac.articleID=a.id AND ac.categoryID=c2.id AND ag.articleID IS NULL GROUP BY fv.id ORDER BY fr.position, fo.name ASC, IF(f.sortmode=1, TRIM(REPLACE(fv.value,’,’,’.’))+0, 0), IF(f.sortmode=2, COUNT(\*) , 0) DESC, IF(f.sortmode=3, fv.position, 0), fv.value; # Time: 130203 14:36:26 # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 317.081396 Lock\_time: 0.000311 Rows\_sent: 0 Rows\_examined: 354 SET timestamp=1359898586; SELECT fv.optionID AS id, COUNT(DISTINCT a.id) AS count, fo.id AS optionID, fo.name AS optionName, f.id AS groupID, f.name AS groupName, fv.value AS optionValue, fv.id AS valueID, st.objectdata AS optionNameTranslation, st2.objectdata AS groupNameTranslation, st3.objectdata AS valueTranslation FROM s\_categories c, s\_categories c2, s\_articles\_categories ac JOIN s\_filter\_articles fa ON fa.articleID=ac.articleID JOIN s\_filter\_values fv ON fv.id=fa.valueID JOIN s\_filter\_options fo ON fo.id=fv.optionID AND fo.filterable = 1 JOIN s\_articles a ON a.id=ac.articleID AND a.active =1 AND a.changetime \<= NOW() JOIN s\_filter f ON f.id=a.filtergroupID LEFT JOIN s\_filter\_relations fr ON f.id = fr.groupId AND fo.id = fr.optionId LEFT JOIN s\_articles\_avoid\_customergroups ag ON ag.articleID=fa.articleID AND ag.customergroupID=1 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=’’ INNER JOIN s\_filter\_articles fv1110 ON fv1110.articleID = a.id AND fv1110.valueID = 1110 INNER JOIN s\_filter\_articles fv1111 ON fv1111.articleID = a.id AND fv1111.valueID = 1111 INNER JOIN s\_filter\_articles fv1124 ON fv1124.articleID = a.id AND fv1124.valueID = 1124 INNER JOIN s\_filter\_articles fv1191 ON fv1191.articleID = a.id AND fv1191.valueID = 1191 INNER JOIN s\_filter\_articles fv1211 ON fv1211.articleID = a.id AND fv1211.valueID = 1211 INNER JOIN s\_filter\_articles fv1198 ON fv1198.articleID = a.id AND fv1198.valueID = 1198 INNER JOIN s\_filter\_articles fv1207 ON fv1207.articleID = a.id AND fv1207.valueID = 1207 INNER JOIN s\_filter\_articles fv1204 ON fv1204.articleID = a.id AND fv1204.valueID = 1204 WHERE c.id=3 AND c2.active=1 AND c2.left \>= c.left AND c2.right \<= c.right AND ac.articleID=a.id AND ac.categoryID=c2.id AND ag.articleID IS NULL GROUP BY fv.id ORDER BY fr.position, fo.name ASC, IF(f.sortmode=1, TRIM(REPLACE(fv.value,’,’,’.’))+0, 0), IF(f.sortmode=2, COUNT(\*) , 0) DESC, IF(f.sortmode=3, fv.position, 0), fv.value; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 103.414477 Lock\_time: 0.000102 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898586; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.424686 Lock\_time: 0.000119 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898586; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 70.533458 Lock\_time: 0.000127 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898586; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 18.450549 Lock\_time: 0.000178 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898586; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 48.511954 Lock\_time: 0.000147 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898586; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 25.237254 Lock\_time: 0.000131 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898586; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # Time: 130203 14:38:49 # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 143.134847 Lock\_time: 0.000100 Rows\_sent: 2 Rows\_examined: 62 SET timestamp=1359898729; 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 = NULL LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚Log‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 142.906776 Lock\_time: 0.000094 Rows\_sent: 0 Rows\_examined: 58 SET timestamp=1359898729; SELECT s0\_.id AS id0 FROM s\_emarketing\_banners s0\_ WHERE (s0\_.valid\_from \<= ‚2013-02-03 14:36:26‘ OR (s0\_.valid\_from = NULL OR s0\_.valid\_from IS NULL)) AND (s0\_.valid\_to \>= ‚2013-02-03 14:36:26‘ OR (s0\_.valid\_to = NULL OR s0\_.valid\_to IS NULL)) AND s0\_.categoryID = 3; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 142.908353 Lock\_time: 0.000465 Rows\_sent: 1 Rows\_examined: 9 SET timestamp=1359898729; SELECT s0\_.id AS id0, s0\_.main\_id AS main\_id1, s0\_.name AS name2, s0\_.title AS title3, s0\_.position AS position4, s0\_.host AS host5, s0\_.base\_path AS base\_path6, s0\_.base\_url AS base\_url7, s0\_.hosts AS hosts8, s0\_.secure AS secure9, s0\_.secure\_host AS secure\_host10, s0\_.secure\_base\_path AS secure\_base\_path11, s0\_.`default` AS default12, s0\_.active AS active13, s0\_.customer\_scope AS customer\_scope14, s1\_.id AS id15, s1\_.main\_id AS main\_id16, s1\_.name AS name17, s1\_.title AS title18, s1\_.position AS position19, s1\_.host AS host20, s1\_.base\_path AS base\_path21, s1\_.base\_url AS base\_url22, s1\_.hosts AS hosts23, s1\_.secure AS secure24, s1\_.secure\_host AS secure\_host25, s1\_.secure\_base\_path AS secure\_base\_path26, s1\_.`default` AS default27, s1\_.active AS active28, s1\_.customer\_scope AS customer\_scope29, s2\_.id AS id30, s2\_.locale AS locale31, s2\_.language AS language32, s2\_.territory AS territory33, s3\_.id AS id34, s3\_.currency AS currency35, s3\_.name AS name36, s3\_.standard AS standard37, s3\_.factor AS factor38, s3\_.templatechar AS templatechar39, s3\_.symbol\_position AS symbol\_position40, s3\_.position AS position41, s4\_.id AS id42, s4\_.template AS template43, s4\_.name AS name44, s4\_.description AS description45, s4\_.author AS author46, s4\_.license AS license47, s4\_.esi AS esi48, s4\_.style\_support AS style\_support49, s4\_.emotion AS emotion50, s4\_.version AS version51, s4\_.plugin\_id AS plugin\_id52, s5\_.id AS id53, s5\_.currency AS currency54, s5\_.name AS name55, s5\_.standard AS standard56, s5\_.factor AS factor57, s5\_.templatechar AS templatechar58, s5\_.symbol\_position AS symbol\_position59, s5\_.position AS position60, s0\_.main\_id AS main\_id61, s0\_.template\_id AS template\_id62, s0\_.document\_template\_id AS document\_template\_id63, s0\_.category\_id AS category\_id64, s0\_.locale\_id AS locale\_id65, s0\_.currency\_id AS currency\_id66, s0\_.customer\_group\_id AS customer\_group\_id67, s0\_.fallback\_id AS fallback\_id68, s1\_.main\_id AS main\_id69, s1\_.template\_id AS template\_id70, s1\_.document\_template\_id AS document\_template\_id71, s1\_.category\_id AS category\_id72, s1\_.locale\_id AS locale\_id73, s1\_.currency\_id AS currency\_id74, s1\_.customer\_group\_id AS customer\_group\_id75, s1\_.fallback\_id AS fallback\_id76, s4\_.plugin\_id AS plugin\_id77 FROM s\_core\_shops s0\_ LEFT JOIN s\_core\_shops s1\_ ON s0\_.main\_id = s1\_.id LEFT JOIN s\_core\_locales s2\_ ON s0\_.locale\_id = s2\_.id LEFT JOIN s\_core\_currencies s3\_ ON s0\_.currency\_id = s3\_.id LEFT JOIN s\_core\_templates s4\_ ON s0\_.template\_id = s4\_.id LEFT JOIN s\_core\_shop\_currencies s6\_ ON s0\_.id = s6\_.shop\_id LEFT JOIN s\_core\_currencies s5\_ ON s5\_.id = s6\_.currency\_id LEFT JOIN s\_core\_shop\_pages s8\_ ON s0\_.id = s8\_.shop\_id LEFT JOIN s\_cms\_static\_groups s7\_ ON s7\_.id = s8\_.group\_id LEFT JOIN s\_core\_customergroups s9\_ ON s0\_.customer\_group\_id = s9\_.id LEFT JOIN s\_core\_templates s10\_ ON s1\_.template\_id = s10\_.id LEFT JOIN s\_core\_shop\_currencies s12\_ ON s1\_.id = s12\_.shop\_id LEFT JOIN s\_core\_currencies s11\_ ON s11\_.id = s12\_.currency\_id WHERE s0\_.active = 1 AND (s0\_.host = ‚[www.kaffeestore.com](http://www.kaffeestore.com)‘ OR (s0\_.host IS NULL AND s1\_.host = ‚[www.kaffeestore.com](http://www.kaffeestore.com)‘)) ORDER BY s0\_.main\_id ASC, s0\_.position ASC, s5\_.position ASC, s5\_.id ASC; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 142.911663 Lock\_time: 0.000038 Rows\_sent: 14 Rows\_examined: 14 SET timestamp=1359898729; SELECT basename, basefile, inheritname, inheritfile FROM s\_core\_factory; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 142.911430 Lock\_time: 0.000026 Rows\_sent: 1 Rows\_examined: 1 SET timestamp=1359898729; SELECT host FROM s\_core\_shops WHERE `default`=1; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 129.847322 Lock\_time: 0.000124 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898729; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 112.925369 Lock\_time: 0.000099 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898729; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 93.040669 Lock\_time: 0.000099 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898729; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 82.985717 Lock\_time: 0.000112 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898729; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 71.957817 Lock\_time: 0.000127 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898729; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 101.830903 Lock\_time: 0.000094 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898729; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 41.292093 Lock\_time: 0.000225 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898729; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 142.947972 Lock\_time: 0.000102 Rows\_sent: 2 Rows\_examined: 62 SET timestamp=1359898729; 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 = ‚1‘ LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚Compare‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 143.230793 Lock\_time: 0.000067 Rows\_sent: 5 Rows\_examined: 65 SET timestamp=1359898729; 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 = ‚1‘ LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚LastArticles‘; # Time: 130203 14:38:50 # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 17.258584 Lock\_time: 0.000179 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898730; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 12.810736 Lock\_time: 0.000151 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898730; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 33.768010 Lock\_time: 0.000193 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898730; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 400.923219 Lock\_time: 0.000446 Rows\_sent: 0 Rows\_examined: 354 SET timestamp=1359898730; SELECT fv.optionID AS id, COUNT(DISTINCT a.id) AS count, fo.id AS optionID, fo.name AS optionName, f.id AS groupID, f.name AS groupName, fv.value AS optionValue, fv.id AS valueID, st.objectdata AS optionNameTranslation, st2.objectdata AS groupNameTranslation, st3.objectdata AS valueTranslation FROM s\_categories c, s\_categories c2, s\_articles\_categories ac JOIN s\_filter\_articles fa ON fa.articleID=ac.articleID JOIN s\_filter\_values fv ON fv.id=fa.valueID JOIN s\_filter\_options fo ON fo.id=fv.optionID AND fo.filterable = 1 JOIN s\_articles a ON a.id=ac.articleID AND a.active =1 AND a.changetime \<= NOW() JOIN s\_filter f ON f.id=a.filtergroupID LEFT JOIN s\_filter\_relations fr ON f.id = fr.groupId AND fo.id = fr.optionId LEFT JOIN s\_articles\_avoid\_customergroups ag ON ag.articleID=fa.articleID AND ag.customergroupID=1 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=’’ INNER JOIN s\_filter\_articles fv1110 ON fv1110.articleID = a.id AND fv1110.valueID = 1110 INNER JOIN s\_filter\_articles fv1120 ON fv1120.articleID = a.id AND fv1120.valueID = 1120 INNER JOIN s\_filter\_articles fv1131 ON fv1131.articleID = a.id AND fv1131.valueID = 1131 INNER JOIN s\_filter\_articles fv1193 ON fv1193.articleID = a.id AND fv1193.valueID = 1193 INNER JOIN s\_filter\_articles fv1192 ON fv1192.articleID = a.id AND fv1192.valueID = 1192 INNER JOIN s\_filter\_articles fv1199 ON fv1199.articleID = a.id AND fv1199.valueID = 1199 INNER JOIN s\_filter\_articles fv1202 ON fv1202.articleID = a.id AND fv1202.valueID = 1202 INNER JOIN s\_filter\_articles fv596 ON fv596.articleID = a.id AND fv596.valueID = 596 WHERE c.id=3 AND c2.active=1 AND c2.left \>= c.left AND c2.right \<= c.right AND ac.articleID=a.id AND ac.categoryID=c2.id AND ag.articleID IS NULL GROUP BY fv.id ORDER BY fr.position, fo.name ASC, IF(f.sortmode=1, TRIM(REPLACE(fv.value,’,’,’.’))+0, 0), IF(f.sortmode=2, COUNT(\*) , 0) DESC, IF(f.sortmode=3, fv.position, 0), fv.value; # Time: 130203 14:40:26 # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.699936 Lock\_time: 0.000143 Rows\_sent: 2 Rows\_examined: 62 SET timestamp=1359898826; 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 = ‚1‘ LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚Compare‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.417350 Lock\_time: 0.000097 Rows\_sent: 0 Rows\_examined: 21 SET timestamp=1359898826; SELECT org\_path, main FROM s\_core\_rewrite\_urls WHERE path LIKE ‚Deutsch\_cat\_3.html‘ AND subshopID =‚1‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.443652 Lock\_time: 0.000030 Rows\_sent: 1 Rows\_examined: 1 SET timestamp=1359898826; SELECT id as `key`, m.\* FROM s\_core\_multilanguage m; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.699472 Lock\_time: 0.000399 Rows\_sent: 0 Rows\_examined: 915 SET timestamp=1359898826; SELECT a.id as articleID, aDetails.id AS articleDetailsID, a.notification as notification, weight, aDetails.ordernumber, a.datum, aDetails.releasedate, additionaltext, aDetails.shippingfree,aDetails.shippingtime,instock, a.description AS description, description\_long, aSupplier.name AS supplierName, aSupplier.img AS supplierImg, a.name AS articleName, topseller as highlight, IFNULL(p.price, p2.price) as price, laststock, sales, IF(p.pseudoprice,p.pseudoprice,p2.pseudoprice) as pseudoprice, aTax.tax, taxID, aDetails.minpurchase, aDetails.purchasesteps, aDetails.maxpurchase, aDetails.purchaseunit, aDetails.referenceunit, aDetails.unitID, pricegroupID, pricegroupActive, IFNULL(p.pricegroup,IFNULL(p2.pricegroup,‚EK‘)) as pricegroup, attr1,attr2,attr3,attr4,attr5,attr6,attr7,attr8,attr9,attr10, attr11,attr12,attr13,attr14,attr15,attr16,attr17,attr18,attr19,attr20, – cd.discount, IFNULL((SELECT 1 FROM s\_articles\_details WHERE articleID=a.id AND kind=2 LIMIT 1), 0) as variants, (a.configurator\_set\_id IS NOT NULL) as sConfigurator, IFNULL((SELECT 1 FROM s\_articles\_esd WHERE articleID=a.id LIMIT 1), 0) as esd, IFNULL(( SELECT CONCAT(AVG(points),’|’,COUNT(\*)) as votes FROM s\_articles\_vote WHERE active=1 AND articleID=a.id), ‚0.00|00‘) as sVoteAverange, IF(DATEDIFF(NOW(), a.datum)\<=30,1,0) as newArticle, IF(aDetails.sales\>=30,1,0) as topseller, IF(aDetails.releasedate\>CURDATE(),1,0) as sUpcoming, IF(aDetails.releasedate\>CURDATE(), aDetails.releasedate, ‚‘) as sReleasedate FROM s\_categories c, s\_categories c2, s\_articles\_categories ac JOIN s\_articles AS a ON a.id=ac.articleID AND a.mode = 0 AND a.active=1 JOIN s\_articles\_details AS aDetails ON aDetails.id=a.main\_detail\_id JOIN s\_articles\_attributes AS aAttributes ON aAttributes.articledetailsID=aDetails.id JOIN s\_core\_tax AS aTax ON aTax.id=a.taxID LEFT JOIN s\_articles\_avoid\_customergroups ag ON ag.articleID=a.id AND ag.customergroupID=1 LEFT JOIN s\_articles\_supplier AS aSupplier ON aSupplier.id=a.supplierID INNER JOIN s\_filter\_articles fv1110 ON fv1110.articleID = a.id AND fv1110.valueID = 1110 INNER JOIN s\_filter\_articles fv1120 ON fv1120.articleID = a.id AND fv1120.valueID = 1120 INNER JOIN s\_filter\_articles fv1133 ON fv1133.articleID = a.id AND fv1133.valueID = 1133 INNER JOIN s\_filter\_articles fv1190 ON fv1190.articleID = a.id AND fv1190.valueID = 1190 INNER JOIN s\_filter\_articles fv1211 ON fv1211.articleID = a.id AND fv1211.valueID = 1211 INNER JOIN s\_filter\_articles fv1194 ON fv1194.articleID = a.id AND fv1194.valueID = 1194 INNER JOIN s\_filter\_articles fv1207 ON fv1207.articleID = a.id AND fv1207.valueID = 1207 INNER JOIN s\_filter\_articles fv594 ON fv594.articleID = a.id AND fv594.valueID = 594 LEFT JOIN s\_articles\_prices p ON p.articleDetailsID=aDetails.id AND p.pricegroup=‚EK‘ AND p.to=‚beliebig‘ LEFT JOIN s\_articles\_prices p2 ON p2.articledetailsID=aDetails.id AND p2.pricegroup=‚EK‘ AND p2.to=‚beliebig‘ WHERE c.id=3 AND c2.active=1 AND c2.left \>= c.left AND c2.right \<= c.right AND ac.articleID=a.id AND ac.categoryID=c2.id AND ag.articleID IS NULL GROUP BY a.id ORDER BY a.datum DESC, a.id LIMIT 0, 12; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.445097 Lock\_time: 0.000062 Rows\_sent: 1 Rows\_examined: 1 SET timestamp=1359898826; SELECT id as `key`, m.\* FROM s\_core\_multilanguage m; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.715264 Lock\_time: 0.000290 Rows\_sent: 6 Rows\_examined: 2154 SET timestamp=1359898826; SELECT (s0\_.`right` - s0\_.`left` - 1) / 2 AS sclr0, (SELECT COUNT(s1\_.id) AS dctrn\_\_1 FROM s\_categories s2\_ INNER JOIN s\_articles\_categories s3\_ ON s2\_.id = s3\_.categoryID INNER JOIN s\_articles s1\_ ON s1\_.id = s3\_.articleID AND (s1\_.active = 1) WHERE s2\_.active = 1 AND (s2\_.`right` \<= s0\_.`right` AND s2\_.`left` \>= s0\_.`left`)) AS sclr1, s4\_.id AS id2, s0\_.id AS id3, s0\_.parent AS parent4, s0\_.description AS description5, s0\_.position AS position6, s0\_.`left` AS left7, s0\_.level AS level8, s0\_.`right` AS right9, s0\_.metakeywords AS metakeywords10, s0\_.metadescription AS metadescription11, s0\_.cmsheadline AS cmsheadline12, s0\_.cmstext AS cmstext13, s0\_.active AS active14, s0\_.template AS template15, s0\_.blog AS blog16, s0\_.showfiltergroups AS showfiltergroups17, s0\_.external AS external18, s0\_.hidefilter AS hidefilter19, s0\_.hidetop AS hidetop20, s0\_.noviewselect AS noviewselect21, s0\_.changed AS changed22, s0\_.added AS added23, s5\_.id AS id24, s5\_.albumID AS albumID25, s5\_.name AS name26, s5\_.description AS description27, s5\_.path AS path28, s5\_.type AS type29, s5\_.extension AS extension30, s5\_.userID AS userID31, s5\_.created AS created32, s5\_.file\_size AS file\_size33, s6\_.id AS id34, s6\_.categoryID AS categoryID35, s6\_.attribute1 AS attribute136, s6\_.attribute2 AS attribute237, s6\_.attribute3 AS attribute338, s6\_.attribute4 AS attribute439, s6\_.attribute5 AS attribute540, s6\_.attribute6 AS attribute641 FROM s\_categories s0\_ LEFT JOIN s\_media s5\_ ON s0\_.mediaID = s5\_.id LEFT JOIN s\_categories\_attributes s6\_ ON s0\_.id = s6\_.categoryID LEFT JOIN s\_categories\_avoid\_customergroups s7\_ ON s0\_.id = s7\_.categoryID LEFT JOIN s\_core\_customergroups s4\_ ON s4\_.id = s7\_.customergroupID AND (s4\_.id = 1) WHERE s0\_.active = 1 AND s0\_.parent = 3 GROUP BY s0\_.id HAVING (sclr1 \> 0 OR s0\_.external IS NOT NULL OR s0\_.blog = 1) AND s4\_.id IS NULL ORDER BY s0\_.`left` ASC; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.726592 Lock\_time: 0.000060 Rows\_sent: 31 Rows\_examined: 31 SET timestamp=1359898826; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Frontend‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.677636 Lock\_time: 0.000112 Rows\_sent: 2 Rows\_examined: 62 SET timestamp=1359898826; 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 = NULL LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚Log‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.708573 Lock\_time: 0.000070 Rows\_sent: 3 Rows\_examined: 67 SET timestamp=1359898826; 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 = ‚1‘ LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚Google‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 96.743642 Lock\_time: 0.000100 Rows\_sent: 4 Rows\_examined: 64 SET timestamp=1359898826; 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 = ‚1‘ LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚InputFilter‘; # Time: 130203 14:41:45 # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.853594 Lock\_time: 0.000065 Rows\_sent: 0 Rows\_examined: 0 SET timestamp=1359898905; SELECT module, host, license FROM s\_core\_licenses WHERE active=1; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.880027 Lock\_time: 0.000341 Rows\_sent: 1 Rows\_examined: 7 SET timestamp=1359898905; SELECT a.id as articleID, d.id AS articleDetailsID, d.ordernumber, datum, sales, topseller as highlight, a.description, a. description\_long, s.name AS supplierName, s.img AS supplierImg, a.name AS articleName, a.taxID, IFNULL(p.price,p2.price) as price, IF(p.pseudoprice, p.pseudoprice, p2.pseudoprice) as pseudoprice, tax, attr1,attr2,attr3,attr4,attr5,attr6,attr7,attr8,attr9,attr10, attr11,attr12,attr13,attr14,attr15,attr16,attr17,attr18,attr19,attr20, instock, weight, a.shippingtime, IFNULL(p.pricegroup, IFNULL(p2.pricegroup, ‚EK‘)) as pricegroup, pricegroupID, pricegroupActive, filtergroupID, d.purchaseunit, d.referenceunit, d.unitID, laststock, additionaltext, (a.configurator\_set\_id IS NOT NULL) as sConfigurator, IFNULL((SELECT 1 FROM s\_articles\_esd WHERE articleID=a.id LIMIT 1), 0) as esd, IFNULL((SELECT CONCAT(AVG(points),’|’,COUNT(\*)) as votes FROM s\_articles\_vote WHERE active=1 AND articleID=a.id),‚0.00|00‘) as sVoteAverange, IF(DATE\_SUB(CURDATE(), INTERVAL 30 DAY) \<= a.datum, 1, 0) as newArticle, IF(d.sales\>=30, 1, 0) as topseller, IF(d.releasedate \> CURDATE(), 1, 0) as sUpcoming, IF(d.releasedate \> CURDATE(), d.releasedate, ‚‘) as sReleasedate, (SELECT 1 FROM s\_articles\_details WHERE articleID=a.id AND kind!=1 LIMIT 1) as sVariantArticle FROM s\_articles a JOIN s\_articles\_details d ON d.articleID=a.id AND d.kind=1 – JOIN s\_articles\_categories ac – ON ac.articleID=a.id – AND ac.categoryID=1 JOIN s\_articles\_attributes at ON at.articleID=a.id JOIN s\_core\_tax t ON t.id=a.taxID LEFT JOIN s\_articles\_supplier s ON s.id=a.supplierID LEFT JOIN s\_articles\_prices p ON p.articleDetailsID=d.id AND p.pricegroup=‚EK‘ AND p.`from`=‚1‘ LEFT JOIN s\_articles\_prices p2 ON p2.articleDetailsID=d.id AND p2.pricegroup=‚EK‘ AND p2.`from`=‚1‘ WHERE a.id=‚4‘ AND a.active=1 LIMIT 1; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.893115 Lock\_time: 0.000134 Rows\_sent: 18 Rows\_examined: 572 SET timestamp=1359898905; 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=‚1‘ WHERE g.active=1 AND parentID=0 AND CONCAT(’|’, p.grouping, ‚|‘) LIKE CONCAT(’%|’, g.key, ‚|%‘) AND (m.id IS NULL OR s.shop\_id IS NOT NULL) AND (m.id IS NULL OR m.active=1) ORDER BY `mapping`, p.position, p.description; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.838998 Lock\_time: 0.000108 Rows\_sent: 0 Rows\_examined: 58 SET timestamp=1359898905; SELECT s0\_.id AS id0 FROM s\_emarketing\_banners s0\_ WHERE (s0\_.valid\_from \<= ‚2013-02-03 14:40:26‘ OR (s0\_.valid\_from = NULL OR s0\_.valid\_from IS NULL)) AND (s0\_.valid\_to \>= ‚2013-02-03 14:40:26‘ OR (s0\_.valid\_to = NULL OR s0\_.valid\_to IS NULL)) AND s0\_.categoryID = 3; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.826096 Lock\_time: 0.000079 Rows\_sent: 0 Rows\_examined: 21 SET timestamp=1359898905; SELECT org\_path, main FROM s\_core\_rewrite\_urls WHERE path LIKE ‚Deutsch\_cat\_3.html‘ AND subshopID =‚1‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 175.618684 Lock\_time: 0.000067 Rows\_sent: 12 Rows\_examined: 300 SET timestamp=1359898905; SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s\_core\_subscribes ce JOIN s\_core\_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace=‚Backend‘ WHERE ce.type=0 ORDER BY name, position; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 8.221703 Lock\_time: 0.000144 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898905; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 175.354620 Lock\_time: 0.000088 Rows\_sent: 12 Rows\_examined: 300 SET timestamp=1359898905; SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s\_core\_subscribes ce JOIN s\_core\_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace=‚Backend‘ WHERE ce.type=0 ORDER BY name, position; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 175.651351 Lock\_time: 0.026884 Rows\_sent: 31 Rows\_examined: 300 SET timestamp=1359898905; SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s\_core\_subscribes ce JOIN s\_core\_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace=‚Core‘ WHERE ce.type=0 ORDER BY name, position; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 119.532036 Lock\_time: 0.000139 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898905; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 90.747486 Lock\_time: 0.000142 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898905; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 76.499092 Lock\_time: 0.000111 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898905; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.890434 Lock\_time: 0.000136 Rows\_sent: 49 Rows\_examined: 300 SET timestamp=1359898905; SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s\_core\_subscribes ce JOIN s\_core\_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace=‚Frontend‘ WHERE ce.type=0 ORDER BY name, position; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 157.641042 Lock\_time: 0.000146 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898905; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 175.626854 Lock\_time: 0.000063 Rows\_sent: 31 Rows\_examined: 300 SET timestamp=1359898905; SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s\_core\_subscribes ce JOIN s\_core\_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace=‚Core‘ WHERE ce.type=0 ORDER BY name, position; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 515.504939 Lock\_time: 0.000404 Rows\_sent: 0 Rows\_examined: 354 SET timestamp=1359898905; SELECT fv.optionID AS id, COUNT(DISTINCT a.id) AS count, fo.id AS optionID, fo.name AS optionName, f.id AS groupID, f.name AS groupName, fv.value AS optionValue, fv.id AS valueID, st.objectdata AS optionNameTranslation, st2.objectdata AS groupNameTranslation, st3.objectdata AS valueTranslation FROM s\_categories c, s\_categories c2, s\_articles\_categories ac JOIN s\_filter\_articles fa ON fa.articleID=ac.articleID JOIN s\_filter\_values fv ON fv.id=fa.valueID JOIN s\_filter\_options fo ON fo.id=fv.optionID AND fo.filterable = 1 JOIN s\_articles a ON a.id=ac.articleID AND a.active =1 AND a.changetime \<= NOW() JOIN s\_filter f ON f.id=a.filtergroupID LEFT JOIN s\_filter\_relations fr ON f.id = fr.groupId AND fo.id = fr.optionId LEFT JOIN s\_articles\_avoid\_customergroups ag ON ag.articleID=fa.articleID AND ag.customergroupID=1 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=’’ INNER JOIN s\_filter\_articles fv1110 ON fv1110.articleID = a.id AND fv1110.valueID = 1110 INNER JOIN s\_filter\_articles fv1111 ON fv1111.articleID = a.id AND fv1111.valueID = 1111 INNER JOIN s\_filter\_articles fv1124 ON fv1124.articleID = a.id AND fv1124.valueID = 1124 INNER JOIN s\_filter\_articles fv1191 ON fv1191.articleID = a.id AND fv1191.valueID = 1191 INNER JOIN s\_filter\_articles fv1211 ON fv1211.articleID = a.id AND fv1211.valueID = 1211 INNER JOIN s\_filter\_articles fv1198 ON fv1198.articleID = a.id AND fv1198.valueID = 1198 INNER JOIN s\_filter\_articles fv1207 ON fv1207.articleID = a.id AND fv1207.valueID = 1207 INNER JOIN s\_filter\_articles fv1204 ON fv1204.articleID = a.id AND fv1204.valueID = 1204 WHERE c.id=3 AND c2.active=1 AND c2.left \>= c.left AND c2.right \<= c.right AND ac.articleID=a.id AND ac.categoryID=c2.id AND ag.articleID IS NULL GROUP BY fv.id ORDER BY fr.position, fo.name ASC, IF(f.sortmode=1, TRIM(REPLACE(fv.value,’,’,’.’))+0, 0), IF(f.sortmode=2, COUNT(\*) , 0) DESC, IF(f.sortmode=3, fv.position, 0), fv.value; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.938739 Lock\_time: 0.000142 Rows\_sent: 6 Rows\_examined: 66 SET timestamp=1359898905; 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 = ‚1‘ LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚TagCloud‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 125.867835 Lock\_time: 0.000134 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898905; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.923369 Lock\_time: 0.000087 Rows\_sent: 4 Rows\_examined: 64 SET timestamp=1359898905; 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 = ‚1‘ LEFT JOIN s\_core\_config\_values cm ON cm.element\_id = ce.id AND cm.shop\_id = ‚1‘ WHERE p.name=‚InputFilter‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 175.649675 Lock\_time: 0.000029 Rows\_sent: 14 Rows\_examined: 14 SET timestamp=1359898905; SELECT basename, basefile, inheritname, inheritfile FROM s\_core\_factory; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 175.382773 Lock\_time: 0.000045 Rows\_sent: 31 Rows\_examined: 31 SET timestamp=1359898905; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Frontend‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 29.580411 Lock\_time: 0.000157 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898905; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 78.919014 Lock\_time: 0.000457 Rows\_sent: 6 Rows\_examined: 2154 SET timestamp=1359898905; SELECT (s0\_.`right` - s0\_.`left` - 1) / 2 AS sclr0, (SELECT COUNT(s1\_.id) AS dctrn\_\_1 FROM s\_categories s2\_ INNER JOIN s\_articles\_categories s3\_ ON s2\_.id = s3\_.categoryID INNER JOIN s\_articles s1\_ ON s1\_.id = s3\_.articleID AND (s1\_.active = 1) WHERE s2\_.active = 1 AND (s2\_.`right` \<= s0\_.`right` AND s2\_.`left` \>= s0\_.`left`)) AS sclr1, s4\_.id AS id2, s0\_.id AS id3, s0\_.parent AS parent4, s0\_.description AS description5, s0\_.position AS position6, s0\_.`left` AS left7, s0\_.level AS level8, s0\_.`right` AS right9, s0\_.metakeywords AS metakeywords10, s0\_.metadescription AS metadescription11, s0\_.cmsheadline AS cmsheadline12, s0\_.cmstext AS cmstext13, s0\_.active AS active14, s0\_.template AS template15, s0\_.blog AS blog16, s0\_.showfiltergroups AS showfiltergroups17, s0\_.external AS external18, s0\_.hidefilter AS hidefilter19, s0\_.hidetop AS hidetop20, s0\_.noviewselect AS noviewselect21, s0\_.changed AS changed22, s0\_.added AS added23, s5\_.id AS id24, s5\_.albumID AS albumID25, s5\_.name AS name26, s5\_.description AS description27, s5\_.path AS path28, s5\_.type AS type29, s5\_.extension AS extension30, s5\_.userID AS userID31, s5\_.created AS created32, s5\_.file\_size AS file\_size33, s6\_.id AS id34, s6\_.categoryID AS categoryID35, s6\_.attribute1 AS attribute136, s6\_.attribute2 AS attribute237, s6\_.attribute3 AS attribute338, s6\_.attribute4 AS attribute439, s6\_.attribute5 AS attribute540, s6\_.attribute6 AS attribute641 FROM s\_categories s0\_ LEFT JOIN s\_media s5\_ ON s0\_.mediaID = s5\_.id LEFT JOIN s\_categories\_attributes s6\_ ON s0\_.id = s6\_.categoryID LEFT JOIN s\_categories\_avoid\_customergroups s7\_ ON s0\_.id = s7\_.categoryID LEFT JOIN s\_core\_customergroups s4\_ ON s4\_.id = s7\_.customergroupID AND (s4\_.id = 1) WHERE s0\_.active = 1 AND s0\_.parent = 3 GROUP BY s0\_.id HAVING (sclr1 \> 0 OR s0\_.external IS NOT NULL OR s0\_.blog = 1) AND s4\_.id IS NULL ORDER BY s0\_.`left` ASC; # Time: 130203 14:41:46 # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 176.085163 Lock\_time: 0.000050 Rows\_sent: 49 Rows\_examined: 300 SET timestamp=1359898906; SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s\_core\_subscribes ce JOIN s\_core\_plugins cp ON cp.id=ce.pluginID AND cp.active=1 AND cp.namespace=‚Frontend‘ WHERE ce.type=0 ORDER BY name, position; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 41.337718 Lock\_time: 0.000188 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898906; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 33.647352 Lock\_time: 0.000184 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898906; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 67.385674 Lock\_time: 0.000147 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898906; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 41.274738 Lock\_time: 0.000154 Rows\_sent: 22 Rows\_examined: 22 SET timestamp=1359898906; SELECT name, id, name, label, description, source, active, installation\_date as installationDate, update\_date as updateDate, changes, version FROM s\_core\_plugins WHERE namespace=‚Core‘; # User@Host: db1111111-db1[db1111111-db1] @ localhost # Query\_time: 456.553975 Lock\_time: 0.000568 Rows\_sent: 0 Rows\_examined: 354 SET timestamp=1359898906; SELECT fv.optionID AS id, COUNT(DISTINCT a.id) AS count, fo.id AS optionID, fo.name AS optionName, f.id AS groupID, f.name AS groupName, fv.value AS optionValue, fv.id AS valueID, st.objectdata AS optionNameTranslation, st2.objectdata AS groupNameTranslation, st3.objectdata AS valueTranslation FROM s\_categories c, s\_categories c2, s\_articles\_categories ac JOIN s\_filter\_articles fa ON fa.articleID=ac.articleID JOIN s\_filter\_values fv ON fv.id=fa.valueID JOIN s\_filter\_options fo ON fo.id=fv.optionID AND fo.filterable = 1 JOIN s\_articles a ON a.id=ac.articleID AND a.active =1 AND a.changetime \<= NOW() JOIN s\_filter f ON f.id=a.filtergroupID LEFT JOIN s\_filter\_relations fr ON f.id = fr.groupId AND fo.id = fr.optionId LEFT JOIN s\_articles\_avoid\_customergroups ag ON ag.articleID=fa.articleID AND ag.customergroupID=1 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=’’ INNER JOIN s\_filter\_articles fv1110 ON fv1110.articleID = a.id AND fv1110.valueID = 1110 INNER JOIN s\_filter\_articles fv1120 ON fv1120.articleID = a.id AND fv1120.valueID = 1120 INNER JOIN s\_filter\_articles fv1131 ON fv1131.articleID = a.id AND fv1131.valueID = 1131 INNER JOIN s\_filter\_articles fv1193 ON fv1193.articleID = a.id AND fv1193.valueID = 1193 INNER JOIN s\_filter\_articles fv1192 ON fv1192.articleID = a.id AND fv1192.valueID = 1192 INNER JOIN s\_filter\_articles fv1199 ON fv1199.articleID = a.id AND fv1199.valueID = 1199 INNER JOIN s\_filter\_articles fv1202 ON fv1202.articleID = a.id AND fv1202.valueID = 1202 INNER JOIN s\_filter\_articles fv596 ON fv596.articleID = a.id AND fv596.valueID = 596 WHERE c.id=3 AND c2.active=1 AND c2.left \>= c.left AND c2.right \<= c.right AND ac.articleID=a.id AND ac.categoryID=c2.id AND ag.articleID IS NULL GROUP BY fv.id ORDER BY fr.position, fo.name ASC, IF(f.sortmode=1, TRIM(REPLACE(fv.value,’,’,’.’))+0, 0), IF(f.sortmode=2, COUNT(\*) , 0) DESC, IF(f.sortmode=3, fv.position, 0), fv.value; [/quote]

---

<div class="post-metadata">

**Author:** ![Patrick\_Schucker](https://avatars.discourse-cdn.com/v4/letter/p/a5b964/32.png) [@Patrick\_Schucker](https://forum.shopware.com/u/Patrick_Schucker)\
**Post date:** [6. Februar 2013 um 16:32 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/2 "2013-02-06T16:32:01Z")

</div>

Hi, das Thema Performace steht bei uns ganz oben auf der Roadmap. In diesem Bereich wird es auf Dauer immer weitere Verbesserungen geben. Bei deinem Problem könnte vielleicht schon eine MySQL Option helfen. Die Option „optimizer\_search\_depth“ müsste auf „0“ gesetzt werden. Die Option müsste vom Hoster angepasst werden. Diese Option zu deaktivieren ist immer dann hilfreich, wenn Filter-Queriues Probleme verursachen. Dies scheint in deinem Fall zu sein. Wir würden uns das Problem auch gerne direkt bei dir anschauen. Vielleicht können wir Änderungen mit in die 4.0.7 übernehmen. Falls du möchtest, dann schick mir die Daten doch am besten an [entwicklung@shopware.de](mailto:entwicklung@shopware.de). Also komplette Zugangsdaten (Backend, FTP, phpMyAdmin) Grüße aus dem Münsterland Patrick

---

<div class="post-metadata">

**Author:** ![Porter](https://avatars.discourse-cdn.com/v4/letter/p/c5a1d2/32.png) [@Porter](https://forum.shopware.com/u/Porter)\
**Post date:** [6. Februar 2013 um 18:23 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/3 "2013-02-06T18:23:58Z")

</div>

Hi, das Angebot nehme ich dankend an (Mail geht in den nächsten Minuten raus)… Ich habe den HE-Support gebeten die Funktion auf 0 zu setzen, allerdings kommen die wohl erst Morgen dazu…:x…bis dahin verbläst es mir den Server so im Schnitt nach 10 min. von Neustart gerechnet… Ich habe in den Logs viele, ausschließlich vom BingBot angefragte (die robots.txt interessiert den nicht), GET Zugriffe auf [quote]/Deutsch\_cat\_3.html?sFilterProperties=…[/quote] Der Googlebot wiederum interessiert sich überhaupt nicht für die sFilterProperties… Könnte die o.g. Abfrage in größeren Mengen (wie gesagt der BingBot stürzt sich regelrecht auf die „GET /Deutsch\_cat\_3.html?sFilterProperties=…“) dazu führen das sich die DB beim Versuch den optimalen execution plan für die Anfragen zu berechnen (Standardwert für optimizer\_search\_depth soll irgendwas um die 60 sein) selbst wegschießt?

---

<div class="post-metadata">

**Author:** ![leseaw](https://avatars.discourse-cdn.com/v4/letter/l/73ab20/32.png) [@leseaw](https://forum.shopware.com/u/leseaw)\
**Post date:** [6. Februar 2013 um 18:29 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/4 "2013-02-06T18:29:34Z")

</div>

geh doch auf bing, melde dort deine seite an und probiere diesen pfad auszuschliessen? vielleicht rettet dich das ja über die nacht 🙂

---

<div class="post-metadata">

**Author:** ![Porter](https://avatars.discourse-cdn.com/v4/letter/p/c5a1d2/32.png) [@Porter](https://forum.shopware.com/u/Porter)\
**Post date:** [6. Februar 2013 um 18:43 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/5 "2013-02-06T18:43:43Z")

</div>

@leseaw …habe ich schon vor ca. 2-3 Wochen gemacht…:(…volles Programm inkl. Zeitplan wann der BingBot crawlen „darf“, wie schnell und inkl. der Parameter die er ignorieren (sFilterProperties z.B.) soll… Da der Bingbot (in der Theorie zumindest) die Angaben in der robots.txt zu den Bing Webmastertools priorisiert habe ich in der robots.txt auch nochmal die crawl delay etc. drin… Problem hierbei…das interessiert den buckligen Crawler offensichtlich überhaupt nicht…:-(…von den ca. 40 IPs die der BingBot hat halten sich vll. 10 daran…der Rest der Bande macht was er will…(–\> die die sich nicht dran halten kicke ich per .htaccess…ist aber ein Sch\*\*\*spiel und die Liste ist mittlerweile lang)…

---

<div class="post-metadata">

**Author:** ![nanrobicel](https://avatars.discourse-cdn.com/v4/letter/n/5f8ce5/32.png) [@nanrobicel](https://forum.shopware.com/u/nanrobicel)\
**Post date:** [11. Februar 2013 um 14:56 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/6 "2013-02-11T14:56:18Z")

</div>

@Porter Hat sich denn mittlerweile was getan mit deinem slowquery??? Dieses Eigenschaften Problem in Verbindung mit elenden Ladezeiten macht mir nämlich auch das leben zur hölle mfg robert

---

<div class="post-metadata">

**Author:** ![Porter](https://avatars.discourse-cdn.com/v4/letter/p/c5a1d2/32.png) [@Porter](https://forum.shopware.com/u/Porter)\
**Post date:** [12. Februar 2013 um 11:59 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/7 "2013-02-12T11:59:47Z")

</div>

Hi, ich habe es jetzt zumindest eingrenzen können. Wenn ich an meinen Shop eine Anfrage á la [quote]www.meinedomain/Deutsch\_cat\_3.html?sFilterProperties=1109%7C1112%7C1124%7C1191%7C1200%7C1209%7C1215%7C1203[/quote] stelle braucht mein Shop (der ansonsten wirklich gute Ladezeiten hat) im Schnitt satte (mit Stoppuhr gemessen) 40 Sekunden um dann folgende URL auszuliefern [quote][http://www.meinedomain.com/listing/?f=1109|1112|1124|1191|1200|1209|1215|1203[/quote]](http://www.meinedomain.com/listing/?f=1109%7C1112%7C1124%7C1191%7C1200%7C1209%7C1215%7C1203%5B/quote%5D) Da sich der BingBot (Googlebot ignoriert die „sFilterProperties“) wie blöd im Sekundentakt (tlw. mit 5-6 IP´s gleichzeitig) auf die sFilterProperties stürzt haut´s mir dann recht zeitnah den Server vom Stängele weil die Last hochschießt… Einzigste Abhilfe bisher ist das ich den BingBot konsequent per .htaccess ausschließe was aber keine Lösung sein kann… @Shopware Ich habe in meinem Shop Artikeleigenschaften hinterlegt, die stehen aber alle bei „filterbar“ auf inaktiv, d.h. im ganzen Shop kann man eigentlich nirgends „filtern“ (bis auf den Hersteller)… Ich verstehe nicht wie der Bingbot überhaupt zu den sFilterPropertie Anfragen kommt und hätte jetzt gedacht das der Shop die Anfrage gar nicht erst ausliefert (da ja auf inaktiv) und dann gleich auf die Startseite umleitet?!? Desweiteren steht auch bei den SEO´s die sFilterPropertie als „Nofollow Query“ drin, d.h. eigentlich dürfte der Bot dem Link doch gar nicht folgen? Habe ich da etwas falsch konfiguriert?

---

<div class="post-metadata">

**Author:** ![aikanet](https://avatars.discourse-cdn.com/v4/letter/a/3da27b/32.png) [@aikanet](https://forum.shopware.com/u/aikanet)\
**Post date:** [12. Februar 2013 um 12:15 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/8 "2013-02-12T12:15:05Z")

</div>

Handelt es sich um einen mehrsprachigen Shop?

---

<div class="post-metadata">

**Author:** ![Porter](https://avatars.discourse-cdn.com/v4/letter/p/c5a1d2/32.png) [@Porter](https://forum.shopware.com/u/Porter)\
**Post date:** [12. Februar 2013 um 13:35 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/9 "2013-02-12T13:35:54Z")

</div>

Hi, [quote]Handelt es sich um einen mehrsprachigen Shop?[/quote] Nein, Shop steht komplett auf “Deutsch”…(unter Shopeinstellungen --\> Shops habe ich nur einen Eintrag)…bei Lokalisierungen habe ich noch Englisch…das kann ich aber nicht löschen…

---

<div class="post-metadata">

**Author:** ![aikanet](https://avatars.discourse-cdn.com/v4/letter/a/3da27b/32.png) [@aikanet](https://forum.shopware.com/u/aikanet)\
**Post date:** [15. Februar 2013 um 21:01 UTC](https://forum.shopware.com/t/standig-arger-mit-der-db-lausige-performance-die-zweite/11440/10 "2013-02-15T21:01:00Z")

</div>

Ok, bei der Mehrsprachigkeit wird das entsprechende SQL sehr komplex - wenn aber nur die deutsche Sprache verwendet wird, so dürfte dies nicht das Problem sein. Mein Tipp wäre, einen SQL-Profi auf den Server schauen zu lassen - oft kann man durch Anpassungen der MySQL-Konfiguration oder im Aufbau der SQL-Befehle noch etwas retten. Viel Erfolg! EDIT: Ich lese gerade, dass Sie die Filter gar nicht nutzen wollen? In diesem Fall könnten Sie die den GET-Parameter „sFilterProperties“ testweise in der shopware.php auf NULL setzen - vielleicht löst sich das Problem dadurch schon.