SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115043 LIMIT 1 [ RunTime:0.000780s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115043 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81002,1042621,91664,591608,879871,64147,916818,225131,47954,638623,44183,289130,285128,867926,817476,954123,479635,332206,145845,578032,994366,5360,345440,514288,203937,395927,512837,612196,658889,212493,244937,620825,903906,1010608,1043236,209936,348643,417624,464092,343336,833181,34896,982957,760946,909101,700356,417093,128533,84323,619054,973332,858331,463594,474741,523024,822001,14966,157255,963239,821118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]