''american health papaya'' We found 3 items!

Memory usage: real: 12582912, emalloc: 9708760

Executed 100 queries in 0.72501802444458 seconds
Average query length: 0.0072501802444458 seconds
Queries per second: 137.92760542279
Longest query length: 0.17851209640503
Longest query: 
SELECT `serving_type_idx`.`value`, COUNT(serving_type_idx.entity_id) AS `count` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalogsearch_result` AS `search_result` ON search_result.product_id=e.entity_id AND search_result.query_id='30988'
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id='180' AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_eav` AS `serving_type_idx` ON serving_type_idx.entity_id = e.entity_id AND serving_type_idx.attribute_id = '159' AND serving_type_idx.store_id = '1' GROUP BY `serving_type_idx`.`value`