SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE gd_goods_review ref idx idx 4 const 1 100.00% Using index

Original SQL Statement

select 
  count(*) as cnt 
from 
  gd_goods_review 
where 
  goodsno = '6444447'

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  count(0) AS `cnt` 
from 
  `pravs`.`gd_goods_review` 
where 
  (
    `pravs`.`gd_goods_review`.`goodsno` = '6444447'
  )