SHOW FULL COLUMNS FROM `shop_site` [ RunTime:0.004214s ]
SELECT * FROM `shop_site` WHERE `lang` = 'zh-cn' LIMIT 1 [ RunTime:0.001239s ]
SHOW FULL COLUMNS FROM `shop_columns` [ RunTime:0.003362s ]
SELECT * FROM `shop_columns` WHERE `state` = 1 AND `lang` = 'zh-cn' ORDER BY `sort` ASC [ RunTime:0.001423s ]
SHOW FULL COLUMNS FROM `shop_news` [ RunTime:0.003636s ]
SELECT * FROM `shop_news` WHERE `lang` = 'zh-cn' AND `state` = 1 LIMIT 1 [ RunTime:0.001227s ]
SHOW FULL COLUMNS FROM `shop_news_category` [ RunTime:0.002970s ]
SELECT * FROM `shop_news_category` WHERE `lang` = 'zh-cn' ORDER BY `id` ASC [ RunTime:0.001364s ]
SHOW FULL COLUMNS FROM `shop_single_page` [ RunTime:0.003906s ]
SELECT * FROM `shop_single_page` WHERE `id` IN (0,18,19,21,22,23) AND `state` = 1 AND `lang` = 'zh-cn' [ RunTime:0.002844s ]
SELECT * FROM `shop_single_page` WHERE `id` IN (0,24,20,49) AND `state` = 1 AND `lang` = 'zh-cn' [ RunTime:0.001919s ]
SHOW FULL COLUMNS FROM `shop_link` [ RunTime:0.003697s ]
SELECT * FROM `shop_link` WHERE `state` = 1 ORDER BY `sort` ASC [ RunTime:0.001213s ]
SHOW FULL COLUMNS FROM `shop_lang` [ RunTime:0.003768s ]
SELECT `lang`,`name` FROM `shop_lang` WHERE `status` = 1 [ RunTime:0.001223s ]
SELECT * FROM `shop_columns` WHERE `state` = 1 AND `lang` = 'zh-cn' AND `tag` = 0 ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.001654s ]
SELECT * FROM `shop_single_page` WHERE `id` IN (0,18,19,21,22,23) AND `state` = 1 AND `lang` = 'zh-cn' [ RunTime:0.003195s ]
SELECT * FROM `shop_single_page` WHERE `id` IN (0,24,20,49) AND `state` = 1 AND `lang` = 'zh-cn' [ RunTime:0.001988s ]
SHOW FULL COLUMNS FROM `shop_category` [ RunTime:0.004403s ]
SELECT * FROM `shop_category` [ RunTime:0.001200s ]
SELECT * FROM `shop_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001625s ]
SHOW FULL COLUMNS FROM `shop_products` [ RunTime:0.005205s ]
SELECT COUNT(*) AS think_count FROM `shop_products` `p` WHERE `p`.`category_id` = '2' AND `p`.`state` = '1' LIMIT 1 [ RunTime:0.001407s ]
SELECT `p`.* FROM `shop_products` `p` WHERE `p`.`category_id` = '2' AND `p`.`state` = '1' LIMIT 0,24 [ RunTime:0.001545s ]
SHOW FULL COLUMNS FROM `shop_products_package` [ RunTime:0.003380s ]
SELECT * FROM `shop_products_package` WHERE `product_id` = 1 LIMIT 1 [ RunTime:0.001892s ]
SELECT * FROM `shop_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001117s ]
SHOW FULL COLUMNS FROM `shop_category_attributes` [ RunTime:0.003858s ]
SELECT * FROM `shop_category_attributes` WHERE `category_id` = 2 [ RunTime:0.001775s ]
SHOW FULL COLUMNS FROM `shop_attributes` [ RunTime:0.003692s ]
SELECT * FROM `shop_attributes` WHERE 0 = 1 [ RunTime:0.001697s ]
SHOW FULL COLUMNS FROM `shop_category_packages` [ RunTime:0.003717s ]
SELECT * FROM `shop_category_packages` WHERE `category_id` = 2 [ RunTime:0.001859s ]
SHOW FULL COLUMNS FROM `shop_packages` [ RunTime:0.003686s ]
SELECT * FROM `shop_packages` WHERE 0 = 1 [ RunTime:0.001561s ]
SELECT * FROM `shop_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001189s ]
SELECT * FROM `shop_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001535s ]
SELECT * FROM `shop_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001131s ]
SELECT * FROM `shop_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001252s ]
SELECT `m`.`id`,`m`.`name` FROM `shop_products` `p` LEFT JOIN `shop_manufacturer` `m` ON `m`.`id`=`p`.`local_manufacturer_id` WHERE `p`.`category_id` = '2' GROUP BY `local_manufacturer_id` [ RunTime:0.001702s ]