SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE gd_goods const PRIMARY PRIMARY 4 const 1 100.00%

Original SQL Statement

SELECT 
  seo_use, 
  seo_title, 
  seo_description, 
  seo_keywords, 
  seo_author 
FROM 
  gd_goods 
WHERE 
  goodsno = '6444447'

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  '0' AS `seo_use`, 
  NULL AS `seo_title`, 
  NULL AS `seo_description`, 
  NULL AS `seo_keywords`, 
  NULL AS `seo_author` 
from 
  `pravs`.`gd_goods` 
where 
  ('6444447' = '6444447')