SHOW FULL COLUMNS FROM `company` [ RunTime:0.003421s ]
SELECT `company_id`,`status` FROM `company` WHERE `sdomain` = 'shop' LIMIT 1 [ RunTime:0.001404s ]
SHOW FULL COLUMNS FROM `config_lang` [ RunTime:0.002526s ]
SELECT `name`,`is_default` FROM `config_lang` WHERE `store_id` = 2 ORDER BY `id` ASC [ RunTime:0.001454s ]
SHOW FULL COLUMNS FROM `setup_en` [ RunTime:0.002506s ]
SELECT * FROM `setup_en` WHERE ( store_id = 2 ) LIMIT 1 [ RunTime:0.001080s ]
SHOW FULL COLUMNS FROM `category_en` [ RunTime:0.002446s ]
SELECT * FROM `category_en` WHERE `status` = 1 AND `store_id` = 2 ORDER BY `sort` [ RunTime:0.001172s ]
SELECT * FROM `category_en` WHERE `status` = 1 AND `store_id` = 2 AND ( parent_id = 0 ) ORDER BY `sort` LIMIT 4 [ RunTime:0.001170s ]
SELECT * FROM `company` WHERE `company_id` = 2 LIMIT 1 [ RunTime:0.001118s ]
SHOW FULL COLUMNS FROM `title_en` [ RunTime:0.002435s ]
SELECT * FROM `title_en` WHERE `web_url` LIKE '%/product/47.html%' AND `store_id` = 2 LIMIT 1 [ RunTime:0.001122s ]
SELECT * FROM `title_en` WHERE `web_url` = '/' AND `store_id` = 2 LIMIT 1 [ RunTime:0.001124s ]
SELECT * FROM `config_lang` WHERE `store_id` = 2 ORDER BY `is_default` DESC [ RunTime:0.001321s ]
SHOW FULL COLUMNS FROM `goods_en` [ RunTime:0.002667s ]
SELECT * FROM `goods_en` WHERE `status` = 10 AND `store_id` = 2 AND ( goods_id = '47' ) LIMIT 1 [ RunTime:0.001295s ]
SHOW FULL COLUMNS FROM `goods_category_rel_en` [ RunTime:0.002634s ]
SELECT * FROM `goods_category_rel_en` WHERE ( goods_id = 47 ) LIMIT 1 [ RunTime:0.001105s ]
SELECT `name` FROM `category_en` WHERE `status` = 1 AND `store_id` = 2 AND ( category_id = 17 ) LIMIT 1 [ RunTime:0.001155s ]
SELECT `goods_id`,`goods_image`,`goods_name`,`goods_price_min`,`line_price_min`,`urlstr` FROM `goods_en` WHERE `status` = 10 AND `store_id` = 2 AND `recom` = 10 ORDER BY `sort`,`goods_id` DESC LIMIT 5 [ RunTime:0.001431s ]
SHOW FULL COLUMNS FROM `spec_en` [ RunTime:0.002709s ]
SHOW FULL COLUMNS FROM `goods_spec_rel_en` [ RunTime:0.002549s ]
SELECT DISTINCT `spec_id` FROM `goods_spec_rel_en` WHERE `goods_id` = 47 [ RunTime:0.001251s ]
SELECT * FROM `spec_en` WHERE ( spec_id = 102 ) LIMIT 1 [ RunTime:0.001088s ]
SELECT DISTINCT `spec_value_id` FROM `goods_spec_rel_en` WHERE `goods_id` = 47 [ RunTime:0.001191s ]
SHOW FULL COLUMNS FROM `spec_value_en` [ RunTime:0.002514s ]
SELECT * FROM `spec_value_en` WHERE ( spec_value_id = 183 ) LIMIT 1 [ RunTime:0.001047s ]
SELECT * FROM `spec_value_en` WHERE ( spec_value_id = 184 ) LIMIT 1 [ RunTime:0.001038s ]
SELECT * FROM `goods_spec_rel_en` WHERE `goods_id` = 47 AND ( spec_id = 102 ) [ RunTime:0.001223s ]
SELECT `spec_value` FROM `spec_value_en` WHERE ( spec_value_id = 183 ) LIMIT 1 [ RunTime:0.001042s ]
SELECT `spec_value` FROM `spec_value_en` WHERE ( spec_value_id = 184 ) LIMIT 1 [ RunTime:0.001091s ]
SHOW FULL COLUMNS FROM `goods_sku_en` [ RunTime:0.002607s ]
SELECT * FROM `goods_sku_en` WHERE ( goods_id = 47 ) [ RunTime:0.001287s ]