Ist Das Absicht Oder Programmierfehler ?

[smogware]

F?r seit mehreren Tagen eine Diskussion mit meinem Provider warum der Seitenaufbau von dem Shop so langsam geht. Nach dem wir mal die ganzen Dateien angeschaut haben was zum Start des Shops n?tig sind h?tte man schon einiges weglassen k?nnen. Dann kamen die Log Dateien mal an die Reihe zum erstaunen macht er etwa um die 400 Querysanfragen an die Datenbank. UNd das ist nicht schlecht. als Beweis werde ich mal das Log mit Posten.

041214 17:25:40 72 Connect marth320@localhost on

72 Init DB ddevildb

72 Query select configuration_key as cfgKey, configuration_value as cfgValue from configuration

72 Query select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies

72 Query select languages_id, name, code, image, directory,language_charset from languages order by sort_order

72 Query SELECT

customers_status_name,

customers_status_discount,

customers_status_public,

customers_status_image,

customers_status_ot_discount_flag,

customers_status_ot_discount,

customers_status_graduated_prices,

customers_status_show_price,

customers_status_show_price_tax,

customers_status_add_tax_ot,

customers_status_payment_unallowed,

customers_status_shipping_unallowed,

customers_status_discount_attributes,

customers_fsk18,

customers_fsk18_display

FROM

customers_status

WHERE

customers_status_id = '1' AND language_id = '2'

72 Query delete from whos_online where time_last_click < '1103044240'

72 Query select count(*) as count from whos_online where session_id = 'f6dedd95f662f30e4d2b660644a6b43a'

72 Query insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('', 'Guest', 'f6dedd95f662f30e4d2b660644a6b43a', '195.254.225.136', '1103045140', '1103045140', '/')

72 Query select banners_id, date_scheduled from banners where date_scheduled != ''

72 Query select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id

72 Query select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0

72 Query select c.categories_id,

cd.categories_name,

c.parent_id from categories c, categories_description cd

where c.categories_status = '1'

and c.parent_id = '0'

and c.categories_id = cd.categories_id

and cd.language_id='2'

order by sort_order, cd.categories_name

72 Query select count(*) as count from categories where parent_id = '232'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '232'

72 Query select categories_id from categories where parent_id = '232'

72 Query select count(*) as count from categories where parent_id = '231'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '231'

72 Query select categories_id from categories where parent_id = '231'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '136'

72 Query select categories_id from categories where parent_id = '136'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '193'

72 Query select categories_id from categories where parent_id = '193'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '203'

72 Query select categories_id from categories where parent_id = '203'

72 Query select count(*) as count from categories where parent_id = '216'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '216'

72 Query select categories_id from categories where parent_id = '216'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'

72 Query select categories_id from categories where parent_id = '24'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'

72 Query select categories_id from categories where parent_id = '25'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'

72 Query select categories_id from categories where parent_id = '26'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'

72 Query select categories_id from categories where parent_id = '27'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'

72 Query select categories_id from categories where parent_id = '28'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'

72 Query select categories_id from categories where parent_id = '29'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'

72 Query select categories_id from categories where parent_id = '30'

72 Query select count(*) as count from categories where parent_id = '224'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '224'

72 Query select categories_id from categories where parent_id = '224'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'

72 Query select categories_id from categories where parent_id = '57'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91'

72 Query select categories_id from categories where parent_id = '91'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '155'

72 Query select categories_id from categories where parent_id = '155'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '156'

72 Query select categories_id from categories where parent_id = '156'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '165'

72 Query select categories_id from categories where parent_id = '165'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '166'

72 Query select categories_id from categories where parent_id = '166'

72 Query select count(*) as count from categories where parent_id = '210'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '210'

72 Query select categories_id from categories where parent_id = '210'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '9'

72 Query select categories_id from categories where parent_id = '9'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '10'

72 Query select categories_id from categories where parent_id = '10'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '11'

72 Query select categories_id from categories where parent_id = '11'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '12'

72 Query select categories_id from categories where parent_id = '12'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'

72 Query select categories_id from categories where parent_id = '34'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '87'

72 Query select categories_id from categories where parent_id = '87'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '88'

72 Query select categories_id from categories where parent_id = '88'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '89'

72 Query select categories_id from categories where parent_id = '89'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '90'

72 Query select categories_id from categories where parent_id = '90'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '160'

72 Query select categories_id from categories where parent_id = '160'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '171'

72 Query select categories_id from categories where parent_id = '171'

72 Query select count(*) as count from categories where parent_id = '220'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '220'

72 Query select categories_id from categories where parent_id = '220'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'

72 Query select categories_id from categories where parent_id = '41'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'

72 Query select categories_id from categories where parent_id = '51'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'

72 Query select categories_id from categories where parent_id = '52'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66'

72 Query select categories_id from categories where parent_id = '66'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'

72 Query select categories_id from categories where parent_id = '72'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '103'

72 Query select categories_id from categories where parent_id = '103'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '108'

72 Query select categories_id from categories where parent_id = '108'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134'

72 Query select categories_id from categories where parent_id = '134'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '158'

72 Query select categories_id from categories where parent_id = '158'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '163'

72 Query select categories_id from categories where parent_id = '163'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '182'

72 Query select categories_id from categories where parent_id = '182'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '204'

72 Query select categories_id from categories where parent_id = '204'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '206'

72 Query select categories_id from categories where parent_id = '206'

72 Query select count(*) as count from categories where parent_id = '222'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '222'

72 Query select categories_id from categories where parent_id = '222'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'

72 Query select categories_id from categories where parent_id = '53'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'

72 Query select categories_id from categories where parent_id = '54'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55'

72 Query select categories_id from categories where parent_id = '55'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56'

72 Query select categories_id from categories where parent_id = '56'

72 Query select count(*) as count from categories where parent_id = '226'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '226'

72 Query select categories_id from categories where parent_id = '226'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83'

72 Query select categories_id from categories where parent_id = '83'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '92'

72 Query select categories_id from categories where parent_id = '92'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '109'

72 Query select categories_id from categories where parent_id = '109'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133'

72 Query select categories_id from categories where parent_id = '133'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '177'

72 Query select categories_id from categories where parent_id = '177'

72 Query select count(*) as count from categories where parent_id = '223'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '223'

72 Query select categories_id from categories where parent_id = '223'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '1'

72 Query select categories_id from categories where parent_id = '1'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '2'

72 Query select categories_id from categories where parent_id = '2'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'

72 Query select categories_id from categories where parent_id = '58'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'

72 Query select categories_id from categories where parent_id = '59'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'

72 Query select categories_id from categories where parent_id = '61'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'

72 Query select categories_id from categories where parent_id = '64'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67'

72 Query select categories_id from categories where parent_id = '67'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68'

72 Query select categories_id from categories where parent_id = '68'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '69'

72 Query select categories_id from categories where parent_id = '69'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '107'

72 Query select categories_id from categories where parent_id = '107'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '168'

72 Query select categories_id from categories where parent_id = '168'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '207'

72 Query select categories_id from categories where parent_id = '207'

72 Query select count(*) as count from categories where parent_id = '218'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '218'

72 Query select categories_id from categories where parent_id = '218'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '17'

72 Query select categories_id from categories where parent_id = '17'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'

72 Query select categories_id from categories where parent_id = '35'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'

72 Query select categories_id from categories where parent_id = '60'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '74'

72 Query select categories_id from categories where parent_id = '74'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75'

72 Query select categories_id from categories where parent_id = '75'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76'

72 Query select categories_id from categories where parent_id = '76'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77'

72 Query select categories_id from categories where parent_id = '77'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78'

72 Query select categories_id from categories where parent_id = '78'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79'

72 Query select categories_id from categories where parent_id = '79'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80'

72 Query select categories_id from categories where parent_id = '80'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137'

72 Query select categories_id from categories where parent_id = '137'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '185'

72 Query select categories_id from categories where parent_id = '185'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '188'

72 Query select categories_id from categories where parent_id = '188'

72 Query select count(*) as count from categories where parent_id = '209'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '209'

72 Query select categories_id from categories where parent_id = '209'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '4'

72 Query select categories_id from categories where parent_id = '4'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '5'

72 Query select categories_id from categories where parent_id = '5'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '6'

72 Query select categories_id from categories where parent_id = '6'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '7'

72 Query select categories_id from categories where parent_id = '7'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8'

72 Query select categories_id from categories where parent_id = '8'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82'

72 Query select categories_id from categories where parent_id = '82'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '152'

72 Query select categories_id from categories where parent_id = '152'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '153'

72 Query select categories_id from categories where parent_id = '153'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '154'

72 Query select categories_id from categories where parent_id = '154'

72 Query select count(*) as count from categories where parent_id = '225'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '225'

72 Query select categories_id from categories where parent_id = '225'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'

72 Query select categories_id from categories where parent_id = '71'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '186'

72 Query select categories_id from categories where parent_id = '186'

72 Query select count(*) as count from categories where parent_id = '208'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '208'

72 Query select categories_id from categories where parent_id = '208'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '3'

72 Query select categories_id from categories where parent_id = '3'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '13'

72 Query select categories_id from categories where parent_id = '13'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'

72 Query select categories_id from categories where parent_id = '31'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'

72 Query select categories_id from categories where parent_id = '33'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47'

72 Query select categories_id from categories where parent_id = '47'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'

72 Query select categories_id from categories where parent_id = '73'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '110'

72 Query select categories_id from categories where parent_id = '110'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139'

72 Query select categories_id from categories where parent_id = '139'

72 Query select count(*) as count from categories where parent_id = '227'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '227'

72 Query select categories_id from categories where parent_id = '227'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '95'

72 Query select categories_id from categories where parent_id = '95'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '106'

72 Query select categories_id from categories where parent_id = '106'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '189'

72 Query select categories_id from categories where parent_id = '189'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '190'

72 Query select categories_id from categories where parent_id = '190'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '191'

72 Query select categories_id from categories where parent_id = '191'

72 Query select count(*) as count from categories where parent_id = '217'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '217'

72 Query select categories_id from categories where parent_id = '217'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '16'

72 Query select categories_id from categories where parent_id = '16'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '192'

72 Query select categories_id from categories where parent_id = '192'

72 Query select count(*) as count from categories where parent_id = '228'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '228'

72 Query select categories_id from categories where parent_id = '228'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '111'

72 Query select categories_id from categories where parent_id = '111'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '112'

72 Query select categories_id from categories where parent_id = '112'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '113'

72 Query select categories_id from categories where parent_id = '113'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '114'

72 Query select categories_id from categories where parent_id = '114'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115'

72 Query select categories_id from categories where parent_id = '115'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '116'

72 Query select categories_id from categories where parent_id = '116'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117'

72 Query select categories_id from categories where parent_id = '117'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118'

72 Query select categories_id from categories where parent_id = '118'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119'

72 Query select categories_id from categories where parent_id = '119'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120'

72 Query select categories_id from categories where parent_id = '120'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121'

72 Query select categories_id from categories where parent_id = '121'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122'

72 Query select categories_id from categories where parent_id = '122'

72 Query select count(*) as count from categories where parent_id = '229'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '229'

72 Query select categories_id from categories where parent_id = '229'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '127'

72 Query select categories_id from categories where parent_id = '127'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128'

72 Query select categories_id from categories where parent_id = '128'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129'

72 Query select categories_id from categories where parent_id = '129'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130'

72 Query select categories_id from categories where parent_id = '130'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131'

72 Query select categories_id from categories where parent_id = '131'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132'

72 Query select categories_id from categories where parent_id = '132'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '157'

72 Query select categories_id from categories where parent_id = '157'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '178'

72 Query select categories_id from categories where parent_id = '178'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '179'

72 Query select categories_id from categories where parent_id = '179'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '180'

72 Query select categories_id from categories where parent_id = '180'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '181'

72 Query select categories_id from categories where parent_id = '181'

72 Query select count(*) as count from categories where parent_id = '214'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '214'

72 Query select categories_id from categories where parent_id = '214'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '18'

72 Query select categories_id from categories where parent_id = '18'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'

72 Query select categories_id from categories where parent_id = '70'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86'

72 Query select categories_id from categories where parent_id = '86'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '97'

72 Query select categories_id from categories where parent_id = '97'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '98'

72 Query select categories_id from categories where parent_id = '98'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '99'

72 Query select categories_id from categories where parent_id = '99'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '100'

72 Query select categories_id from categories where parent_id = '100'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '101'

72 Query select categories_id from categories where parent_id = '101'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '102'

72 Query select categories_id from categories where parent_id = '102'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125'

72 Query select categories_id from categories where parent_id = '125'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126'

72 Query select categories_id from categories where parent_id = '126'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138'

72 Query select categories_id from categories where parent_id = '138'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '162'

72 Query select categories_id from categories where parent_id = '162'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '176'

72 Query select categories_id from categories where parent_id = '176'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '184'

72 Query select categories_id from categories where parent_id = '184'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '194'

72 Query select categories_id from categories where parent_id = '194'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '195'

72 Query select categories_id from categories where parent_id = '195'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '196'

72 Query select categories_id from categories where parent_id = '196'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '197'

72 Query select categories_id from categories where parent_id = '197'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '198'

72 Query select categories_id from categories where parent_id = '198'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '199'

72 Query select categories_id from categories where parent_id = '199'

72 Query select count(*) as count from categories where parent_id = '211'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '211'

72 Query select categories_id from categories where parent_id = '211'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '14'

72 Query select categories_id from categories where parent_id = '14'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19'

72 Query select categories_id from categories where parent_id = '19'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'

72 Query select categories_id from categories where parent_id = '46'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'

72 Query select categories_id from categories where parent_id = '50'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140'

72 Query select categories_id from categories where parent_id = '140'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141'

72 Query select categories_id from categories where parent_id = '141'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142'

72 Query select categories_id from categories where parent_id = '142'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143'

72 Query select categories_id from categories where parent_id = '143'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144'

72 Query select categories_id from categories where parent_id = '144'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145'

72 Query select categories_id from categories where parent_id = '145'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '146'

72 Query select categories_id from categories where parent_id = '146'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '147'

72 Query select categories_id from categories where parent_id = '147'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '148'

72 Query select categories_id from categories where parent_id = '148'

72 Query select count(*) as count from categories where parent_id = '212'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '212'

72 Query select categories_id from categories where parent_id = '212'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '15'

72 Query select categories_id from categories where parent_id = '15'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20'

72 Query select categories_id from categories where parent_id = '20'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '94'

72 Query select categories_id from categories where parent_id = '94'

72 Query select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products

[Hubi]

Das ist doch wohl klar. Wie bitte sonst soll der Shop die Artielanzahl der einzelnen Kategorien rausbekommen?!? Kristallkugel?

[smogware]

aber soviele anfragen auf einmal. das geht doch sicher auch kleiner oder.

[Guest HHGAG]

Artikelcount ausschalten =)

[Hubi]

Oder Deine Kategorietiefe, bzw. Kategorieanzahl reduzieren.

[khan_thep]

kleiner Scherz: oder gar keine Artikel anbieten

[smogware]

noch kleiner geht nicht. ausser ich biete keine artikel an. dann ist es klein genug. aber was kann man machen damit der aufbau noch schneller geht.????????

[Guest HHGAG]

Vern?nftigen Hoster =)

s. Signatur ^^

[smogware]

ja du willst nur das ich zu dir komme und deine server nutze. hhag. das mu? aber auch ohne ein wechsel gehen. andere shops laufen ja auch schneller. mindfactory oder sowas. oder die ebayshops. und da ist mehr datenaufkommen als bei mir.

[mzanier]

also wenn ein provider schon bei einer geringen produktmenge probleme hat dann sollte man den wohl wechseln.

au?er man stellt den server mal vern?nftig ein, was du bei einem hoster jedoch kaum machen kannst.

[smogware]

dann k?nnte man doch mal die perfekten einstellungen f?r den shop posten.

[Guest HHGAG]

Damit jeder zweite herkommen und Hoster/Provider spielen kann =)

[zaxwop]

Moin!

Ich habe auf meinem Server turck-mmcache 2.4.6 laufen, einen php-beschleuniger, der sogar etwas schneller als die zend performance suite 3.5.0 ist.

damit werden php-scripte gecacht. bringt unheimliche geschwindigkeitssteigerungen ;-)

turck-mmcache-2.4.6