SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972684 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972684 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438505,282549,310140,650952,174530,1021521,220669,979973,712127,921100,784283,538870,839616,659558,243324,546175,626276,228855,3334,178936,297103,477016,116229,957302,844954,416899,391836,716533,745744,64433,490442,900107,857671,38766,5911,665444,699600,921190,822115,204760,305965,650040,242399,466299,384835,950998,853199,46980,359976,746433,663615,623201,425953,141377,880420,18491,924911,467849,118453,549788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]