SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022111 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022111 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26524,860330,397343,710652,749007,261832,286479,146431,172245,794131,259710,709435,128671,391386,570795,840935,882160,632360,97965,957352,675841,168045,319386,867686,171224,177500,238857,725501,890318,330820,119891,443367,739656,1036520,167130,58171,478444,916553,430260,138381,766493,1038246,261213,518389,331713,528565,96382,585523,718724,621586,890872,334271,566220,863451,234347,169316,784279,708367,224740,1010212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]