SHOW FULL COLUMNS FROM `km_goods` [ RunTime:0.000608s ]
SHOW FULL COLUMNS FROM `km_comment` [ RunTime:0.000477s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `km_comment` `count_table` WHERE `is_delete` = 0 AND `status` = 1 AND ( `count_table`.`goods_id` =km_goods.goods_id ) ORDER BY `create_time` DESC) AS `comment_data_count` FROM `km_goods` WHERE `goods_id` = 49 LIMIT 1 [ RunTime:0.000462s ]
SHOW FULL COLUMNS FROM `km_category` [ RunTime:0.000491s ]
SELECT * FROM `km_category` WHERE `category_id` = 12 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `km_goods_sku` [ RunTime:0.000447s ]
SELECT * FROM `km_goods_sku` WHERE `goods_id` = 49 ORDER BY `goods_sku_id` ASC [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `km_spec_value` [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `km_goods_spec_rel` [ RunTime:0.000458s ]
SELECT `km_spec_value`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`goods_id` AS `pivot__goods_id`,`pivot`.`spec_id` AS `pivot__spec_id`,`pivot`.`spec_value_id` AS `pivot__spec_value_id`,`pivot`.`create_time` AS `pivot__create_time` FROM `km_spec_value` INNER JOIN `km_goods_spec_rel` `pivot` ON `pivot`.`spec_value_id`=`km_spec_value`.`spec_value_id` WHERE `pivot`.`goods_id` = '49' ORDER BY `id` ASC [ RunTime:0.000251s ]
SELECT * FROM `km_comment` WHERE `is_delete` = 0 AND `status` = 1 AND `goods_id` = 49 ORDER BY `create_time` DESC LIMIT 20 [ RunTime:0.000256s ]
SELECT * FROM `km_category` WHERE `category_id` = 12 LIMIT 1 [ RunTime:0.000238s ]
SHOW FULL COLUMNS FROM `km_example` [ RunTime:0.000508s ]
SELECT `c`.*,`a`.`name` FROM `km_example` `c` INNER JOIN `km_category` `a` ON `a`.`category_id`=`c`.`category_id` WHERE `c`.`status` = '10' AND `c`.`is_delete` = '0' AND `c`.`category_id` = '15' ORDER BY `sort` ASC,`example_id` DESC,`c`.`create_time` DESC LIMIT 0,8 [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `km_advertise` [ RunTime:0.000501s ]
