SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE CMGL0 ref idx_goodsno idx_goodsno 4 const 4 100.00%

Original SQL Statement

SELECT 
  CMGL0.* 
FROM 
  gd_goods_link AS CMGL0 
WHERE 
  (CMGL0.goodsno = '6444447')

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`CMGL0`.`sno` AS `sno`, 
  `pravs`.`CMGL0`.`goodsno` AS `goodsno`, 
  `pravs`.`CMGL0`.`category` AS `category`, 
  `pravs`.`CMGL0`.`sort` AS `sort`, 
  `pravs`.`CMGL0`.`sort1` AS `sort1`, 
  `pravs`.`CMGL0`.`sort2` AS `sort2`, 
  `pravs`.`CMGL0`.`sort3` AS `sort3`, 
  `pravs`.`CMGL0`.`sort4` AS `sort4`, 
  `pravs`.`CMGL0`.`hidden` AS `hidden`, 
  `pravs`.`CMGL0`.`hidden_mobile` AS `hidden_mobile` 
from 
  `pravs`.`gd_goods_link` `CMGL0` 
where 
  (
    `pravs`.`CMGL0`.`goodsno` = '6444447'
  )