SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE gd_webfont ALL 1 100.00% Using where

Original SQL Statement

select 
  font_code, 
  `use` 
from 
  gd_webfont 
where 
  now() between expire_start 
  and expire_end 
  and LENGTH(`use`)

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`gd_webfont`.`font_code` AS `font_code`, 
  `pravs`.`gd_webfont`.`use` AS `use` 
from 
  `pravs`.`gd_webfont` 
where 
  (
    (
      < cache >(now()) between `pravs`.`gd_webfont`.`expire_start` 
      and `pravs`.`gd_webfont`.`expire_end`
    ) 
    and length(`pravs`.`gd_webfont`.`use`)
  )