SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543194 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543194 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884483,814752,498620,436737,1026140,854749,91085,357652,454901,455107,542224,652468,92286,173978,1028589,786889,182008,76826,138993,57560,688709,194099,1040816,816813,646181,849337,867653,256827,50349,822075,531997,5391,1018642,145709,640382,62286,730794,152394,628549,163346,278169,352771,986014,397495,883651,291350,701274,443586,743041,891838,73327,434746,270746,282605,120849,281236,690642,736019,267947,233865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]