SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE gd_banner ref idx_tplSkin idx_tplSkin 62 const 34 100.00% Using index condition; Using where; Using filesort

Original SQL Statement

select 
  img, 
  linkaddr, 
  target 
from 
  gd_banner 
where 
  tplSkin = 'milanii' 
  and loccd = '3' 
order by 
  sort asc, 
  regdt desc

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`gd_banner`.`img` AS `img`, 
  `pravs`.`gd_banner`.`linkaddr` AS `linkaddr`, 
  `pravs`.`gd_banner`.`target` AS `target` 
from 
  `pravs`.`gd_banner` 
where 
  (
    (
      `pravs`.`gd_banner`.`loccd` = '3'
    ) 
    and (
      `pravs`.`gd_banner`.`tplSkin` = 'milanii'
    )
  ) 
order by 
  `pravs`.`gd_banner`.`sort`, 
  `pravs`.`gd_banner`.`regdt` desc