SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 605584 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 605584 [ RunTime:0.003193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523143,816081,1013202,481937,467453,778759,534879,240338,687219,274826,356469,657407,809160,354504,544858,815905,287237,703749,336249,454875,455212,263588,269469,957643,597807,478388,726383,554475,924429,458417,716598,409801,859704,636026,487924,172121,783022,571704,237464,2381,876993,213415,284094,177126,604806,319145,2205,716279,826941,485123,137301,417393,340768,1040862,159551,941274,450513,34208,743057,741589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 605584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 605584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]