SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104853 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104853 [ RunTime:0.002840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419996,607815,602898,150209,501981,847512,841661,763748,920508,290081,970672,78665,641563,472103,514632,471660,308726,1020765,628886,225677,864006,658282,246160,491873,956913,554581,324375,21737,505868,189923,283218,233998,942515,751203,731260,670405,711778,935250,822887,191173,261772,582172,343453,602349,119218,875361,851582,602720,491711,618579,159397,444855,673908,700980,369460,588973,740491,429726,661666,829231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]