SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401723 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401723 [ RunTime:0.002729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292560,874160,924788,190845,16600,894656,467167,853882,112301,344127,338569,4623,790491,107622,476013,1012281,596040,744062,132523,501168,952332,21771,350955,318906,294581,317596,812630,610020,522012,902682,556267,394695,72753,590039,229900,625231,435146,41982,51347,159069,103162,674004,436637,119733,940609,479424,652721,24433,856371,872476,252677,181791,930842,356835,558109,940628,439875,903287,394416,568264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]