SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392341 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392341 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207577,341456,566795,367642,74036,366091,621570,287303,69322,586494,159309,687500,853104,991463,269971,54471,405425,116374,581706,818260,116485,1001056,179058,451390,631960,632900,135703,853568,1038872,110824,1025733,937128,298320,992793,446813,566254,793003,895971,838611,391939,709241,690465,556010,242022,442016,1032631,856040,938898,181202,465664,552475,715626,678898,412147,863084,453578,847623,734185,1014780,145832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]