SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4084 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4084 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180298,682703,49804,115790,913276,104797,731061,994470,170948,824244,998327,272804,154935,359470,117122,167558,1016100,760961,844241,733529,1038400,686061,352668,690123,182560,591017,704071,341986,665961,786496,636351,516445,44340,393543,14587,864635,280085,54424,595346,958490,978586,565522,933259,31529,767540,820816,589428,539565,451245,949402,882070,169020,576738,509879,38449,373040,645189,317861,154246,378989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]