SQL Analyzer


Explain Extended

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

Original SQL Statement

SELECT 
  CMGG0.* 
FROM 
  gd_goods AS CMGG0 
WHERE 
  (`CMGG0`.`goodsno` = '6444447')

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  '6444447' AS `goodsno`, 
  '[????????] ????? ??????? ???&????????? 20g' AS `goodsnm`, 
  '' AS `meta_title`, 
  'P20137' AS `goodscd`, 
  '' AS `origin`, 
  '' AS `maker`, 
  '24627' AS `brandno`, 
  '1' AS `tax`, 
  '6' AS `delivery_type`, 
  '?????,???P??,?????,??????,?????????,???????,?????????,?????????' AS `keyword`, 
  NULL AS `strprice`, 
  '' AS `shortdesc`, 
  '


' AS `longdesc`, '' AS `mlongdesc`, 'http://i.lately.co.kr/2/2101/04/A151100537519_700_700.jpg' AS `img_i`, 'http://i.lately.co.kr/4/2101/04/A151100537519_700_700.jpg' AS `img_s`, 'http://i.lately.co.kr/6/2101/04/A151100537519_700_700.jpg' AS `img_m`, 'http://i.lately.co.kr/8/2101/04/A151100537519_700_700.jpg' AS `img_l`, '' AS `img_mobile`, '0' AS `use_mobile_img`, '' AS `img_w`, '' AS `img_x`, '' AS `img_y`, '' AS `img_z`, 'img_i' AS `img_pc_w`, 'img_s' AS `img_pc_x`, 'img_m' AS `img_pc_y`, 'img_l' AS `img_pc_z`, '' AS `memo`, '2021-01-04 15:11:47' AS `regdt`, '' AS `icon`, '0' AS `open`, '1' AS `runout`, '????? ??????? ???&????????? 20g' AS `optnm`, 'single' AS `opttype`, 'img' AS `opt1kind`, 'img' AS `opt2kind`, NULL AS `addoptnm`, NULL AS `ex_title`, NULL AS `ex1`, NULL AS `ex2`, NULL AS `ex3`, NULL AS `ex4`, NULL AS `ex5`, NULL AS `ex6`, '0' AS `relationis`, NULL AS `relation`, 'o' AS `usestock`, '0' AS `totstock`, '' AS `useblog`, NULL AS `launchdt`, '' AS `inpk_dispno`, '' AS `inpk_prdno`, '0000-00-00 00:00:00' AS `inpk_regdt`, '0000-00-00 00:00:00' AS `inpk_moddt`, NULL AS `goods_delivery`, '0' AS `use_emoney`, '1' AS `min_ea`, '0' AS `max_ea`, '2021-10-22 17:17:27' AS `updatedt`, '1' AS `open_mobile`, 'n' AS `detailView`, 'n' AS `todaygoods`, '0' AS `use_stocked_noti`, '' AS `extra_info`, '' AS `color`, NULL AS `model_name`, 'N' AS `goods_status`, '700' AS `goods_price`, '0' AS `goods_supply`, '800' AS `goods_consumer`, '0' AS `provider_price`, '1' AS `use_option`, '????? ??????? ???&????????? 20g' AS `option_name`, NULL AS `sales_unit`, '0' AS `use_goods_discount`, NULL AS `manufacture_date`, NULL AS `effective_date_start`, NULL AS `effective_date_end`, '0' AS `use_only_adult`, '0' AS `use_external_video`, NULL AS `external_video_url`, NULL AS `external_video_width`, '0' AS `external_video_size_type`, NULL AS `external_video_height`, NULL AS `exclude_member_discount`, NULL AS `exclude_member_reserve`, NULL AS `goods_reserve`, '' AS `option_value`, '???' AS `delivery_method`, NULL AS `delivery_area`, 'url' AS `image_attach_method`, NULL AS `trend_code`, '1' AS `buyable`, NULL AS `buyable_member_group`, '0' AS `sales_range_start`, '0' AS `sales_range_end`, 'n' AS `speach_description_useyn`, NULL AS `speach_description`, NULL AS `naver_event`, NULL AS `naver_import_flag`, NULL AS `naver_product_flag`, '0' AS `naver_age_group`, NULL AS `naver_gender`, NULL AS `naver_attribute`, NULL AS `naver_search_tag`, NULL AS `naver_category`, NULL AS `naver_product_id`, 'Y' AS `naver_shopping_yn`, 'N' AS `naver_shopping_chk`, NULL AS `naver_lprice`, '0' AS `seo_use`, NULL AS `seo_title`, NULL AS `seo_description`, NULL AS `seo_keywords`, NULL AS `seo_author`, '0' AS `use_facebook`, NULL AS `img_facebook`, 'file' AS `facebook_image_attatch_method`, 'N' AS `culture_benefit`, 'N' AS `daum_shopping_yn` from `pravs`.`gd_goods` `CMGG0` where ('6444447' = '6444447')