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` = 567455 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567455 [ RunTime:0.002516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124978,1044018,537772,175226,434540,203870,1038023,1002918,596603,629148,419763,744024,893072,346291,814348,655870,370952,807817,328299,444778,196919,521516,795283,998637,135740,997382,647319,154834,591820,732484,284342,57466,203078,922532,383824,745749,505528,727728,871395,985977,443034,975747,508015,697705,179996,945533,451101,280987,335490,629409,218532,336475,1027445,845712,243807,207866,508616,960731,133109,41224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]