SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109159 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109159 [ RunTime:0.002223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008859,446332,182631,55701,806205,751332,32952,79206,885915,579298,554485,737896,69879,454605,935900,409141,358299,952878,168886,362477,665343,805195,75582,466087,46497,1035845,636098,404530,806442,89004,925764,861404,607307,849473,279409,1005454,404900,1035580,446112,638211,475164,906484,800953,786160,557858,426010,515722,95313,364059,838532,746566,221016,863586,504157,986987,11950,337994,709955,898711,759290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]