SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463307 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463307 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366267,741835,706924,865717,587967,812518,539866,1004508,581375,590503,152084,827088,718767,610192,278030,417244,727872,361818,229312,1016546,243755,645294,788002,216844,1021045,600315,268367,587216,505851,852636,106657,825168,337471,818147,757324,392479,260470,60300,415680,202875,535013,534833,928213,614520,1038105,668784,428742,93415,141838,109392,348245,115762,672945,947295,227592,806920,461863,828573,406494,242138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]