oscommerce and sql

[simonetta_]

I don't know why , but the script send 500 query/second to sql and stopped sql . A little part of the log is this:

/usr/libexec/mysqld, Version: 3.23.56-log, started with:

Time Id Command Argument

xcfgKey, configuration_value as cfgValue from configuration

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

1 Query delete from whos_online where time_last_click < '1059588975'

1 Query select count(*) as count from whos_online where session_id = '0bbbc8a9645733a85970fa2546b2b344'

1 Query update whos_online set customer_id = '', full_name = 'Guest', ip_address = '62.101.125.65', time_last_click = '1059589875', last_page_url = '/negozio/catalog/product_reviews.php?cPath=23_208&products_id=225' where session_id = '0bbbc8a9645733a85970fa2546b2b344'

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

1 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

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

1 Query select categories_name from categories_description where categories_id = '23' and language_id='1'

1 Query select categories_name from categories_description where categories_id = '208' and language_id='1'

1 Query select products_model from products where products_id = '225'

1 Query select pd.products_name from products_description pd left join products p on pd.products_id = p.products_id where pd.language_id = '1' and p.products_status = '1' and pd.products_id = '225'

 

can you help me? thank