SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002810s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479823 LIMIT 1 [ RunTime:0.001171s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479823 [ RunTime:0.004077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317643,10094,61888,384497,1034717,673149,11561,335200,474036,553703,871228,817665,61385,675468,270629,216135,100128,111384,855133,600480,148087,900490,1028972,931764,647697,564203,638013,678474,1019299,96676,196109,104712,1028438,99074,403796,465612,904236,683159,658848,1013508,33152,310846,464082,413600,300628,329951,60225,849853,944826,117518,1029217,423015,305947,121068,869949,825559,64187,902627,664229,961629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]