SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910143 LIMIT 1 [ RunTime:0.000857s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910143 [ RunTime:0.001236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041316,839474,482553,991810,613638,444663,475960,26569,472797,355423,58268,470172,1039817,449042,730871,385177,590470,761491,123066,55328,99010,380221,651155,982412,773452,801875,934638,1047593,513886,40069,892628,422409,1047704,221360,878255,986428,151058,506529,47521,807846,8573,329106,869658,1046277,758048,622821,446049,253442,753439,890744,1045892,319401,1033283,59237,403897,35473,761865,902262,799110,728796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]