SQL Analyzer


Explain Extended

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

Original SQL Statement

SELECT 
  CMCC0.* 
FROM 
  gd_category AS CMCC0 
WHERE 
  (`CMCC0`.`category` = '062002001')

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`CMCC0`.`sno` AS `sno`, 
  `pravs`.`CMCC0`.`catnm` AS `catnm`, 
  `pravs`.`CMCC0`.`category` AS `category`, 
  `pravs`.`CMCC0`.`sort` AS `sort`, 
  `pravs`.`CMCC0`.`hidden` AS `hidden`, 
  `pravs`.`CMCC0`.`level` AS `level`, 
  `pravs`.`CMCC0`.`om_category` AS `om_category`, 
  `pravs`.`CMCC0`.`useimg` AS `useimg`, 
  `pravs`.`CMCC0`.`openmarket` AS `openmarket`, 
  `pravs`.`CMCC0`.`hidden_mobile` AS `hidden_mobile`, 
  `pravs`.`CMCC0`.`level_auth` AS `level_auth`, 
  `pravs`.`CMCC0`.`auth_step` AS `auth_step`, 
  `pravs`.`CMCC0`.`themeno` AS `themeno`, 
  `pravs`.`CMCC0`.`sort_type` AS `sort_type`, 
  `pravs`.`CMCC0`.`sort_max` AS `sort_max`, 
  `pravs`.`CMCC0`.`manual_sort_on_link_goods_position` AS `manual_sort_on_link_goods_position` 
from 
  `pravs`.`gd_category` `CMCC0` 
where 
  (
    `pravs`.`CMCC0`.`category` = '062002001'
  )