SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417516 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417516 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944518,229354,359601,101121,806889,430074,599715,829483,605947,71841,317574,774640,337210,786503,55245,588010,263299,880335,634826,664196,700376,512251,410099,1007306,1027933,360858,1027574,862854,476576,301209,259892,894880,267924,806005,651965,577935,38051,802003,179233,113636,426933,66304,200769,432834,878761,131270,354615,316318,270024,236054,669023,132394,185379,20249,225481,459328,641495,655486,347138,593525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]