Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Big MySQL Problem
 
Daim
Sr. Member
 
Total Posts:  172
Joined:  2008-01-08
Germany
 

Yes i annoy the developer. Sorry but when i surf in the catalog und set a filter then i become this super mega sql. This is a Performancekiller


SELECT COUNT(DISTINCT e.entity_id) AS `count_in_category` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product` AS `_table_position` ON (_table_position.product_id=e.entity_id) AND (_table_position.category_id IN (’3’, ‘85’, ‘84’, ‘83’, ‘82’, ‘81’, ‘80’, ‘79’, ‘97’, ‘96’, ‘95’, ‘94’, ‘98’, ‘99’, ‘93’, ‘92’, ‘91’, ‘90’, ‘89’, ‘88’, ‘87’, ‘86’, ‘78’, ‘19’, ‘20’, ‘21’, ‘22’, ‘18’, ‘17’, ‘16’, ‘15’, ‘14’, ‘13’, ‘12’, ‘11’, ‘10’, ‘9’, ‘8’, ‘7’, ‘6’, ‘5’, ‘4’, ‘58’, ‘57’, ‘56’, ‘55’, ‘54’, ‘53’, ‘52’, ‘51’, ‘50’, ‘49’, ‘48’, ‘60’, ‘59’, ‘61’, ‘47’, ‘77’, ‘76’, ‘75’, ‘74’, ‘73’, ‘72’, ‘71’, ‘70’, ‘69’, ‘68’, ‘67’, ‘66’, ‘65’, ‘64’, ‘63’, ‘62’, ‘46’, ‘45’, ‘44’, ‘43’, ‘42’, ‘41’, ‘40’, ‘39’, ‘38’, ‘37’, ‘24’, ‘25’, ‘26’, ‘27’, ‘23’, ‘36’, ‘35’, ‘34’, ‘33’, ‘32’, ‘31’, ‘30’, ‘29’, ‘28’, ‘137’, ‘136’, ‘135’, ‘134’, ‘133’, ‘132’, ‘131’, ‘130’, ‘129’, ‘128’, ‘138’, ‘139’, ‘127’, ‘147’, ‘146’, ‘145’, ‘144’, ‘143’, ‘142’, ‘141’, ‘140’, ‘126’, ‘125’, ‘124’, ‘123’, ‘122’, ‘121’, ‘120’, ‘119’, ‘118’, ‘117’, ‘116’, ‘115’, ‘114’, ‘113’, ‘112’, ‘111’, ‘110’, ‘109’, ‘108’, ‘107’, ‘106’, ‘105’, ‘104’, ‘103’, ‘102’, ‘101’, ‘100’))
INNER JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id=’69’) AND (_table_status.store_id=0)
INNER JOIN `catalog_product_entity_int` AS `_table_visibility` ON (_table_visibility.entity_id = e.entity_id) AND (_table_visibility.attribute_id=’74’) AND (_table_visibility.store_id=0)
INNER JOIN `catalog_category_product` AS `category_count_table` ON category_count_table.product_id=e.entity_id WHERE (e.entity_type_id = ‘4’) AND (_table_status.value in (1)) AND (_table_visibility.value in (2, 4)) AND (((e.entity_id = ‘23191’) or (e.entity_id = ‘23202’) or (e.entity_id = ‘23221’) or (e.entity_id = ‘23234’) or (e.entity_id = ‘23238’) or (e.entity_id = ‘23278’) or (e.entity_id = ‘23279’) or (e.entity_id = ‘23280’) or (e.entity_id = ‘23281’) or (e.entity_id = ‘23282’) or (e.entity_id = ‘23283’) or (e.entity_id = ‘23284’) or (e.entity_id = ‘23296’) or (e.entity_id = ‘23301’) or (e.entity_id = ‘23306’) or (e.entity_id = ‘23308’) or (e.entity_id = ‘23314’) or (e.entity_id = ‘23373’) or (e.entity_id = ‘23379’) or (e.entity_id = ‘23380’) or (e.entity_id = ‘23381’) or (e.entity_id = ‘23382’) or (e.entity_id = ‘23383’) or (e.entity_id = ‘23384’) or (e.entity_id = ‘23387’) or (e.entity_id = ‘23388’) or (e.entity_id = ‘23389’) or (e.entity_id = ‘23500’) or (e.entity_id = ‘23501’) or (e.entity_id = ‘23512’) or (e.entity_id = ‘23513’) or (e.entity_id = ‘23514’) or (e.entity_id = ‘23524’) or (e.entity_id = ‘23525’) or (e.entity_id = ‘23565’) or (e.entity_id = ‘23566’) or (e.entity_id = ‘23567’) or (e.entity_id = ‘23572’) or (e.entity_id = ‘23573’) or (e.entity_id = ‘23574’) or (e.entity_id = ‘23575’) or (e.entity_id = ‘23576’) or (e.entity_id = ‘23577’) or (e.entity_id = ‘23736’) or (e.entity_id = ‘23737’) or (e.entity_id = ‘23738’) or (e.entity_id = ‘23739’) or (e.entity_id = ‘23740’) or (e.entity_id = ‘23741’) or (e.entity_id = ‘23742’) or (e.entity_id = ‘23743’) or (e.entity_id = ‘23744’) or (e.entity_id = ‘23745’) or (e.entity_id = ‘23746’) or (e.entity_id = ‘23747’) or (e.entity_id = ‘23748’) or (e.entity_id = ‘23749’) or (e.entity_id = ‘23762’) or (e.entity_id = ‘23921’) or (e.entity_id = ‘23922’) or (e.entity_id = ‘23929’) or (e.entity_id = ‘23930’) or (e.entity_id = ‘23947’) or (e.entity_id = ‘23948’) or (e.entity_id = ‘23949’) or (e.entity_id = ‘23950’) or (e.entity_id = ‘24006’) or (e.entity_id = ‘24007’) or (e.entity_id = ‘24008’) or (e.entity_id = ‘24009’) or (e.entity_id = ‘24081’) or (e.entity_id = ‘24091’) or (e.entity_id = ‘24092’) or (e.entity_id = ‘24093’) or (e.entity_id = ‘24094’) or (e.entity_id = ‘24136’) or (e.entity_id = ‘24137’) or (e.entity_id = ‘24141’) or (e.entity_id = ‘24181’) or (e.entity_id = ‘24182’) or (e.entity_id = ‘24183’) or (e.entity_id = ‘24184’) or (e.entity_id = ‘24185’) or (e.entity_id = ‘24186’) or (e.entity_id = ‘24275’) or (e.entity_id = ‘24276’) or (e.entity_id = ‘24277’) or (e.entity_id = ‘24278’) or (e.entity_id = ‘24279’) or (e.entity_id = ‘24280’) or (e.entity_id = ‘24281’) or (e.entity_id = ‘24282’) or (e.entity_id = ‘24283’) or (e.entity_id = ‘24284’) or (e.entity_id = ‘24285’) or (e.entity_id = ‘24286’) or (e.entity_id = ‘24287’) or (e.entity_id = ‘24288’) or (e.entity_id = ‘24581’) or (e.entity_id = ‘24582’) or (e.entity_id = ‘24608’) or (e.entity_id = ‘24609’) or (e.entity_id = ‘24610’) or (e.entity_id = ‘24611’) or (e.entity_id = ‘24612’) or (e.entity_id = ‘24613’) or (e.entity_id = ‘24614’) or (e.entity_id = ‘24615’) or (e.entity_id = ‘24616’) or (e.entity_id = ‘24617’) or (e.entity_id = ‘24618’) or (e.entity_id = ‘24619’) or (e.entity_id = ‘24620’) or (e.entity_id = ‘24621’) or (e.entity_id = ‘24622’) or (e.entity_id = ‘24623’) or (e.entity_id = ‘24624’) or ....
 
Magento Community Magento Community
Magento Community
Magento Community
 
jeanlucb
Member
 
Total Posts:  60
Joined:  2008-02-10
 

yayyyy ! This is ... wrong :S

i’m sure they’ll fix it when they’ll see that lol

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top