SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98380 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98380 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57697,672028,663481,222306,715475,132620,116157,486475,339580,1000882,901600,595033,709006,942202,106893,686511,478536,716990,882021,67631,495414,213400,613583,481017,345337,104614,99087,744287,1011428,427116,656770,1025000,485152,93744,712959,958984,87908,948095,446161,291367,1008588,614324,56771,178795,22600,1033976,765249,99387,706603,1012861,777310,460848,807203,190510,715274,301183,226321,388397,270803,388433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]