SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022196 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022196 [ RunTime:0.002746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423311,193170,745854,892740,204774,880777,174289,888651,898489,400136,338296,996090,938480,408385,562635,877208,708032,66186,984981,107498,730981,1024045,109578,878643,1028259,631466,184579,168598,951811,543446,993461,762989,187132,188304,5128,735325,669669,372170,661208,531589,955306,978383,575348,603705,98573,915055,933526,153367,4808,363333,513015,935151,996848,918155,552643,531760,21843,682196,270515,414722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001438s ]