query.sql

# Time: 111113 19:34:31

# Query_time: 135.645604  Lock_time: 0.000054 Rows_sent: 2353  Rows_examined: 71471585
SET timestamp=1321209271;
SELECT DISTINCT `id_product`
								FROM `ps_search_word` sw
								LEFT JOIN `ps_search_index` si ON sw.`id_word` = si.`id_word`
								WHERE sw.`id_lang` = 2
								AND sw.`word` LIKE 'co%';