SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472694 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472694 [ RunTime:0.003292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329828,1009064,310558,421814,1013755,21320,892234,723114,492386,1047210,917708,21803,445470,927702,338062,237239,109421,674238,212448,216416,773049,115724,936848,1028877,469744,1031641,490263,717469,151661,753123,291056,407923,883847,546264,106547,591460,415561,668367,841689,17206,855063,794260,950486,124523,299511,901890,923273,443308,682890,436875,328205,946225,493354,424785,827002,896037,12484,270426,235189,385300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]