SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043850 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043850 [ RunTime:0.003381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985322,367090,870316,721019,530416,626131,623971,532547,924446,844401,200717,399072,33245,103811,10388,533237,912937,841089,119476,938273,329676,478041,87816,714794,435097,1016198,786974,273272,134347,142387,804049,715260,105175,240661,617856,315928,595806,999496,238845,423869,394818,706337,439895,183816,679237,97348,82520,289733,378794,208113,60858,411236,105726,962475,794059,783561,994894,190774,589966,670418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]