SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423411 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423411 [ RunTime:0.006533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277983,510759,727631,261170,24694,941995,1044670,549760,270649,918881,22982,504051,977573,740514,465958,842647,154075,346459,184553,831811,822024,40153,1035547,322296,1021093,520881,556183,798932,530356,788753,827821,600677,803898,335396,133264,959658,419436,296910,239330,656705,104623,78712,190169,4253,377938,663053,557814,787018,217995,492614,873816,39713,362339,58339,880646,948489,718497,955292,456653,655031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]