SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841954 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841954 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257811,1000626,1034722,544771,750461,148285,805820,850015,583002,279695,292940,357063,130595,138680,708,986884,300829,141549,801594,1012419,53075,442102,393709,908300,72390,559752,167431,291870,242629,944603,418053,693781,919920,475346,236850,559453,29834,799131,902243,462893,655546,764126,381347,1007237,642268,731672,255426,769833,1015044,478374,650207,291277,156023,588315,172745,506896,713912,91312,445051,910248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004440s ]