[TYPO3-performance] Problem with Database queries

[Björn Pedersen]

Am 26.04.2011 13:18, schrieb Volker Lieder:
> 2612970	kunde	www01.kunde.de:33624	customersdb	Query	239	Sending data	SELECT COUNT(*) AS anzahl\nFROM   (SELECT  COUNT(*),\n                v.`user_id`\n       FROM     view_customer_products_details6 v\n       WHERE    (v.`licenses`         LIKE '%0023 0000%'\n                )\n       AND      v.`user_id` IN\n                (SELECT v.`user_id`\n                FROM    view_customer_products_details6 v\n                WHERE   `licenses` LIKE '%000A 0004%'\n                )\n       GROUP BY v.`user_id`\n       )\n       t1

This one looks strange (and is not a typo3 query):
2612970	kunde	www01.kunde.de:33624	customersdb	Query	239	Sending data
SELECT COUNT(*) AS anzahl\nFROM   (SELECT  COUNT(*),\n
v.`user_id`\n       FROM     view_customer_products_details6 v\n
WHERE    (v.`licenses`         LIKE '%0023 0000%'\n                )\n
     AND      v.`user_id` IN\n                (SELECT v.`user_id`\n
           FROM    view_customer_products_details6 v\n
WHERE   `licenses` LIKE '%000A 0004%'\n                )\n       GROUP
BY v.`user_id`\n       )\n       t1

Does the slow-query log tell you anything?