SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201602 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201602 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287076,367631,693700,446327,246130,743872,785865,620827,1033021,986833,590497,153203,249113,325713,419977,849422,949390,74536,1004028,242146,322124,1033521,499098,584771,747828,857603,744949,179181,299357,887042,1013789,78155,474374,586120,3350,365169,107109,815801,148706,496845,741033,165249,247259,837945,316308,300195,984115,428562,552367,725218,858191,268949,933350,580862,337033,410944,709443,441342,47280,893847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]