SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003921s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422104 LIMIT 1 [ RunTime:0.001621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422104 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493224,292257,109908,261116,877073,683808,674377,210569,817836,908505,454562,466938,851700,668444,149506,286853,970262,451100,1229,836544,152113,425653,79861,907287,473007,985007,893780,687909,963215,1021118,95512,335617,293832,298602,168910,317150,113816,670476,505850,43976,630084,288100,367642,837728,15814,372562,691681,327283,875820,57427,536331,133500,338090,754390,763958,718934,70823,92082,769599,411668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003561s ]