SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261516 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261516 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644589,747495,312942,374125,511663,474237,172870,257534,603007,336102,634465,922063,784913,683364,873107,104759,398237,130892,16202,1012454,806800,867373,56167,361557,856763,408527,57795,369398,552121,829514,43111,452864,350061,199973,152688,479007,935862,903986,365487,18505,174876,937069,635479,59019,89164,414538,955710,100143,534717,575428,932867,705791,89146,241884,664868,504956,441800,348271,728393,984120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]