SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527481 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527481 [ RunTime:0.002971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016809,739357,161185,723116,438601,581285,375983,722907,378936,103603,61938,360738,862787,900513,560703,473047,973423,506345,848650,502972,137505,733834,193640,109794,749857,873134,981103,523904,831128,565981,738496,333526,530787,1034904,447392,692260,910840,690710,756760,239467,443290,455121,399056,550239,957148,1007456,719208,1009826,1026459,1012296,51742,331419,275237,925403,957579,145071,763384,653787,303099,524104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]