SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433839 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433839 [ RunTime:0.002742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309198,150050,845310,986274,508836,612019,984167,266055,947854,757942,745690,577614,659266,400798,169998,53972,327418,314685,155627,132670,846049,857650,83225,126617,246669,915042,330815,881322,884592,328461,30643,783244,325374,316783,953187,1012304,900070,483135,950965,331587,458371,614655,510270,667946,952000,114846,893525,909042,402472,201540,22936,737388,508150,1040082,345762,63036,67215,143344,533400,868743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]