SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424356 LIMIT 1 [ RunTime:0.001283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424356 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463631,1022404,711773,452555,502928,348344,907508,988113,454295,944446,300182,86620,616492,54012,78068,407429,923229,105662,695096,371359,459442,279438,779503,590318,704533,289885,891692,963482,461846,73405,34579,982101,509286,1009134,374634,661461,678354,444384,30225,543943,312406,551553,392600,371773,385023,344698,444925,967030,848708,859646,942684,201765,396307,241435,892375,234704,561852,92178,177219,448896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424356 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424356 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]