SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029791 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029791 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968412,754334,788847,559749,15359,760328,103266,157583,383424,62852,751622,714811,492100,313838,416460,79031,522432,1011500,470040,584572,361335,45176,816297,429974,414760,9696,908276,965523,334381,37537,905042,105789,920449,399025,13992,690420,681926,33647,864006,717445,159500,605403,906828,993564,506053,1044712,979378,498328,808295,314679,212615,429703,430305,684563,709859,965023,957260,581780,412216,70406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]