SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354828 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354828 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30178,539246,689955,361279,997754,713412,1037320,604463,593497,595711,270228,55590,893461,178814,934247,117407,136233,253751,425467,260340,907450,512131,127160,315802,114224,57363,433482,787087,182118,844295,530388,785816,203834,838193,260910,533200,622852,686034,468327,373248,227793,973473,694319,899620,860722,606475,875136,966016,912385,997821,990004,121945,589763,558672,647391,501191,259627,1025194,950084,802112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]