SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE gd_common_info index PRIMARY 4 1 100.00% Using where

Original SQL Statement

select 
  * 
from 
  gd_common_info 
where 
  open 
order by 
  idx

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`gd_common_info`.`idx` AS `idx`, 
  `pravs`.`gd_common_info`.`title` AS `title`, 
  `pravs`.`gd_common_info`.`info` AS `info`, 
  `pravs`.`gd_common_info`.`open` AS `open`, 
  `pravs`.`gd_common_info`.`reg_date` AS `reg_date` 
from 
  `pravs`.`gd_common_info` 
where 
  `pravs`.`gd_common_info`.`open` 
order by 
  `pravs`.`gd_common_info`.`idx`