SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417456 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417456 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400121,1031407,424138,291756,29461,261550,319363,501063,392279,1036605,914025,68852,975330,389258,108716,459357,480359,724159,360184,872605,890776,922407,244812,622873,545470,757074,746922,645827,1012153,424259,35377,332548,107177,762332,309832,445196,238708,103967,150468,243690,546747,838348,446114,127911,255148,571589,527464,432775,486393,39070,895474,460884,424377,470374,949864,945528,493288,481781,917529,140509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]