SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319054 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319054 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345327,839546,103958,200299,333250,1036271,130749,634396,33462,763849,71200,949423,883171,771437,875270,922811,95424,219322,164512,901863,32256,119675,695092,840060,556173,874662,199209,621948,977585,97795,118705,345514,622865,626104,892253,644914,873011,732307,175808,690627,335614,765638,763934,664853,504678,74706,237601,753227,305424,975711,257184,850635,234414,137897,247395,787235,649545,428329,341305,382654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]