SHOW FULL COLUMNS FROM `t_vat_code` [ RunTime:0.001520s ]
SELECT `VatCode`.* FROM `t_vat_code` `VatCode` JOIN `t_goods` `Goods` ON `VatCode`.`vat_code`=`Goods`.`vat_code` WHERE `Goods`.`goods_state` = '1' GROUP BY `VatCode`.`vat_code` [ RunTime:0.002344s ]
SELECT * FROM `t_goods` WHERE `vat_code` IN ('1030201030000000000','1030201020000000000','1030202030000000000','1030109050000000000','1030108020000000000','1030203010000000000','1030307060000000000','1030102030000000000','1030206040000000000','1030201010000000000','1040303020000000000','1040305990000000000','1090417050000000000','1090417010000000000','1090420990000000000','1090416010000000000','1090413020400000000','1090519060000000000','1030111990000000000','1090417020000000000','1090418050000000000','1090417990000000000','1090416990000000000','1090419990000000000','1030203030000000000','1030307990000000000') [ RunTime:0.004647s ]
SELECT COUNT(*) AS think_count FROM `t_goods` WHERE `goods_state` = 1 AND `goods_img` IS NOT NULL AND `goods_type` = 0 AND `vat_code` = '1030307990000000000' AND `goods_name` LIKE '%%' [ RunTime:0.001259s ]
SELECT * FROM `t_goods` WHERE `goods_state` = 1 AND `goods_img` IS NOT NULL AND `goods_type` = 0 AND `vat_code` = '1030307990000000000' AND `goods_name` LIKE '%%' ORDER BY `goods_id` DESC LIMIT 0,24 [ RunTime:0.001730s ]