SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510603 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510603 [ RunTime:0.005417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584464,397866,197636,1037790,47572,254973,409379,676579,659378,953541,54889,484967,1005628,663981,337937,385743,347565,361239,25619,736970,761128,236521,654866,777577,305593,840512,412130,248823,539436,784601,477368,372578,472237,957347,924366,769988,819592,861679,918941,1035900,730649,32035,454476,1041274,402223,700810,406902,139181,693111,173138,499601,955202,891413,798628,757094,529359,149373,576376,78593,175435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]