SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333981 LIMIT 1 [ RunTime:0.003499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333981 [ RunTime:0.002502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425052,728630,318761,743335,639864,178018,665110,830137,418983,257690,629890,370284,452015,501976,987155,310927,67227,353419,889937,417812,717479,667027,282556,56830,615057,564652,1010318,684284,687143,348277,847964,208210,546526,976615,750678,141021,356423,905074,627261,483768,194934,1005258,752986,448656,884979,939048,219970,378883,755439,930657,561872,729967,667796,57504,99395,404546,708454,1021639,501791,886790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]