SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201157 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201157 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164925,454451,24460,416477,906326,595145,391125,988485,152548,423293,200348,318993,582047,842296,259104,468249,611126,715684,571082,735197,465449,509663,844118,795448,830018,680225,483542,822564,305013,432373,708628,242163,856135,738399,187256,1040825,709933,1014341,486791,153747,377072,548378,982562,101610,391511,122148,615625,507151,809395,625246,605377,634969,804769,691930,820408,619139,876913,675002,745051,469810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]