SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514552 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514552 [ RunTime:0.003415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680269,925486,58401,749970,368022,51192,244997,646809,478553,116721,845919,267948,481238,997773,481311,887511,107505,1020127,786602,241574,242648,306729,466836,92497,396024,77927,1037021,732411,487707,581722,843747,391433,267443,478178,777305,780345,713285,177033,1022310,585296,246212,414736,714,184550,471406,400359,168677,146751,525364,675835,412167,57885,280661,914874,59044,438176,925912,314987,465556,336761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001011s ]