DARKF3D3 Posted February 2, 2011 Share Posted February 2, 2011 # Wed Feb 2 04:13:48 2011# Query_time: 7.121025 Lock_time: 1.865858 Rows_sent: 1 Rows_examined: 1use -----------------;SELECT * FROM `ps_product` a WHERE a.`id_product` = 31 LIMIT 1# Wed Feb 2 04:14:23 2011# Query_time: 4.588940 Lock_time: 0.849450 Rows_sent: 1 Rows_examined: 1use -----------------;SELECT p.`id_tax`, t.`rate` FROM `ps_product` p LEFT JOIN `ps_tax` AS t ON t.`id_tax` = p.`id_tax` WHERE p.`id_product` = 31 LIMIT 1# Wed Feb 2 04:57:22 2011# Query_time: 4.201742 Lock_time: 2.026375 Rows_sent: 0 Rows_examined: 1use -----------------;UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 143 AND `id_page` = 196How it is possible that these queries are so slow? There a way to speed up them?Thanks Link to comment Share on other sites More sharing options...
Recommended Posts