过载的悲剧同样发生在我身上！大家帮我看看怎么回事

xingzhaoyang

过载的悲剧同样发生在我身上！！！！
大家帮我看看怎么回事， 我用的zencart模板，查询怎么会有问题呢？不理解！！！！1

Details given:
We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server's load to increase degrading the performance for all other customers on this server.

To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.

Failure to respond to this message within 72 hours will result in the suspension of the affected domain with us until such a time as this matter is resolved.

Most common queries for C327674_*:

1.Time: 29% (4270 sec)
Amount: 31% (568 queries)
Rows Examined/Sent: 79273827 / 26396724
Avg. Query Exec/Lock Time: 7 / 0 sec.
Used databases: [C327674_****abe|C327674_****annie]
Query example: use C327674_****abe; select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p.products_date_added, p.products_price, p.products_type, p.master_categories_id from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1;

2.Time: 6% (1014 sec)
Amount: 6% (111 queries)
Rows Examined/Sent: 8629418 / 118
Avg. Query Exec/Lock Time: 9 / 3 sec.
Used databases: [C327674_****abe]
Query example: use C327674_****abe; SELECT products_id FROM products_description where ****_id ='1329937886';

微微百科

数据库负载过重

xingzhaoyang

数据库怎么会过载啊？我也没有做什么操作啊，并且他们的工作我本地总是打不开！

微微百科

可能是你的数据库调用或查询太过频繁了吧

xingzhaoyang

让我优化所有的sql语句，晕死了！