SHOW FULL COLUMNS FROM `company` [ RunTime:0.002929s ]
SELECT `company_id`,`status` FROM `company` WHERE `sdomain` = 'shop' LIMIT 1 [ RunTime:0.001277s ]
SHOW FULL COLUMNS FROM `config_lang` [ RunTime:0.002940s ]
SELECT `name`,`is_default` FROM `config_lang` WHERE `store_id` = 2 ORDER BY `id` ASC [ RunTime:0.001068s ]
SHOW FULL COLUMNS FROM `setup_en` [ RunTime:0.002524s ]
SELECT * FROM `setup_en` WHERE ( store_id = 2 ) LIMIT 1 [ RunTime:0.000916s ]
SHOW FULL COLUMNS FROM `category_en` [ RunTime:0.002616s ]
SELECT * FROM `category_en` WHERE `status` = 1 AND `store_id` = 2 ORDER BY `sort` [ RunTime:0.001008s ]
SELECT * FROM `category_en` WHERE `status` = 1 AND `store_id` = 2 AND ( parent_id = 0 ) ORDER BY `sort` LIMIT 4 [ RunTime:0.001111s ]
SELECT * FROM `company` WHERE `company_id` = 2 LIMIT 1 [ RunTime:0.001335s ]
SHOW FULL COLUMNS FROM `title_en` [ RunTime:0.002505s ]
SELECT * FROM `title_en` WHERE `web_url` LIKE '%/product/47.html%' AND `store_id` = 2 LIMIT 1 [ RunTime:0.000993s ]
SELECT * FROM `title_en` WHERE `web_url` = '/' AND `store_id` = 2 LIMIT 1 [ RunTime:0.001001s ]
SELECT * FROM `config_lang` WHERE `store_id` = 2 ORDER BY `is_default` DESC [ RunTime:0.001035s ]
SHOW FULL COLUMNS FROM `goods_en` [ RunTime:0.002778s ]
SELECT * FROM `goods_en` WHERE `status` = 10 AND `store_id` = 2 AND ( goods_id = '47' ) LIMIT 1 [ RunTime:0.001113s ]
SHOW FULL COLUMNS FROM `goods_category_rel_en` [ RunTime:0.002363s ]
SELECT * FROM `goods_category_rel_en` WHERE ( goods_id = 47 ) LIMIT 1 [ RunTime:0.000959s ]
SELECT `name` FROM `category_en` WHERE `status` = 1 AND `store_id` = 2 AND ( category_id = 17 ) LIMIT 1 [ RunTime:0.001336s ]
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.001210s ]
SHOW FULL COLUMNS FROM `spec_en` [ RunTime:0.002726s ]
SHOW FULL COLUMNS FROM `goods_spec_rel_en` [ RunTime:0.002657s ]
SELECT DISTINCT `spec_id` FROM `goods_spec_rel_en` WHERE `goods_id` = 47 [ RunTime:0.000976s ]
SELECT * FROM `spec_en` WHERE ( spec_id = 102 ) LIMIT 1 [ RunTime:0.001116s ]
SELECT DISTINCT `spec_value_id` FROM `goods_spec_rel_en` WHERE `goods_id` = 47 [ RunTime:0.001184s ]
SHOW FULL COLUMNS FROM `spec_value_en` [ RunTime:0.002643s ]
SELECT * FROM `spec_value_en` WHERE ( spec_value_id = 183 ) LIMIT 1 [ RunTime:0.000917s ]
SELECT * FROM `spec_value_en` WHERE ( spec_value_id = 184 ) LIMIT 1 [ RunTime:0.001070s ]
SELECT * FROM `goods_spec_rel_en` WHERE `goods_id` = 47 AND ( spec_id = 102 ) [ RunTime:0.001008s ]
SELECT `spec_value` FROM `spec_value_en` WHERE ( spec_value_id = 183 ) LIMIT 1 [ RunTime:0.000857s ]
SELECT `spec_value` FROM `spec_value_en` WHERE ( spec_value_id = 184 ) LIMIT 1 [ RunTime:0.000843s ]
SHOW FULL COLUMNS FROM `goods_sku_en` [ RunTime:0.002561s ]
SELECT * FROM `goods_sku_en` WHERE ( goods_id = 47 ) [ RunTime:0.001368s ]