SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012896 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012896 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359109,484688,957922,697404,582744,892489,767720,511455,359168,658763,1013728,434333,41896,624364,283530,270772,618335,251945,1038979,504974,203552,248113,761691,205092,488395,443878,317227,823129,626203,622278,868589,215595,970620,526419,958304,109104,58599,449156,134633,545310,321013,639014,15175,858002,185251,1011078,504095,514854,939824,288840,155287,946247,771158,689574,955482,443627,697981,357951,556671,578315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003920s ]