SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547445 LIMIT 1 [ RunTime:0.003811s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547445 [ RunTime:0.002938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229965,676197,771624,885784,557819,262015,645070,751177,400688,127756,40212,133899,392389,282821,850902,183250,870276,1025265,76624,1048566,668970,793430,1036087,512091,328397,259406,162875,575244,1034859,849025,999133,512881,597390,970395,492770,645565,514273,882257,761536,831213,319519,926034,417524,805497,499619,265399,104954,467667,198807,1027343,55332,196148,556230,113068,954918,648252,315328,485397,321407,459995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003462s ]