SHOW FULL COLUMNS FROM `t_vat_code` [ RunTime:0.001438s ]
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.002882s ]
SELECT * FROM `t_goods` WHERE `vat_code` IN ('1030201030000000000','1030201020000000000','1030109050000000000','1030108020000000000','1030203010000000000','1030102030000000000','1030307060000000000','1030201010000000000','1040303020000000000','1040305990000000000','1090417050000000000','1090417010000000000','1090599000000000000','1090420990000000000','1090416010000000000','1090413020400000000','1030111990000000000','1090417020000000000','1090418050000000000','1090417990000000000','1090416990000000000','1090131030000000000','1090419990000000000','1030203030000000000','1030307990000000000','1010115030800000000','1010115020000000000','1010115030300000000','1010116990000000000','1010303039900000000','1060102030000000000','1070222020000000000','1070601010200000000','1040201010000000000','1070508010000000000','1070601060000000000','1030111070000000000','1030108010000000000','1010101000000000000','1010101030000000000','1010112120000000000','1030204000000000000','1030204020000000000','1030201000000000000','1030204010000000000','1030202000000000000','1030108040000000000','1030299000000000000','1030205000000000000','1030107010100000000') [ RunTime:0.006558s ]
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` = '1030201020000000000' AND `goods_name` LIKE '%%' [ RunTime:0.001621s ]
SELECT * FROM `t_goods` WHERE `goods_state` = 1 AND `goods_img` IS NOT NULL AND `goods_type` = 0 AND `vat_code` = '1030201020000000000' AND `goods_name` LIKE '%%' ORDER BY `goods_id` DESC LIMIT 0,24 [ RunTime:0.001430s ]
鄂ICP备2022011613号
首页
