SQL Analyzer


Explain Extended

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

Original SQL Statement

select 
  * 
from 
  gd_category 
where 
  category in (
    left('', 3), 
    left('', 6), 
    left('', 9), 
    ''
  ) 
order by 
  category

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`gd_category`.`sno` AS `sno`, 
  `pravs`.`gd_category`.`catnm` AS `catnm`, 
  `pravs`.`gd_category`.`category` AS `category`, 
  `pravs`.`gd_category`.`sort` AS `sort`, 
  `pravs`.`gd_category`.`hidden` AS `hidden`, 
  `pravs`.`gd_category`.`level` AS `level`, 
  `pravs`.`gd_category`.`om_category` AS `om_category`, 
  `pravs`.`gd_category`.`useimg` AS `useimg`, 
  `pravs`.`gd_category`.`openmarket` AS `openmarket`, 
  `pravs`.`gd_category`.`hidden_mobile` AS `hidden_mobile`, 
  `pravs`.`gd_category`.`level_auth` AS `level_auth`, 
  `pravs`.`gd_category`.`auth_step` AS `auth_step`, 
  `pravs`.`gd_category`.`themeno` AS `themeno`, 
  `pravs`.`gd_category`.`sort_type` AS `sort_type`, 
  `pravs`.`gd_category`.`sort_max` AS `sort_max`, 
  `pravs`.`gd_category`.`manual_sort_on_link_goods_position` AS `manual_sort_on_link_goods_position` 
from 
  `pravs`.`gd_category` 
where 
  (
    `pravs`.`gd_category`.`category` in (
      left('', 3), 
      left('', 6), 
      left('', 9), 
      ''
    )
  ) 
order by 
  `pravs`.`gd_category`.`category`