SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025765 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025765 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27423,239345,524011,771406,876988,796314,78028,889668,155201,17399,902789,958441,25512,125868,249074,305380,485712,211688,394386,174182,131187,396072,942582,892359,523336,420379,600214,543316,192339,199106,726633,85151,689281,294881,219859,734354,96126,887520,270463,952614,246641,560575,780069,735879,859373,652625,1005038,697808,453693,514412,1017452,267694,176231,1010636,238336,933252,187655,790175,463522,382016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]