SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003847s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349589 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349589 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505339,689404,821864,1025704,391022,741262,54926,246939,158799,664481,262953,121815,462243,788110,355635,559325,905200,382454,610659,667086,318725,995868,36647,417941,606420,813394,621354,895198,932493,880115,232148,882502,837463,909145,715393,35028,133093,454012,738794,223760,126893,182280,151278,115645,362449,310140,987986,412104,432002,904528,237394,284041,543456,987175,365215,830137,707644,960772,493324,478781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005923s ]