SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020881 LIMIT 1 [ RunTime:0.001421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020881 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784615,412062,165121,690588,188137,692000,986909,466158,378177,934143,959367,271330,818131,494800,1007957,906504,640185,913890,1038075,640599,783679,801295,930675,492625,542719,981165,794454,424020,105840,423300,431432,486562,414253,271687,165566,841981,407710,700873,12431,646680,226500,376012,441781,524388,12862,950096,776741,653983,88883,692024,454625,474545,909539,827270,663748,986879,313437,833707,126882,28904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]