SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE gd_env ref PRIMARY PRIMARY 62 const 1 100.00% Using where

Original SQL Statement

select 
  name, 
  value 
from 
  gd_env 
where 
  category = "ncash"

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`gd_env`.`name` AS `name`, 
  `pravs`.`gd_env`.`value` AS `value` 
from 
  `pravs`.`gd_env` 
where 
  (
    `pravs`.`gd_env`.`category` = 'ncash'
  )